Hello there, I have my dedicated database (SQL Server 2005) for my java web application but I wanted to get/fetch the data from SAP (ERP system) which holds typically an ecommerce data (Sales,price and inventory data) say daily once as a batch process. What will be the best approaches to deal with this task?
The sub task I have identified is,
1) Map the tables of my local database with SAP Tables.(I think this might be the fist thing I needs to to) 2) After mapping load respective data into respective tables.
Any suggestions will be appreciated much.
Many thanks, Sirish
subject: Loading/Fetching data from SAP (ERP) to SQL Server 2005