sap to sql transfer.

pts.
Tags:
Development
Networking
'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?

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Madkahuna
    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
    15 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following