how access external database?

[Former Member]

hi

i want to access external database ( oracle ) within SAP,

how to set it in SAP?

and how to report it with abap command?

[Former Member]

You must configure database connection details in transaction DBCO.

Refer to this link:

http://help.sap.com/saphelp_nw70/helpdata/en/df/455ec9747111d6b25100508b6b8a93/content.htm

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 [original link is broken])

Regards

Message was edited by:

Alejandro Bindi

[alejandro_bindi]

Check help for EXEC / ENDEXEC commands (Native SQL):

http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/eb3b8b358411d1829f0000e829fbfe/content.htm

Regards

Please reward points if helpful.

[Former Member]

how to set it so i connect with external DATABASE!

thank you!

[alejandro_bindi]

You must configure database connection details in transaction DBCO.

Refer to this link:

http://help.sap.com/saphelp_nw70/helpdata/en/df/455ec9747111d6b25100508b6b8a93/content.htm

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 [original link is broken])

Regards

Message was edited by:

Alejandro Bindi