Simply execute the ABAP program using F8 or clicking on execute icon Then in DB Connection Name input area choose the database connection that you want to test Using SE38 or SA38 transaction codes, execute ABAP program ADBC_TEST_CONNECTION To test new created database connections using DBCO transaction code on a SAP system, ABAP programmers can execute ABAP report ADBC_TEST_CONNECTION Then save the new database connection information for SAP HANA Database This is the connection information we will add on database connection creation screen on DBCO transaction. On Additional tab, programmers can find the connection details like Host data. Right-click on the SAP HANA system and display Properties screen. It is possible to get the database connection information if you are already connected to the HANA database on SAP HANA Studio.
The Connection Info field shows the target HANA Database system that we aim to connect using this new database connection. Please note that every time you make a change on this screen, you should provide the password for the HANA database connection user. The third step is providing a valid user authentication information a valid database username and its database password.
Since we target SAP HANA Database connection, choose HDB for the DBMS selection.
This DBMS selection is very important because according to the selected DBMS the connection properties that the ABAP programmer should provide on the definition screen will change. Here is the initial database connection creation screen on DBCO transaction.įirst of all, type a descriptive name to your new database connection.Īs the second step, choose the DBMS type (which stands for Database Management System). Switch to change mode and press New Entries button to create a new database connection on SAP. If you will be creating a new database connection for the first time on that SAP system, the list will be empty. Then launch SAP transaction code DBCO for Database Connection Maintenance screen.
Logon to SAP system that you want to create a second database connection to a remote HANA database system. Create Database Connection to SAP HANA Database
0 kommentar(er)
