'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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!