--- title: "SAP HANA" slug: "sap-hana-overview-replicate-cloud" updated: 2026-06-11T14:03:43Z published: 2026-06-11T14:03:43Z canonical: "skthelp.syniti.com/sap-hana-overview-replicate-cloud" --- > ## Documentation Index > Fetch the complete documentation index at: https://skthelp.syniti.com/llms.txt > Use this file to discover all available pages before exploring further. # SAP HANA ## Overview Replicate Preview enables efficient data movement to and from SAP HANA, supporting both source and target configurations. Users can quickly define replication pipelines by selecting source objects and configuring target destinations, allowing data to be replicated with minimal setup and operational overhead. The platform simplifies pipeline creation while ensuring consistent and reliable data delivery across SAP HANA environments. > [!NOTE] > Note > > SAP HANA is currently supported as both a **source and target endpoint** in Replicate Preview, limited to **Snapshot (full load) replication mode**, with Change Data Capture (CDC) and streaming replication not yet supported. ### Supported Versions SAP HANA **versions 2.0 and later** are supported. ### User Permissions When setting up replications that use SAP HANA as a source database, you need to be sure that the user ID used for making connections to the database has sufficient privileges to complete all the operations required for Replicate Preview to perform a replication. The following user permissions are required when using SAP HANA as a Source and Target in Snapshot mode: - **AUTHORITY TO CONNECT TO DATABASE**: This should already be granted when the user is created. - **AUTHORITY TO SELECT TABLES**: Replicate Preview runs a SELECT statement to identify records to replicate. Therefore, the user ID used to make a connection must have adequate authority to run a SELECT statement for tables involved in replication. The command is not needed if the user is the owner of the table (i.e., created the table.) - **AUTHORITY TO INSERT/UPDATE/DELETE:** Required to execute operations into the target tables. (Only when SAP HANA is a Target) ## **Connection Considerations** If you do not have a connection configured, refer to [Connecting to SAP HANA](/v1/docs/connecting-to-sap-hana) for step-by-step instructions. When configuring and using a connection to SAP HANA, consider the following: | Configuration | Details | | --- | --- | | Tenant vs System Database | Ensure you are connecting to the correct database. In SAP HANA environments with Multi-Tenant Database Containers (MDC), replication should typically target the tenant database, not the system database. | | Authentication and Credentials | Verify that the database user credentials are valid and not locked or expired. The user must have sufficient privileges for the intended role (read access for source, read/write for target). | | Schema and Object Resolution | Ensure that the correct schema is specified and accessible. SAP HANA is case-sensitive for object names unless quoted, so mismatches in casing may result in object resolution errors. | | SSL/TLS Configuration | If secure connections are enabled, verify that SSL is properly configured. This includes ensuring that required certificate files (for example, PSE files) are present and correctly referenced on the client system. | | Network Connectivity and Ports | Confirm that the SAP HANA host and port are reachable from the Replicate environment. Default SQL port patterns (for example, `3<instance>15`) should be validated, especially in cloud or firewall-restricted environments. | | Data Type Compatibility | Review data type mappings between SAP HANA and the target system. Pay particular attention to types such as `DECIMAL`, `NVARCHAR`, and `TIMESTAMP`, which may require validation to ensure compatibility. | | Large Table Handling | For large tables, consider performance implications such as memory usage and query execution time. Proper indexing and partitioning on the source system can improve extraction performance. | In Replicate Preview, configure your workspace using this system datastore and start replicating data. Refer to [Configure Workspace: Datastores](/v1/docs/configure-workspace-datastores) for more information. ## Related Articles - [Create a Connection](/v1/docs/create-a-connection) - [Configure Workspace: Datastores](/v1/docs/configure-workspace-datastores) - [Connecting to SAP HANA](/v1/docs/connecting-to-sap-hana)