Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

From Oracle to SQL Server real time Expand / Collapse
Author
Message
Posted Friday, November 15, 2013 2:21 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, January 26, 2014 11:03 AM
Points: 3, Visits: 41
Hi

When certain data change in a Oracle table, I wish to move the changed data to a SQL Server immediately.

Can Oracle trigger a call to a SSIS package, or to the SQL Server Agent.

Is there other ways to call a SSIS package from Oracle when a change appears?
Post #1514861
Posted Sunday, November 17, 2013 4:12 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 3:07 AM
Points: 6,932, Visits: 12,655
You might want to ask this in an Oracle forum.
The question is related to the source (Oracle) and not to the target (SSIS or SQL Server).
Anyhow, the solution won't be "real time" just "near time".
If the source would have been SQL Server I probalby would use Query Notification. Not sure, if such a technology is available in Oracle.




Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function
Post #1514968
Posted Sunday, November 17, 2013 5:33 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 11:56 AM
Points: 221, Visits: 1,692
Why SSIS, try a replication? Check this:
http://blogs.msdn.com/b/sqlserverfaq/archive/2008/10/16/step-by-step-procedure-to-implement-sql-server-transactional-replication-with-oracle-as-publisher.aspx
Post #1514976
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse