SAP HANA Environment Preparation

Version

Grant privileges to users according to this document before executing synchronization using FineDataLink's Data Pipeline.

1. Use the following SQL statement to create a user:

CREATE User Username password "Password" NO FORCE_FIRST_PASSWORD_CHANGE;

2. Use the following statement to grant the privilege on creating a schema to the user:

GRANT CREATE SCHEMA TO Username;

3. 

Note:

In the following example, the username is ROXY, and the schema name is FDL_ROXY. You can modify the statement according to the actual situation.

Grant the privilege on the to-be-synchronized schema (FDL_ROXY) to the user (ROXY).

• Grant SELECT and INSERT privileges on all objects (such as tables and views) in the FDL_ROXY schema to the user ROXY.

• Grant privileges on creating and managing triggers, and creating any object (such as tables, views, and stored procedures) in the FDL_ROXY schema to the user ROXY.

-- Grant the privileges on the to-be-synchronized schema to the user
GRANT SELECT ON SCHEMA FDL_ROXY TO ROXY;
GRANT INSERT ON SCHEMA FDL_ROXY TO ROXY;
GRANT TRIGGER ON SCHEMA FDL_ROXY TO ROXY;
GRANT CREATE ANY ON SCHEMA FDL_ROXY TO ROXY;

Grant the SCHEMA (SYSTEM) privilege on incremental change tables to the user (ROXY):

-- Grant the SCHEMA (SYSTEM) privilege on incremental tables to the user
GRANT SELECT ON SCHEMA SYSTEM TO ROXY;
GRANT INSERT ON SCHEMA SYSTEM TO ROXY;
GRANT CREATE ANY ON SCHEMA SYSTEM TO ROXY;

4. FineDataLink will automatically create the FDL_CDC mode to support real-time synchronization. You need to use the following command to grant the privilege on this mode to the user:

-- Grant the FDL_CDC SCHEMA privilege to ROXY (the user)
GRANT SELECT ON SCHEMA FDL_CDC TO ROXY;
GRANT INSERT ON SCHEMA FDL_CDC  TO ROXY;
GRANT TRIGGER ON SCHEMA FDL_CDC  TO ROXY;
GRANT CREATE ANY ON SCHEMA FDL_CDC TO ROXY;

Connect the SAP HANA database to FineDataLink (For details, see SAP HANA Data Connection.) and configure the pipeline task.

As the data source of pipeline tasks, the SAP HAHA database does not support DDL synchronization. Manual processing is required. For details, see the fifth chapter of Data Pipeline - Synchronizing Source Table Structure Changes.