This blog contains experience gained over the years of implementing (and de-implementing) large scale IT applications/software.

SAP DBCO Connection Without TNSNAMES

Darryl Griffiths
In order to create an external database connection to another database, so that an ABAP program can access it, you normally create the connection details in transaction DBCO.

However, if you use the ST04 transaction, it provides additional fields where you can enter the connection details such as Oracle listener port number, which will allow you to construct a connection string which will not require an entry in the server’s TNSNAMES.ora file.

2 thoughts on SAP DBCO Connection Without TNSNAMES

  1. Daryl, this is a good tip! Can you give an example connection string? We would like to use this feature since our db is now on hana instead of oracle and there is no longer a tnsnames.ora.

    Reply

  2. Hello,

    I don't have an example of an Oracle connection string to hand, but the HANA one will depend on how you are planning to connect.

    Take a look at the ODBC string on the help page here:
    http://help.sap.com/saphelp_hanaplatform/helpdata/en/a9/3bbfb34cb14d448c857e6fb289cda1/content.htm?frameset=/en/14/42129f81804cf497dddead6428113c/frameset.htm&current_toc=/en/34/29fc63a1de4cd6876ea211dc86ee54/plain.htm&node_id=496&show_children=false

    Regards,

    Darryl

    Reply

Add Your Comment

* Indicates Required Field

Your email address will not be published.

*