Skip to Content
Author's profile photo Marius Burger

Creating DBCO connections

This is a quick guide how to create a DBCO connection to an External Oracle Database-

First you create the TNSNAMES.ORA entry, in this case i create a new one called TST.WORLD


make sure you can TNSPING TST and its successful (from SIDADM)


Logon to SAP and create the entry in DBCO, for now i called mine just TST

The CONN. INFO must be the name of the new connection I called my TST.WORLD


go to SA38 and run ADBC_TEST_CONNECTION (this is to test the connection)


supply the DB Connectiom name used in DBCO to create the connection (TST)


and the final result connection working


Best Regards


Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Ramesh Putta
      Ramesh Putta

      This is good information. thank you.

      Where do we need to save the TNSNAMES.ORA in the first place ?

      Does it has to be at the sap side? if yes, what is the location.

      Author's profile photo MARCO RONCOLONI

      Hi Ramesh,

      In application server site put the information in the following path:


      Best regards


      Author's profile photo Ramesh Putta
      Ramesh Putta

      Thank you much. I am able to connect now.

      Author's profile photo MARCO BAIOCCO

      Hello Marco,

      What if the source system where we are creating the DBCON entry is not Oracle?

      In this case, it does not have the /SYS/profile/oracle directory....

      Author's profile photo Former Member
      Former Member

      Hello Ramesh,

      What is the Username and Password used to make this connection a success?

      Author's profile photo Zia Nauman
      Zia Nauman  refer to this