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