topic Re: how access external database? in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/how-access-external-database/m-p/2651637#M611233 <HTML><HEAD></HEAD><BODY><P>Check help for EXEC / ENDEXEC commands (Native SQL):</P><P><A href="http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/content.htm" target="test_blank">http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/content.htm</A></P><P></P><P>Regards</P><P>Please reward points if helpful.</P></BODY></HTML> Tue, 28 Aug 2007 00:37:30 GMT alejandro_bindi 2007-08-28T00:37:30Z how access external database? https://community.sap.com/t5/application-development-and-automation-discussions/how-access-external-database/m-p/2651636#M611232 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P></P><P>i want to access external database ( oracle ) within SAP,</P><P>how to set it in SAP?</P><P>and how to report it with abap command?</P></BODY></HTML> Tue, 28 Aug 2007 00:26:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-access-external-database/m-p/2651636#M611232 Former Member 2007-08-28T00:26:21Z Re: how access external database? https://community.sap.com/t5/application-development-and-automation-discussions/how-access-external-database/m-p/2651637#M611233 <HTML><HEAD></HEAD><BODY><P>Check help for EXEC / ENDEXEC commands (Native SQL):</P><P><A href="http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/content.htm" target="test_blank">http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/content.htm</A></P><P></P><P>Regards</P><P>Please reward points if helpful.</P></BODY></HTML> Tue, 28 Aug 2007 00:37:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-access-external-database/m-p/2651637#M611233 alejandro_bindi 2007-08-28T00:37:30Z Re: how access external database? https://community.sap.com/t5/application-development-and-automation-discussions/how-access-external-database/m-p/2651638#M611234 <HTML><HEAD></HEAD><BODY><P>how to set it so i connect with external DATABASE!</P><P>thank you!</P></BODY></HTML> Tue, 28 Aug 2007 01:24:30 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-access-external-database/m-p/2651638#M611234 Former Member 2007-08-28T01:24:30Z Re: how access external database? https://community.sap.com/t5/application-development-and-automation-discussions/how-access-external-database/m-p/2651639#M611235 <HTML><HEAD></HEAD><BODY><P>You must configure database connection details in transaction DBCO.</P><P>Refer to this link:</P><P><A href="http://help.sap.com/saphelp_nw70/helpdata/en/df/455ec9747111d6b25100508b6b8a93/content.htm" target="test_blank">http://help.sap.com/saphelp_nw70/helpdata/en/df/455ec9747111d6b25100508b6b8a93/content.htm</A></P><P></P><P>Afterwards, prior to selecting data you use Native SQL statements SET CONNECTION and CONNECT TO. (search the forums for these, there's full of examples, this is one: /thread/108422 <B>[original link is broken]</B>)</P><P></P><P>Regards</P><P></P><P>Message was edited by: </P><P> Alejandro Bindi</P></BODY></HTML> Tue, 28 Aug 2007 02:13:57 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-access-external-database/m-p/2651639#M611235 alejandro_bindi 2007-08-28T02:13:57Z