Create SDA remote source in SAP HANA CLOUD using SAP Cloud Connector

SAP Cloud Connector serves as a link between SAP BTP applications and on-premise systems. Runs as on-premise agent in a secured network and provides control over on-premise systems and resources that can be accessed by cloud applications.

In this blog, you will learn how to enable cloud connector for HANA Cloud Instance, install and configure the cloud connector. Also to connect an SAP HANA on-premise database to SAP HANA Cloud using SDA remote source.

Cloud connector enablement for SAP HANA Cloud Instance

For New instance

1. Go to SAP BTP home page and enter your account
2. Enter Subaccount and then Space
3. Click on SAP HANA Cloud on the left navigation menu
4. Click on Create and then select SAP HANA database
5. Follow the steps in wizard to create instance
6. Under SAP HANA Database Advanced Settings, you can specify what IP addresses you allow by selecting enable the cloud connector option
7. 
8. 7. Proceed with other settings and click on Create Instance
9. 8. Instance created can be connected with the cloud connector

For Existing instance

1. Open SAP Hana Cloud Central Cockpit
2. Select the instance that you want to connect to an SAP HANA on-premise database
3. Click on Manage Configurations
   4. Select Edit
4. 
5. 5.Navigate to Connections tab and enable the Cloud Connector
6. 
7. 6. Save the changes

Install Cloud Connector

Download the cloud connector from Hana tools.

Refer SAP Help Document for supported browsers.

After the installation is complete, open a browser and enter “https://localhost:8443”

“8443” is the default port specified during installation.

“Administrator/manage” is the default login credentials which is case-sensitive. On first login, password needs to be changed.

Define Subaccount

In the Cloud connector, Subaccount needs to be defined to map to the subaccount that your SAP HANA Cloud database instance is located.

1. Select the region of the subaccount
2. Enter the subaccount ID

Details of Region and Subaccount ID can be obtained from the BTP cockpit as seen in the below image

1. 
   3. Provide the credentials of the subaccount on SAP BTP Cockpit
2. 4. Location ID is optional but needed when setting up remote source
3. 5. Save
4. 

Connect to SAP HANA on-premise system

1. Click on Cloud To On-Premise on the left panel
2. Click on the plus icon in the top right corner to add system mapping
3. 3. From the drop-down menu Back-end Type, select SAP HANA
4. 4. Select TCP from the drop-down menu for the protocol. Refer here for more information on TCP
5. 
6. 5. Enter the internal host and internal port of your on-premise HANA system
7. 6. Specify the virtual host and virtual port to expose your internal host to the public network
8. 7. Proceed and the click on Finish
9. 8. After finish, status is Unchecked in the column Check Result. Click on the glass icon under Actions column
10. 9.Status will be changed to Reachable which means cloud connector can reach SAP HANA On-Premise system

Create SDA Remote Source Using Cloud Connector

Create a remote source in SAP HANA Cloud,SAP HANA Database to an SAP HANA on-premise database.

Prerequisites

• Need CREATE REMOTE SOURCE system privilege.
• The remote source is reachable by the network from the computer you are using.
• Download and import the SSL certificate signed by DigiCert.

REST API-based adapters communicate with the endpoint through an HTTP client. To ensure secure communication, the adapters require client certificates from the endpoint services. Connections to an SAP HANA database in SAP HANA Cloud, which are based on the hanaodbc adapter, also require an SSL certificate.

Refer the document Import Certificates for SSL Connections to Remote Sources.

Create a Remote Source Using SQL Syntax

In SQL console, execute a CREATE REMOTE SOURCE command by specifying the required properties

CREATE REMOTE SOURCE “SDA_CC”
ADAPTER “hanaodbc”
CONFIGURATION ‘<?xml version=”1.0″ encoding=”UTF-8″?><ConnectionProperties name=”connectionproperties”><PropertyEntry name=”adapterversion”>1.0</PropertyEntry><PropertyEntry name=”connectionmode”>adapterproperties</PropertyEntry><PropertyEntry name=”driver”>libodbcHDB.so</PropertyEntry><PropertyEntry name=”server”>virtual_host</PropertyEntry><PropertyEntry name=”port”>virtual_port</PropertyEntry><PropertyEntry name=”dml_mode”>readwrite</PropertyEntry><PropertyEntry name=”extraadapterproperties”>use_haas_socks_proxy=true;scc_location_id=locationid</PropertyEntry></ConnectionProperties>’
WITH CREDENTIAL TYPE ‘PASSWORD’ USING ‘user=<user_name>;password=<password>’;

Create a Remote Source Using Database Explorer

1. In Database explorer, right-click the Remote Sources object in your database catalog and click Add Remote Source
2. 
   2. Specify a remote source name
3. 3. In the Adapter Name dropdown list, choose HANA (ODBC)
4. 4. Enter the required information under the properties section
5. Server: Virtual Host , Port: Virtual Port (Specified in the Cloud Connector)
6. 5. Extra Adapter properties to be specified as “use_haas_socks_proxy=true;scc_location_id=<loc_id>”

Location_ID is the ID set up in the Cloud Connector

1. 
   6. Specify the credentials
2. 7. Click on Create

After the connection is established the schemas and tables can be accessed from the HANA On-Premise system via the remote source.