SAP to SQL transfer.

pts.
Tags:
SAP
'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 our software's 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.

H1,

I don’t have much knowlede on SAP. I request you to ask someone who has much knowlede on SAP. Thanks

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
  • DomGau
    Probably many ways to do this, but I would be tempted to look into setting up a regular job in the SAP system to extract the data and send to the receiving system. SAP could read its own data using its own tools (HR data in SAP is not so straight forward as other data in SAP) and dump out either directly to the recieving database or to an intermediate database or file. Your software could then take it in in whatever manner is most appropriate. If you want to query the SAP database directly you will have to have a good understanding of the data structure and rules of that data. You will also be at the mercy of any SAP patches or upgrades, or configuration changes that the global company makes. Getting the extraction routine running on the SAP side would alleviate much of this pain.
    0 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