SAP HANA Source Connector

The SAP HANA source connector lets DataSync retrieve data from SAP HANA and load it into your data warehouse. Once your source connection is ready, configure your destination connection to finish the setup.

Step 1: Retrieve connection details from SAP HANA

1. Open the SAP HANA Database Explorer.
2. Right-click your instance and select Properties.
3. Copy the Host and Database values. You will need both in DataSync.
4. Click Ok.

Step 2: Create the source connection in DataSync

1. Log in to DataSync.
2. From the welcome screen, select Connections.
3. Next to Source Connections, click New.
4. Select SAP HANA.
5. Enter all required connection properties.
6. (Optional) In the Additional Connection Properties panel, click Add property and enter any extra parameters you need.
7. Configure the advanced settings to match your environment, including Tracking Type.
8. Click Save.

Connection properties

Property	What to enter
Description	Unique name for the connection. Example: SAP HANA.
SAP HANA Cloud	Enable this if connecting to an SAP HANA Cloud instance. When enabled, the Port field is disabled because the cloud connection uses default secure ports.
Server	Host name of the SAP HANA server. Example: a1b2c3d4-e5f6-7890-abcd-ef1234567890.hana.trial-us10.hanacloud.ondemand.com.
Port	Port number for the SAP HANA connection. Default: 443.
Database	Database name of the SAP HANA server. Example: H00.
Username	Login account for accessing the database. Example: admin.
Password	Password for this account.
Timeout	Time in seconds to wait before a connection attempt or query execution times out.
Verbosity	Controls how much detail the connector writes to the log. Each level includes everything from the level below it, plus additional detail. 1 logs queries, row counts, execution start and end times, and errors. 2 adds cache queries and HTTP headers. 3 adds request and response bodies. 4 adds transport-level communication. 5 adds all interface commands.
Enable Pooling	Enables connection pooling, which keeps a set of database connections open and reuses them across extractions instead of opening a new connection each time. This reduces overhead and improves performance when multiple extractions run at the same time.
Pool idle timeout	Time in seconds a connection can stay idle before returning to the pool.
Max Pool Size	Maximum number of connections allowed in the pool at the same time.
Pool wait time	Time in seconds DataSync waits for an available connection before throwing an error.

Additional connection properties

Use this panel to enter connection string properties not available in the Connection Properties panel. For sensitive values such as passwords, set the type to Encrypted. The value is hidden in the interface and stored encrypted in the back end.

Property	What to enter
Property	Connection string property that defines the action or behavior. Example: ReadOnly.
Value	Value for the property. Example: True.
Type	Visibility settings: Visible or Encrypted.

Advanced settings

These settings control how the connector tracks data changes, handles time and regional configuration, and processes records during extraction. Configure them to match your SAP HANA environment so that results stay accurate and consistent.

Setting	What to select
Tracking Type	Method for tracking data changes: None or Date.
Region	Region setting for the connector, if required by your setup.
Time Zone	Time zone matching your SAP HANA environment.
Time Offset	Refresh offset in seconds to compensate for timing issues in record selection. Minimum 0, maximum 3600.
Batch Size	Number of records processed per batch during extraction. Larger batches can improve performance but use more memory. Default is 2000, maximum is 10000. Adjust based on your network speed and disk performance. The default works well in most cases.

Example setup

Completed SAP HANA source connection in DataSync, with all properties and settings filled in.