SAP HANA Connector | Zoho Creator Help

SAP HANA connector

Overview

SAP HANA is a popular platform used primarily in enterprise environments for real-time analytics, ERP systems, and large-scale data processing. The SAP HANA connector allows you to read, write, and synchronize data from your SAP HANA database directly within Zoho Creator, without exposing it to the public internet. Connectivity is handled securely through DataBridge, a lightweight agent installed inside your network.

Meta Information

Connector
SAP HANA
Default port
39015 (configurable)
Data centers
US, EU, IN, AU, CA, SA, and UAE
Applicable for
C6
Website
Privacy policy
Hosting support
Local / On-premise server
Categories
Dashboards & Reports, Database Management, ERP

Setting up SAP HANA connectors

To connect Zoho Creator with your SAP HANA database, follow the steps given below:
  1. In Zoho Creator, go to Operations -> DataBridge. From the list displayed, select the operating system and version that matches your host machine (for example, macOS - 64 bit). The DataBridge package will be downloaded as a zip file.
    Note: If DataBridge is already installed and running on this machine, skip to Step 3.
  2. Install DataBridge on the host machine where your SAP HANA database is accessible. Once installed, start DataBridge. 
  3. With DataBridge running, you're ready to connect SAP HANA to Zoho Creator. In Zoho Creator, go to Operations -> DataBridge and confirm that DataBridge shows a status of Active.
  4. Once DataBridge is active, click Add Connection and select the SAP HANA connector. 
  5. In the Add Connection panel, the DataBridge is automatically selected. Fill in the remaining details and click Create and Authorize.
  6. When the Link Account popup appears, provide the following details: username, password, host, port, and database name. Click Authorize to complete the connection.
For detailed instructions, see Configuring DataBridge help doc.

Where this connector can be used

Data Sources

SAP HANA data is accessible in Creator through integration forms, integration fields, and integration reports. The table below shows supported components by module.
Module
Integration Field
Integration Form
Integration Report
Records
✓
✓
✓