2.6 Integrating Stream Analytics with Oracle GoldenGate

Follow the below steps to integrate Oracle Goldengate with Stream Analytics:

1. Download and install Oracle GoldenGate Big Data. For a compatible version of Oracle GoldenGate Big Data, see the latest certification matrix.

   Note:

   Install Oracle GoldenGate Big Data on the same machine and with the same user as OSA.
2. Set the following environment variables:
   • KAFKA_HOME – set this variable to the path where Kafka is installed. Example :export KAFKA_HOME=/u01/app/kafka.
   • LD_LIBRARY_PATH – set this variable to the directory path that contains JVM shared library.

     Example: export LD_LIBRARY_PATH=/u01/app/java//lib/server:$LD_LIBRARY_PATH

   • GGBD_HOME – set this variable to the path where Goldengate for Bigdata is installed.

     Example: export GGBD_HOME=/u01/app/OGG_BigData_Linux_x64_23.1.0.0.0

3. Start the manager process on port 7801.

For installation steps, see Installing Oracle GoldenGate for Distributed Applications and Analytics.