aspose file tools*
The moose likes JDBC and the fly likes Loading/Fetching data from SAP (ERP) to SQL Server 2005 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Loading/Fetching data from SAP (ERP) to SQL Server 2005" Watch "Loading/Fetching data from SAP (ERP) to SQL Server 2005" New topic
Author

Loading/Fetching data from SAP (ERP) to SQL Server 2005

Sirish Kumar Gongal Reddy
Ranch Hand

Joined: Oct 25, 2004
Posts: 109
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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Loading/Fetching data from SAP (ERP) to SQL Server 2005