2.7 Integrating Stream Analytics with Oracle GoldenGate
Follow the below steps to integrate Oracle Goldengate with Stream Analytics:
- 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. - 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/jre/lib/amd64/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_19.1.0.0.0
- KAFKA_HOME – set this variable to the path where Kafka is installed. Example :
- Start the manager process on port 7801.
For installation steps, see Installing GoldenGate for Big Data.