Using Google Chrome?

Download my
free Chrome Extension, Power Notes Searcher, to make searching for and evaluating SAP notes, much easier.

Recent Posts

Monday, April 14, 2014

SAP DBCO Connection Without TNSNAMES

Print Friendly and PDF
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 comments:

Anonymous said...

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.

Darryl Griffiths said...

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