March 15, 2012 at 4:56 am
My task is to implement an ODS solution using SQL Server 2008
I have got the following environment:
Source: SAP
Target (ODS): SQL Server 2008
ETL Tool: SSIS 2008
What is the best way to implement a CDC which that gets data from SAP and updates SQL 2008 ODS target?
Note that all I can do is to read data from the source (SAP) and can not make any changes to it
Any help will be appreciated
March 15, 2012 at 6:46 am
Do the tables in SAP keep record of the changes somehow? (for example a LastModified column?)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 15, 2012 at 6:55 am
If SAP is running on SS2K8 then you may be able to rely on the SS2K8 native CDC feature.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply