Use the Cloud Connector to Connect SAP HANA On-Premise to SAP HANA Cloud, SAP HANA Database
- How to enable the cloud connector in an SAP HANA Cloud, SAP HANA database
- How to install the cloud connector
- How to configure the cloud connector and establish a connection to an SAP HANA on-premise database
- An SAP HANA on-premise database with SPS05 or higher if you want to use Remote Table Replication. If you have SAP HANA express edition SPS04 Rev45, however, you may still use the cloud connector for SDA virtual access.
- A running instance of an SAP HANA Cloud, SAP HANA database (trial or production) in a Cloud Foundry environment. For more information how to use SAP BTP Connectivity in a Neo environment, please refer to this documentation.
In this tutorial, you will learn how to use SAP BTP Connectivity to connect an SAP HANA on-premise database to an SAP HANA Cloud, SAP HANA database to replicate data from SAP HANA on-premise to the cloud database. This includes setting up the cloud connector in your on-premise database, which allows you to set up a connection to a remote source that does not require the installation and configuration of the Data Provisioning Agent.
This connection is a convenient choice if you want to quickly replicate data from an on-premise database to an SAP HANA Cloud, SAP HANA database.
Let us look at the steps you need to take to install and set up cloud connector, which you will learn how to do throughout this tutorial:
Enable the cloud connector for SAP HANA Cloud, SAP HANA database.
Install and configure the cloud connector.
Establish a remote source to replicate data from SAP HANA on-premise to SAP HANA Cloud, SAP HANA database.
Instead of following the written instructions in this tutorial, you can watch this video to see step-by-step instructions how to establish a connection with the cloud connector.
- Step 1
The cloud connector is a component for on-premise databases that serves as a link between SAP HANA Cloud, SAP HANA database and other SAP BTP applications. It lets you easily connect and expose specific parts of an on-premise database without having to expose the entire on-premise landscape. It gives you fine-grained control and helpful features for business-critical scenarios, like recovering broken connections automatically and running in a high-availability setup.
The cloud connector offers you several advantages. For example, installation and configuration are easy as, as you do not have to configure an on-premise firewall for allowing access to an on-premise system.
- Step 2
In this step you have two options: You can enable the cloud connector either during provisioning or edit an existing instance. Click on “Provisioning” or “Edit instance” below the title of this step.
First, you need to enable SAP BTP Connectivity in the SAP HANA Cloud, SAP HANA database you want to connect to an on-premise database.
- Open SAP BTP cockpit and enter your (trial) account.
- Enter your Global Account, Subaccount and then space.
- There, click on SAP HANA Cloud on the left side menu.
- Click on Create and then select SAP HANA database.
- The wizard will navigate you through the steps necessary to create your instance. If you are unsure how to provision the instance, you can follow this tutorial.
- In step 3 of the process (SAP HANA Advanced Settings), you can specify what IP addresses you allow or deny. Below, you can see the option to enable or disable the cloud connector.
- Click on Enable and select what IP addresses you would like to allow.
- Finish the rest of the settings and click on Create Instance.
- Your instance will be created, and it is ready to be connected with the cloud connector.
Now that you have enabled the cloud connector it is time to install the cloud connector and configure it.
- Step 3
- You can download the cloud connector from here. Check the system requirements for different operating systems as well as additional setup recommendations in the technical documentation here.
- Once the download and installation are finished, open a web browser to administer the cloud connector. You can find the supported browsers here.
In a web browser, enter:
8443is the default port specified during installation. If you have installed the cloud connector to a different machine than your local one, enter its hostname instead of the default port.
- On the logon screen that opens, enter this statement and enter your credentials:
Administrator / manage (case sensitive) for <User Name> / <Password>
When you first log in, you need to change the password.
Now that you have installed the cloud connector, it is time to start configuring it to establish a connection.
- Step 4
In the Cloud Connector Administration, you can see at the top of the screen that it will not work before you define a subaccount. You need to define the subaccount to map the cloud connector to the subaccount that your SAP HANA Cloud, SAP HANA database instance you want to connect is located in.
First, select the region of the subaccount.
In the field Subaccount, you need to enter the subaccount ID.
- To obtain it, go to SAP BTP cockpit and navigate to your subaccount. If you still have SAP BTP cockpit open from the previous steps, you can get there by clicking on the name of your subaccount in the top panel of the screen.
Copy the subaccount ID from the center of the screen and enter it in the field Subaccount in the cloud connector.
Next, you can optionally enter a display name
- Log in in with the credentials of the subaccount on SAP BTP Cockpit.
Important: If your subaccount is not on Cloud Foundry these steps vary slightly: You need to fill in the technical Subaccount name, subaccount username and password.
Optionally, you can enter a location ID. You will need this location ID when setting up a remote source.
- Click on Save at the top right corner of the screen.
- Step 5
After the configuration has finished, click on Cloud To On-Premise on the left panel.
There, click on the plus icon in the top right corner to add a new mapping that will map your SAP HANA on-premise system to the cloud connector.
A wizard opens. There, from the drop-down menu Back-end Type, select
- Click on Next.
- For the Protocol, select
TCPfrom the drop-down menu.
- In the next step, enter the internal host information and internal port of your on-premise system.
- To expose your internal host to the public network, you need to next specify the virtual host and virtual port. Here, it is recommended to use a host name that is different from your internal host name. The port can stay the same.
- Click on Next. You can optionally add a description to this mapping or skip that step.
- Check the summary shown and click on Finish.
Your internal system name is now mapped to your virtual host name.
- In the column Check Result, it still says
- To check it, click on the looking glass icon on the right.
The status will change to Reachable. Now the cloud connector can reach your SAP HANA on-premise system.
Now, you have successfully installed and configured the cloud connector.
For further details on configuring the cloud connector, please refer to the technical documentation.
To continue to learn more about the cloud connector, you can take a look at this blog in the community.
You have completed the fourth tutorial of this group! Now you know how to install and configure the cloud connector to connect an SAP HANA on-premise database to SAP HANA Cloud, SAP HANA database.
You can now use Remote Table Replication to replicate data from an SAP HANA on-premise database to an SAP HANA Cloud, SAP HANA database. Learn in the next tutorial how to use it.
- Step 6
What is needed to use the Cloud Connector?