Installing Attunity Replicate on Linux

*** apologies for the audio - crappy built-in laptop mic *** Instructional video on how to set-up and install Attunity Replicate on Linux. Replicate is a data integration tool for Change Data Capture. In this video I show how to install Replicate itself and the ODBC drivers for Oracle and SQL Server. Replicate can support many other sources and targets, I chose these to demonstrate the platform's ease-of-use. Building a Linux Attunity Replicate Server - For Oracle to SQL CDC Replication Sales slide for overview before getting started Installing Replicate Installing Oracle Instant Client - note that the Source database has already been enabled with supplemental logging enabled Installing SQL Client Configuring Environment Variables: export LD_LIBRARY_PATH=/opt/attunity/replicate/lib:/usr/lib64 export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib/oracle/12.2/client64/lib export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/microsoft/msodbcsql/lib64/ export ORACLE_HOME=/usr/lib/oracle/12.2/client64 Opening Firewall Ports - 1433 for SQL Server - 1521 for Oracle - 3550-3552 for Replicate server/UI - is this necessary? - 80,443 for Console and AEM REST API access sudo firewall-cmd --zone=public --add-port=3550-3552/tcp –permanent sudo firewall-cmd --zone=public --add-port=443/tcp –permanent sudo firewall-cmd --zone=public --add-port=1521/tcp –permanent sudo firewall-cmd --zone=public --add-port=1433/tcp --permanent sudo firewall-cmd –reload Checking the service is running - service areplicate status - stopping and starting source arep_login.sh ./repctl SETSERVERPASSWORD BLAHBLAHBLAH Add the . /opt/attunity/replicate/bin/arep_login.sh script to the .bashrc Adding a license Creating endpoints - Oracle - SQL Server Testing the task #ChangeDataCapture #Linux #Software #DataReplication #DataIntegration #BigData #Attunity #Qlik #Education #CDC