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


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Loading/Fetching data from SAP (ERP) to SQL Server 2005
 
Similar Threads
How to use Java in ERP software?
No Current Row in the ResultSet when Migrating from SQL 2000 to 2005
jdbc + swing
ERP (SAP) Vs J2EE
Generic WebService Client