Prerequisites for Azure Database for MySQL extract with Oracle GoldenGate

Question

Hi team,

Do you know, what would be the prerequisites for preparing replicating data to/from Azure Database for MySQL using Oracle GoldenGate ? Is there anything that should be done, like: enabling supplemental log, changing any server parameters, any special permissions that should be allowed ?

I am asking because I am trying to use Oracle GG as a replication tool, and it still doesn't allow me - constantly asking for "Confirm that the log file exists, that the path is correct, and that the correct permissions are set for Oracle GoldenGate."

Can you help me with that?

Thanks in advance!

Alex P

Answer 1

@Porcescu Alexandru

Welcome to Microsoft Q&A and thank you for posting your question here!!

About the prerequisites for preparing replicating data to/from Azure Database for MySQL using Oracle GoldenGate. The following will be helpful:

1. Get more information and step by step guides from Oracle community for Oracle GoldenGate and Microsoft community here. The links provide guides to use Oracle GoldenGate with Azure Database. Workloads Data Integrations Golden Gate Golden Gate 2
2. Get more information and step by step guides about the prerequisites and how to prepare and replicate data to/from Azure Database in this link: You might eventually do without Oracle GoldenGate. How to Data Replication

Hope this is helpful.

Have a good success and kindly let us know if the above helps or you need further assistance on this issue.

Regards,

Sina