This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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 Android Security Essentials Live Lessons this week in the Android 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
 
Don't get me started about those stupid light bulbs.
 
subject: Loading/Fetching data from SAP (ERP) to SQL Server 2005
 
Similar Threads
Generic WebService Client
How to use Java in ERP software?
ERP (SAP) Vs J2EE
jdbc + swing
No Current Row in the ResultSet when Migrating from SQL 2000 to 2005