August 24, 2016 at 3:15 am
Hi everyone.
My goal is to construct a system that can replicate in realtime a change from a Source System in db2 z/os -Mainframe,to a SQLServer 2014 database.
The system as to do it in real time, in a reactive approach: When a change happens at a source table, it should be automatically replicated to the target table.
Doing it with trigger is out of option, because of performance issues, Oracle Golden Gate is also out of option due to high acquisition costs.
I know that with Atunity I am capable of extracting data from DB2. But the only way that I am aware of starting the process is to ask SQLAgent to start the extraction process every 1 second.
- How can I make SSIS reactive to a change at the source system, and start the extraction process?
- Do someone know any alternative approach to what I intend to do?
*the final goal is not a Data Warehouse but a Master Data Management System, but I believe they can be similar in the Integration process of data.
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply