Copy Tables between SAP's SQL DB to third party SQL db

[Former Member]

Hi All,

We have a requirement in which we have to extract selection fields from Material master, material BOM's, Process orders, material selling prices, etc.. from our SAP system ( runs on SQL DB )and send it to a non-SAP SQL db. What would be the recommended approach here. Our non-SAP IT staff wants to copy the tables at the DB level, but our SAP resources suggest that a program be written to do the extract. Kindly advice which is the best and recommended option. The data has to be sent periodically.

Regards,

S

[former_member193399]

It is always not a good practice to access the base tables directly for any reason. You can either write a program or research on SQL Server Integration Services (SSIS) and identify OLE DB drivers to connect to SAP System. I know you can connect to SAP BW from SSIS using SAP BW OLE DB Driver. You can also connect to SAP System from .NET applications. I hope this information helps you.

Regards

RT