sap to sql transfer.
'Scuse my ignorance - but I don't know who to start asking.
I am presented with the following situation: A global company running their HR on SAP needs to update a SQL backend (a simple staff table) consisting of only title, name, surname, department, telephone and extension numbers.
Now my question is: how do I migrate the data from SAP to SQL on a daily schedule using an ODBC connection as well as ensure that the process remains a non-intrusive exercise on their systems. In other words, read only but do not modify. Is there some sort of "poller" available, and is DTS the most suitable solution?
Software/Hardware used:
Software/Hardware used:
ASKED:
November 7, 2004 7:25 AM
UPDATED:
November 8, 2004 12:50 PM
Answer Wiki:
what level of involvement from the SAP programmers is avilable ?
Simplest but involves SAP:
Extract of recent updtates from SAP as a CSV, transsfer file, small VB6 or VB.NET service / program to update SQL.
Or
small VB6 or VB.NET service / program to read SAP & update SQL.
David L.
To see all answers submitted to the Answer Wiki: View Answer History.
I use the following at a few clients.
1. Install ODBC drivers for SAP onto the SQL server
2. Open SQL Server Managers and goto the data tranformation section and create a data transfermation job to read the SQP data and write it to the SQL server. You will need to run the job once to create the table in SQL server if it is not there.
3. Modify the job so that you add a delete from SQL TABLE. You will need to delete all the data in the SQL table each day before you bring in the data from SAP.
4. Once this is working without any issues running it manually then schedule it. You will have to make sure that the SQL AGENT service is running. That can be found in the manangement section. You will be able to chenge the scheduled times etc in this section.
The first time you do it it will take a little bit of playing around to know exactly how to do this.
Good luck.
madkahuna