Skip to Content
Author's profile photo Naor Shalom

Connect ERP to HANA server for COPA


The SAP ERP Rapid-deployment solution for profitability analysis with SAP HANA provide functionality for customer to speed up the reporting ans transactional processes in CO-PA by using the SAP HANA database as secondary data persistence.


  • It is recommended to use SAP kernel/DBSL 7.20
  • Only an SAP kernel 64-bit is supported. See SAP Note 1700052 if you use a non-Unicode system
  • Download HANA Client and HANA studio

1.       Install HANA client on the ERP server

  (You must install the HANA Client on all the application server – Note 1517236 1597627)

  After the installation you will see the folder – C:\Program Files\SAP\hdbclient

2.       Enter the path for the DB client software <lw>:\usr\sap\<SID>\hdbclient in the environment variable PATH for the user <SID>Adm


Picture 1.0

1.       Restart the server!!!

2.       Go to transaction code SM30 in table DBCON

And create new entries


Picture 1.1

  • DB connection – HANA SID
  • DBMS – HDB
  • User name – the user name you are creating in the HANA Studio (see next page)
  • DB password – password of the user name
  • Conn. Info – HANA server FQDN with port 30015


Picture 1.2

DBACockpit – Test the connection                                  

When you create the connection in table DBCON you can see the connection in the DBA cockpit under DBconnections


Picture 1.3

To test the connection you need to add the system to System configuration


Picture 1.3.1

Enter add


Picture 1.3.2

In the next pics enter this parameter


Picture 1.3.3

  • System – HANA SID
  • Mark the database connection, and choose the name of the connection from the DBcon table


Picture 1.3.4

Now you can test the connection :


          Picture 1.3.5


    Picture 1.3.6

    And check the result


     Picture 1.3.7

Test the connection with – ADBC_TEST_Connection

    Go to transaction code SA38 – enter the ADBC_TEST_Connection and execute

                           Select the name of the connection from the checkbox


Picture 2.0

Execute  an Check the result


Picture 2.1

Sap sources:

Note 1597627 – SAP HANA connection

Note 1559994 – Profitability analysis with Accelerated CO-PA

Note 1632506 – SAP ERP RDS for profitability analysis with SAP HANA


Naor Shalom

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.