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