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. Proceed with other settings and click on Create Instance
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
5.Navigate to Connections tab and enable the Cloud Connector
6. Save the changes
Install Cloud Connector
Download the cloud connector from Hana tools.
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
3. Provide the credentials of the subaccount on SAP BTP Cockpit
4. Location ID is optional but needed when setting up remote source
5. Save
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. From the drop-down menu Back-end Type, select SAP HANA
4. Select TCP from the drop-down menu for the protocol. Refer here for more information on TCP
5. Enter the internal host and internal port of your on-premise HANA system
6. Specify the virtual host and virtual port to expose your internal host to the public network
7. Proceed and the click on Finish
8. After finish, status is Unchecked in the column Check Result. Click on the glass icon under Actions column
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.
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. Specify a remote source name
3. In the Adapter Name dropdown list, choose HANA (ODBC)
4. Enter the required information under the properties section
Server: Virtual Host , Port: Virtual Port (Specified in the Cloud Connector)
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
6. Specify the credentials
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.
No comments:
Post a Comment