2. Secondary Database Connections (HANA)-DBACOCKPIT/DBCON

Each Application Server ABAP is connected to a Database Management System (DBMS) that contains the ABAP Repository and the database tables and views defined in this system’s ABAP Dictionary. This DBMS is referred to as its Primary Database. Besides this primary database connection it is possible to establish connections to additional database management systems, so called Secondary Database Connections. In the scenario SAP HANA as Accelerator, where SAP HANA is used as a secondary DBMS, it is necessary to establish such a secondary database connection to SAP HANA.

Maintain DB connection using below steps.

Transaction : DBACOCKPIT
 Use : Maintain. Monitor and test secondary db connections.

Tables : DBCON

Secondary database connections, among other things, are created and maintained via transaction DBACOCKPIT. Each database connection is identified by name that has to be unique within the application server.

Inside the connection, the DBMS is identified by a hostname and an instance number, which relates to an SQL port. Furthermore a database user (with password) has to be maintained. Any access to the database via this secondary database connection is equivalent to a log on to the database with this user



Access to a Secondary Database with Open SQL:
Once the secondary database connection is established, it is easy to use it in ABAP programs: Open SQL offers an addition CONNECTION which has to be followed by the name of the secondary database connection.


Select ........ from <table>  connection <connection>.

But some restrictions apply, when using Open SQL to access a secondary database.

Restrictions: