'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?
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!