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 |
|
leifthoreson
Starting Member
16 Posts |
 Posted - 2006-01-11 : 13:30:12
|
| Greeting one and all.And thanks for your help.Has anyone been able to run a DTS of data from MSSQL to SAP ?Is it even possible?Thanks |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-01-11 : 14:43:45
|
| do you mean SAP R/3?This could be quite difficult simply because the SAP schema is so hard to understand. DTS would allow you to connect to the underlying SAP database (on oracle, db2, MSSQL, or whatever) and you could insert/update/delete data there. However, since you aren't putting this data in place through the SAP application you could run into huge problems.What do your Basis people say to this? I think they would probably have a real problem with this, I know I would.-ec |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-01-11 : 20:05:07
|
| I agreed with ec. It is better to place your data in a staging tables and get SAP programmer to do write some ABAP program to pickup the data. I don't think anybody want to be reponsibled for any disruption to a ERP system.-----------------'KH'Only two things are infinite, the universe and human stupidity, and I'm not sure about the former. |
|
|
|
leifthoreson
Starting Member
16 Posts |
Posted - 2006-01-12 : 11:06:18
|
| khtan & eyechartThank you for the replies. Long story short. The company I work with uses SAP R/3. Some time ago I was involved in a project in which they wanted data copied from SAP into a sql database to be used by some third party software. Our final solution was to have the data exported on a daily schedule to a text file on the sap server ( this was done by some of our sap developer/ basis group) and then the text files are ftp'ed to our sql server where a scheduled dts imports the data. Of course projects always grow. And now we are being ask how we can get data from the sql database into SAP. We do have a method using XMII ( a software once owned by Lighthammer, now owned by SAP) but the software is cumbersome. And I was asked "Why don't you just export the data using sql" to quote my boss. khtan, your reply has sparked a great train of thought in my mind, (be that train simple, understated, and something I should have considered). Exporting data to a mssql table and having the basis team design a scheduled abap program to upload to sap from that table.(I know very little about sap, I assume a abap program could connect and read data from mssql?)Thanks again |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-01-12 : 12:23:02
|
| I think khtan was suggesting that you use DTS to take SQL Server data and put it into a staging table in your SAP R/3 schema. THen have your SAP programmers write an ABAP that takes that data into SAP. That way you are basically going through the front door of SAP. This is then more easily monitored by your basis people, and all the business rules and such that SAP needs to enforce are enforced.This is a fairly typical approach, or atleast it was in the past. Now many shops use middleware for this. Like tibco, webmethods, or SAP XI. Those approaches are expensive and require an infrastructure but scale well, whereas the DTS to staging table approach is cheap and easy to implement but can be messy in the long run if you have a lot of interfaces.-ec |
|
|
|
Batista
Starting Member
1 Post |
Posted - 2009-03-06 : 02:21:04
|
| Here is a new social network site www.sapforall.netJoin for FREE and let's start your SAP Consultant career. |
|
|
|
|
|
|
|
|
SAP and MSSQL DTS jobs