how to open a connection from S4/HANA to other database

[SAPSupport]

how to open a connection from S4/HANA to oracle.

we are in the process to setup s4/HANA and we need to be able:

1.  to connect from s4/HANA to another database (oracle on premise)
2. We need to connect from on premise oracle database to s4/HANA

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Dear customer,

You can utilize SDA(Smart Data Access) feature provided by SAP HANA.
Please refer to the following information.

• SDA feature can be used for this requirement.
  • 2180119 - FAQ: SAP HANA Smart Data Access
    2600176 - SAP HANA Smart Data Access Supported Remote Sources
  • SAP HANA Smart Data Access 

    • SAP HANA smart data access lets you access remote data as if the data were stored in local tables in SAP HANA, without copying the data into SAP HANA. 
      This capability lets you access and integrate data from multiple remote systems in real time.

      In SAP HANA, you use linked database or create virtual tables, which point to remote tables in different remote databases, and then write SQL queries in SAP HANA that use these virtual tables. 
      The SAP HANA query processor optimizes these queries by executing the relevant part of the query in the remote database, returning the results of the query to SAP HANA, and then completing the operation. 
      Physical data movement is not supported by SAP HANA smart data access.

      Because smart data access is part of the SAP HANA core system, no additional licensing is required to use it. 
      Additional support packages and patches are available for download from the SAP Software Download Center, and are installed using the SAP HANA database lifecyle manager (HDBLCM).

Regarding to the reverse connection(Oracle -> HANA), please open a support ticket to ORACLE support team.
Hope this helps.

Best regards,
SAP Support