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