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 Java 8 in Action this week in the Java 8 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
jdbc + swing
Generic WebService Client
ERP (SAP) Vs J2EE
How to use Java in ERP software?
No Current Row in the ResultSet when Migrating from SQL 2000 to 2005