Skip to content
English
More support
Go to precog.com
  • There are no suggestions because the search field is empty.

How to Connect to SAP Datasphere in Precog

Set up SAP Datasphere or HANA Cloud as a Precog destination

This guide walks you through connecting Precog to SAP Datasphere or HANA Cloud.

Preparation

To set up your connection, start by logging in to SAP Datasphere with administrator privileges. From the left-hand navigation, go to Space Management and create a new database and user in the appropriate Space. Once created, you’ll find the Database Username, Host Name, and Password under Database User Details—these values will be entered into the Precog destination configuration form.

Next, allow Precog to connect by adding its IP addresses to your whitelist. In the left navigation, go to System > Configuration, then open the IP Allowlist tab. Add the following IP addresses:

  • 44.205.118.35 (precog.cloud)

  • 3.73.24.30 (eu.precog.cloud)

Finally, you’ll need to upload Amazon’s security certificate. Open the Amazon Root CA 1 certificate in a new browser window.  Copy the entire certificate text (including the “BEGIN CERTIFICATE” and “END CERTIFICATE” lines) and paste it into a simple text file using Notepad (Windows) or TextEdit (Mac). Save the file as precog.pem, making sure it has the .pem extension. Then, upload this file to the Security tab in SAP Datasphere.

Once these steps are complete, you can fill out the Precog destination configuration form using the information you gathered.

Precog Destination Configuration Form

Destination Name
A descriptive name that will be used for this destination in Precog.

Host Name
The database Host Name is shown in the Database User Details in the Space Management panel. It will be a long alpha-numeric string followed by hanacloud.ondemand.com, for example, e5g7r6f3-8gk6-9b25-d7e1-3r900MfMc7q4.hana-prod.us32.hanacloud.ondemand.com.

Port
The port is shown in the Database User Details in the Space Management panel. It is typically 443.

Database Username
The username is shown in the Database User Details in the Space Management panel.

Database Password
The password is shown in the Database User Details in the Space Management panel.

Optional Fields

  • Encryption: Choose whether TLS/SSL encryption is used. The default is “yes” for most users. SAP HANA Cloud does not accept unencrypted connections.
Additional Properties: If you need extra JDBC properties, use the format '&property1=value&property2=value'. A complete list of properties is available in the SAP JDBC Connection Properties documentation.