Prerequisites for Azure Database for MySQL extract with Oracle GoldenGate

Porcescu Alexandru 0 Reputation points
2023-01-25T17:57:46.2+00:00

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

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
671 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Sina Salam 2,216 Reputation points
    2023-01-25T23:33:25.2833333+00:00

    @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