topic Re: obtaining data from SQL Server in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/obtaining-data-from-sql-server/m-p/1536304#M244677 <HTML><HEAD></HEAD><BODY><P>In this case, how is the SQL Server database being updated? What application is doing the update?</P></BODY></HTML> Tue, 05 Sep 2006 13:35:55 GMT Former Member 2006-09-05T13:35:55Z obtaining data from SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/obtaining-data-from-sql-server/m-p/1536297#M244670 <HTML><HEAD></HEAD><BODY><P>I want to fetch data from SQL Server 2000 database using abap programming and insert it into SAP Database or guide me if any concept is there in SAP to solve this.</P></BODY></HTML> Fri, 01 Sep 2006 15:40:47 GMT https://community.sap.com/t5/application-development-and-automation-discussions/obtaining-data-from-sql-server/m-p/1536297#M244670 Former Member 2006-09-01T15:40:47Z Re: obtaining data from SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/obtaining-data-from-sql-server/m-p/1536298#M244671 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>Check this out</P><P><A class="jive_macro jive_macro_message" href="https://community.sap.com/" __jive_macro_name="message" modifiedtitle="true" __default_attr="705281"></A></P><P></P><P></P><P></P><P>Regards,</P><P>Santosh</P></BODY></HTML> Fri, 01 Sep 2006 15:46:00 GMT https://community.sap.com/t5/application-development-and-automation-discussions/obtaining-data-from-sql-server/m-p/1536298#M244671 Former Member 2006-09-01T15:46:00Z Re: obtaining data from SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/obtaining-data-from-sql-server/m-p/1536299#M244672 <HTML><HEAD></HEAD><BODY><P>thnx 4 ur reply......but i want to directly fetch the data from sql server 2000 database to sap database without using </P><P>lasmw &amp; bdc.......can i use BAPI?? or is thr any other concept available in SAP(like idoc,ale etc)....plz clarify my query</P></BODY></HTML> Fri, 01 Sep 2006 17:44:51 GMT https://community.sap.com/t5/application-development-and-automation-discussions/obtaining-data-from-sql-server/m-p/1536299#M244672 Former Member 2006-09-01T17:44:51Z Re: obtaining data from SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/obtaining-data-from-sql-server/m-p/1536300#M244673 <HTML><HEAD></HEAD><BODY><P>Look at this thread:</P><P></P><P><A class="jive_macro jive_macro_thread" href="https://community.sap.com/" __jive_macro_name="thread" modifiedtitle="true" __default_attr="89758"></A></P></BODY></HTML> Fri, 01 Sep 2006 17:47:05 GMT https://community.sap.com/t5/application-development-and-automation-discussions/obtaining-data-from-sql-server/m-p/1536300#M244673 Former Member 2006-09-01T17:47:05Z Re: obtaining data from SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/obtaining-data-from-sql-server/m-p/1536301#M244674 <HTML><HEAD></HEAD><BODY><P>can u give me some more clarified answer wihth code...</P></BODY></HTML> Fri, 01 Sep 2006 18:01:36 GMT https://community.sap.com/t5/application-development-and-automation-discussions/obtaining-data-from-sql-server/m-p/1536301#M244674 Former Member 2006-09-01T18:01:36Z Re: obtaining data from SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/obtaining-data-from-sql-server/m-p/1536302#M244675 <HTML><HEAD></HEAD><BODY><P>The final post in the above thread has the sample code for retrieving the data from the external database. Add a statement to append the fields to an internal table defined like your transparent table immediately after the FETCH statement.</P><P></P><P>Once you have data in your internal table, inssert the records into the transparent table using:</P><P></P><P>INSERT dbtab FROM TABLE itab</P><P></P><P>where dbtab is your SAP table and itab is the internal table defined like dbtab.</P></BODY></HTML> Fri, 01 Sep 2006 18:09:49 GMT https://community.sap.com/t5/application-development-and-automation-discussions/obtaining-data-from-sql-server/m-p/1536302#M244675 Former Member 2006-09-01T18:09:49Z Re: obtaining data from SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/obtaining-data-from-sql-server/m-p/1536303#M244676 <HTML><HEAD></HEAD><BODY><P>hello...can i automatically fetch data from sql server to SAP &amp; viceversa....i want tat if the sql server database is updated ...it automatically insert data to SAP database also......tell me if we have to use any SAP concept like BAPI etc.</P></BODY></HTML> Sat, 02 Sep 2006 04:03:34 GMT https://community.sap.com/t5/application-development-and-automation-discussions/obtaining-data-from-sql-server/m-p/1536303#M244676 Former Member 2006-09-02T04:03:34Z Re: obtaining data from SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/obtaining-data-from-sql-server/m-p/1536304#M244677 <HTML><HEAD></HEAD><BODY><P>In this case, how is the SQL Server database being updated? What application is doing the update?</P></BODY></HTML> Tue, 05 Sep 2006 13:35:55 GMT https://community.sap.com/t5/application-development-and-automation-discussions/obtaining-data-from-sql-server/m-p/1536304#M244677 Former Member 2006-09-05T13:35:55Z Re: obtaining data from SQL Server https://community.sap.com/t5/application-development-and-automation-discussions/obtaining-data-from-sql-server/m-p/1536305#M244678 <HTML><HEAD></HEAD><BODY><P>I think it is posiible - but you have to use Business Connector or XI. </P><P></P><P>BR&lt; Jacek</P></BODY></HTML> Tue, 05 Sep 2006 13:59:37 GMT https://community.sap.com/t5/application-development-and-automation-discussions/obtaining-data-from-sql-server/m-p/1536305#M244678 Former Member 2006-09-05T13:59:37Z