Use the Cloud Connector to Connect SAP HANA On-Premise to SAP HANA Cloud, SAP HANA Database

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.

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.

1. Open SAP BTP cockpit and enter your (trial) account.
2. Enter your Global Account, Subaccount and then space.
3. There, click on SAP HANA Cloud on the left side menu.
4. Click on Create and then select SAP HANA database.
5. 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.
6. 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.
7. Click on Enable and select what IP addresses you would like to allow.
8. Finish the rest of the settings and click on Create Instance.
9. 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.

1. 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.
2. Once the download and installation are finished, open a web browser to administer the cloud connector. You can find the supported browsers here.

3. In a web browser, enter: https://localhost:8443

4. 8443 is 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.

5. On the logon screen that opens, enter this statement and enter your credentials:

   Administrator / manage (case sensitive) for <User Name> / <Password>

6. 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.

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.

1. First, select the region of the subaccount.

   

2. In the field Subaccount, you need to enter the subaccount ID.

3. 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.
   

4. Copy the subaccount ID from the center of the screen and enter it in the field Subaccount in the cloud connector.

   

5. Next, you can optionally enter a display name

6. 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.

7. Optionally, you can enter a location ID. You will need this location ID when setting up a remote source.

8. Click on Save at the top right corner of the screen.
   

1. After the configuration has finished, click on Cloud To On-Premise on the left panel.

   

2. 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.

   

3. A wizard opens. There, from the drop-down menu Back-end Type, select SAP HANA.

4. Click on Next.
5. For the Protocol, select TCP from the drop-down menu.
6. In the next step, enter the internal host information and internal port of your on-premise system.
7. 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.
8. Click on Next. You can optionally add a description to this mapping or skip that step.
9. Check the summary shown and click on Finish.
   

10. Your internal system name is now mapped to your virtual host name.

11. In the column Check Result, it still says Unchecked.
12. To check it, click on the looking glass icon on the right.
    

13. 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.

Well done!

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.