Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sonika
Starting Member
1 Post |
 Posted - 2009-05-27 : 00:12:32
|
| I want to knowa. how to fetch the data from SAP to SQL Database daily basis ?b. At my PC I have only SQl database,while SAP databse is on other PC.so what other s/w I need to install at my PC ?C. Is it possible without any installation I can fetch data (by writing program, we are using Java)?sonika |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2009-05-27 : 01:51:28
|
| What database is being used for SAP? Is it sql server?Probably best to use SSIS for this - maybe openrowset for small datasets.If it's SQL server you shouldn't need to install anything.The bigger problem is finding out what the data in SAP represents as it's up to the business as to what the columns are used for.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Fetch the data from SAP to SQL database