Stack Overflow
Stack Overflow

Questions tagged [oracle-golden-gate]

Oracle Golden Gate is a heterogenous real-time data integration product. Use this tag for questions related to configuration or scripting of this tool.

Golden Gate supports numerous databases (e.g. Oracle, DB2, SQL Server, Ingres, MySQL) and extracts data from them in real time. Replicator plugins exist for all the supported databases, allowing real-time data synchronization among different databases. In addition, generic CSV and Java plugins are supported, allowing for custom processing/replication of extracted data.

154 questions
5
votes
1 answer

How can be handle oracle decimal types with GoldenGate "Kafka" / "Kafka connect" handler?

I wanna use Oracle GoldenGate (it's orcale cdc tool) to integrate oracle with Kafka. i have find a two Handler: http://docs.oracle.com/goldengate/bd123110/gg-bd/GADBD/using-kafka-connect-handler.htm#GADBD-GUID-81730248-AC12-438E-AF82-48C7002178EC…
Grigoriev Nick
  • 1,099
  • 8
  • 24
5
votes
1 answer

How do I write a Java adapter for Oracle GoldenGate?

According to this whitepaper [1], Oracle GoldenGate for Big Data ... also includes Oracle GoldenGate for Java, which enables customers to easily deliver to additional big data systems and support specific use cases that their environment…
Mark Harrison
  • 297,451
  • 125
  • 333
  • 465
5
votes
1 answer

Oracle change-data-capture with Kafka best practices

I'm working on a project where we need to stream real-time updates from Oracle to a bunch of systems (Cassandra, Hadoop, real-time processing, etc). We are planing to use Golden Gate to capture the changes from Oracle, write them to Kafka, and then…
EugeneMi
  • 3,475
  • 3
  • 38
  • 57
5
votes
1 answer

Oracle AQ - Queue Message replication

We are upgrading our infrastructure and for that we are migrating from Oracle 10g to 11g. We are using Oracle GoldenGate for data replication and it does not support replication of AQ messages as far as we know. For Persistent queue, we have…
Ahsan Shah
  • 3,931
  • 1
  • 34
  • 48
3
votes
1 answer

Golden Gate don't sync all records

I Have some OGG processes configured. For most of the tables the Initial Load (sourceistable - specialrun) replicates all the data. For a small group of tables the Initial Load Extract stops without any error and with only partial data sync to the…
Rabbit
  • 152
  • 2
  • 11
3
votes
0 answers

Continuent tungsten to kafka

We are working on one project where we required Oracle data to be stored at Cassandra. For storing the data in Cassandra we are proposed to first get the data from oracle to apache kafka MQ server then did manipulation with spark and save into…
Gaurav Rana
  • 54
  • 3
2
votes
2 answers

Goldengate error message Unable to add schematrandata

Following a tutorial to configure GoldenGate with Kafka, in sqlplus I created my GoldenGate user ggadmin and granted the privileges below: CREATE USER ggadmin IDENTIFIED BY ggadmin; GRANT CREATE SESSION, CONNECT, RESOURCE, ALTER SYSTEM TO…
cece
  • 21
  • 2
2
votes
1 answer

OracleGoldengate BigData for Kafka does not produce UPDATE messages

I'm experimenting with OGG BD (v12.3.2.1.1) to propagate all changes from an Oracle DB (11.2.0.4) to Kafka topics. I got the basic setup all working, and INSERT and DELETE to the schemas/tables I'm monitoring are captured and produce Kafka messages…
jammann
  • 690
  • 1
  • 6
  • 22
2
votes
4 answers

GoldenGate Replicat not putting all Columns in After

I have GoldenGate for Oracle(123015)'s Replicat process set up to get changes from the Oracle 12c database. I'm able to get all INSERT/UPDATE/DELETE changes to the trail files. However, during the UPDATE operation, the After section of the record in…
Harry
  • 43
  • 8
2
votes
0 answers

How to replicate and sync a MySQL to graph database

I need to replicate and continuously sync a MySQL database to a graph database, to further query and analyze data from an eCommerce application. Came across DZone Article which talks about syncing data between oracle and Neo4J. They are using Oracle…
the-petrolhead
  • 597
  • 1
  • 5
  • 16
2
votes
1 answer

I have Golden Gate on oracle 12c. Is it possible to get subset of data (like Where condition) from source to replicate

I have Golden Gate on oracle 12c. Is it possible to get subset of data (like Where condition) from source to replicate in the target database. Second question: Is it possible to replicate data using golden gate in to two different databases if so…
venkat
  • 21
  • 1
2
votes
3 answers

Apache Kafka vs Oracle Goldengate for remote data streaming

Regarding a data consolidation scenario, are there any comparative analysis that compares Apache Kafka and Oracle Goldengate for remote data streaming? In the scenario, we have to integrate sensory structured data from multiple (~100) sources to a…
Soheil
  • 473
  • 9
  • 23
2
votes
1 answer

Can Oracle golden gate adapter read trail file which generated by Extract or Pump process?

I am researching OGG, Can Oracle golden gate adapter read trail file which generated by Extract or Pump process? Most example I can find is OGG adapter works for replication process on delivery server, I just wanna apply the adapter whatever via…
Jerome tan
  • 155
  • 1
  • 1
  • 10
2
votes
3 answers

Oracle Golden Gate Version 12.1.2 DBLOGIN throws error

I am not able to login in GGS_OWNER from within GGSCI. I am able to login from sqlplus but when I try to login thorugh GGSCI it throws an error: GG Version: 12.1.2 Database version: 12c Type of replication: Integrated Capture Replication…
Rahul Malireddy
  • 31
  • 8
2
votes
2 answers

Checkpoint table does not exist even after creating it

I have created checkpoint table ggate for replicat rep1 but still I am getting following error: 2014-09-04 23:38:21 ERROR OGG-00446 Oracle GoldenGate Delivery for Oracle, REP1.prm: Checkpoint table ggate.checkpoint does not exist. Please…
mahan07
  • 887
  • 4
  • 14
  • 32
1
2 3
…
10 11