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