Question:
Hi,
I got the following sceanario: there's machine related data in SAP (user defined tables as SAP's CS didn't solve our requirements), which has to be used in another system based on MS SQL Server.
Until now I have a report which downloads the data (selection citeria is updat in each SAP table) to my workstation. This *.txt are imported into Access which updates the SQL server using ODBC.
Does somebody have a suggestion how to do this auotmatically?
a) run a job on SAP which automatically updates SQL?
b) use an access query extractings SAP data (ODBC) and updates SQL?
c) anything else?
Any help greatly appreciated!
_________________
Juergen Limbach
Answer:
I have seen people doing using Native SQL. Try searching forum. Note: I have never been able to do this cause we run on an AS/400. I was told by SAP that you must have a windows based app server in your landscape.
Regards,
R Heilman
Answer:
Well, then I've got the same problem.
Our SAP is based on HP-UX / Oracle (only the system which needs values from SAP does use MS SQL Server).
_________________
Juergen Limbach