{"id":7576,"date":"2016-04-16T21:12:01","date_gmt":"2016-04-16T19:12:01","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/a-short-glance-at-attunity-replicate\/"},"modified":"2016-04-16T21:12:01","modified_gmt":"2016-04-16T19:12:01","slug":"a-short-glance-at-attunity-replicate","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/a-short-glance-at-attunity-replicate\/","title":{"rendered":"A short glance at Attunity replicate"},"content":{"rendered":"

By Franck Pachot<\/h2>\n

.
\nIf you follow my blog, you should know that I really like Dbvisit replicate because it’s simple, robust, has good features and excellent support. But that’s not a reason to ignore other alternatives (and this is the reason of https:\/\/www.dbi-services.com\/news-en\/replication-event-2\/<\/a>). When you have heterogeneous sources (not only Oracle) there is Oracle Golden Gate with very powerful possibilities, but maybe not an easy learning curve because of lack of simple GUI and setup wizard. You may need something more simple but still able to connect to heterogeneous sources. In this post, I am testing another logical replication software, Attunity replicate which has a very easy GUI to start and has connectors (called ‘endpoints’) for lot all databases.
\n
\nI’m trying the free trial version, installed on my laptop (Windows 10) and accessed through web browser. Here is how the Attunity Replicate architecture looks like:
\n\"CaptureAttunity0000\"<\/a>
\nBulk reader\/loader are for initialization, CDC is the redo mining process and Stream Loader the one that applies to destination. Those are connectors to RDBMS (and other source\/destinations). A common engine does the filtering and transformation.<\/p>\n

Replication profile<\/h3>\n

I define a new replication task where my goal is to replicate one simple table, EMP2, a copy of SCOTT.EMP:
\n\"CaptureAttunity0101\"<\/a>
\nThis task will do the first initialization and run real-time replication.<\/p>\n

Source database<\/h3>\n

I need to define the databases. Interestingly, there is nothing to install on source and destination. The replication server connects only through SQL*Net:
\n\"CaptureAttunity0102\"<\/a>
\nI use SYSTEM here for simplicity. You need a user that can access some system tables and views, be able to create a directory,read files, etc.<\/p>\n

That’s probably defined in the documentation, but I like to do my first trial just by exploring. In case you missed one, don’t worry, the ‘test’ button will check for everything. Here is an example when you try to use SCOTT:
\n\"CaptureAttunity0115\"<\/a>
\nV$LOGMNR_LOGS… That’s interesting. LogMiner may not be the most efficient, and may not support all datatypes, but it’s the only Oracle supported way to read redo logs.<\/p>\n

Advanced tab is very interesting about it as it shows that there are two possibilities to mine Oracle redo stream: use LogMiner or read binary files (archived + online from source, or only archived logs shipped to another location). It supports ASM (and RAC) and it supports encryption (TDE).
\n\"CaptureAttunity0103\"<\/a><\/p>\n

I’ve unchecked ‘automatically add supplemental logging’ here because it’s something I want to do manually because it requires an exclusive lock on the source tables. You can let it do automatically if you have no application running on the source when you will start, but that’s probably not the case. Doing it manually let me do this preparation off business hours.
\nThe problem is that you have then to run it for all the tables:<\/p>\n