Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

ODI vs GG, several targets

MiumiuAug 16 2024 — edited Aug 16 2024

Hi all,

we are working now with ODI and moving data to Oracle db, MS SQL db and json (Kafka). Basically it works well but it's a bit slow and we're thinking could GoldenGate solve this problem. Our mappings are pretty simple, mainly 1:1 so that shouldn't be an issue.

Documentation says that Kafka needs GG for BigData. How does it differ from basic GG, is it just a “more money on the table”? Can we use the same installation for moving data to Oracle and MS too?

Thanks in advance! :)

Comments

Veera-Oracle Aug 22 2024

@marim Oracle GoldenGate has different binaries for different sources or targets (different databases / nosql databases). If you want to configure replication between an Oracle database and Kafka, then you need to install Oracle GoldenGate for Oracle Database and Oracle GoldenGate BigData for Kafka.

Currently, the name of the Oracle GoldenGate BigData has been changed to Oracle GoldenGate for Distributed Applications and Analytics.

There is a concept called Deployments in OGG Microservices which is not available in Oracle GoldenGate Classic architecture. Assuming that you are GoldenGate Microservices. Classic Architecture is completely de-supported from OGG 23ai version. So, it is only Microservices from this version.

You can perform one core installation of OGG Microservices and create multiple deployments which can be for different databases. The core OGG has the Service Manager and under this one Service Manager, you can create multiple deployments. One for Oracle and one for SqlServer.

However, I would suggest to perform different installation and have dedicated Service Manager for each source and target since they are different database flavors.

Thanks, Veera

1 - 1

Post Details

Added on Aug 16 2024
1 comment
101 views