topic Connect to another SQL server from SAP in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/connect-to-another-sql-server-from-sap/m-p/6962502#M1490115 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I want to connect SAP to another SQL server. Basically each day I need to take data from 2 tables in SAP tables to another sql server. I want this to be automated via a program in SAP.</P><P></P><P>Please suggest me some methods to achieve this.</P><P></P><P>I have searched the web and found that this is possiable, some transactions such as DBCO was mentioned, but it was not much helpful.</P><P></P><P>Thanks a lot.</P><P></P><P>Regards,</P><P>Pankaj</P></BODY></HTML> Wed, 23 Jun 2010 18:55:12 GMT Former Member 2010-06-23T18:55:12Z Connect to another SQL server from SAP https://community.sap.com/t5/application-development-and-automation-discussions/connect-to-another-sql-server-from-sap/m-p/6962502#M1490115 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I want to connect SAP to another SQL server. Basically each day I need to take data from 2 tables in SAP tables to another sql server. I want this to be automated via a program in SAP.</P><P></P><P>Please suggest me some methods to achieve this.</P><P></P><P>I have searched the web and found that this is possiable, some transactions such as DBCO was mentioned, but it was not much helpful.</P><P></P><P>Thanks a lot.</P><P></P><P>Regards,</P><P>Pankaj</P></BODY></HTML> Wed, 23 Jun 2010 18:55:12 GMT https://community.sap.com/t5/application-development-and-automation-discussions/connect-to-another-sql-server-from-sap/m-p/6962502#M1490115 Former Member 2010-06-23T18:55:12Z Re: Connect to another SQL server from SAP https://community.sap.com/t5/application-development-and-automation-discussions/connect-to-another-sql-server-from-sap/m-p/6962503#M1490116 <HTML><HEAD></HEAD><BODY><P><SPAN __default_attr="red" __jive_macro_name="color">Moderator message - Cross post locked Rob</SPAN></P></BODY></HTML> Wed, 23 Jun 2010 19:04:55 GMT https://community.sap.com/t5/application-development-and-automation-discussions/connect-to-another-sql-server-from-sap/m-p/6962503#M1490116 Former Member 2010-06-23T19:04:55Z