The SAP HANA Deployment Infrastructure (HDI) is a service layer of the SAP HANA database and helps to create runtime database objects from design-time artifacts.
It uses containers to store design-time artifacts and the corresponding deployed run-time objects.
Inside the database, the HDI container is represented as a schema but is owned by a technical user and isolated from other database objects. Only local object access inside the container is allowed and to access objects outside the container explicit grants is required from the object owner.
In this blog, you will learn to create HDI module for database content in the BAS, enable access to the schema of an HDI container to a database object consumer and replicate the data from object.
1. Create SAP HANA Native Application Dev space
6. Retain the module name as default "db" and click Next
1. Navigate to View > Find Command > Create Database Artifact > Choose Artifact type as Table > Provide Artifact Name > Create
2. Create table with required details and click Deploy in SAP HANA PROJECTS View
3. Create CSV file
4. Enter the data in CSV file and click Deploy in SAP HANA PROJECTS View
5. Create hdbtabledata to import the data from CSV into Table
6. Define the mappings in the hdbtabledata file and click Deploy in SAP HANA PROJECTS View
To grant access privileges for the entire container schema where the database objects are located to a database object consumer USER, perform the following steps.
Grant access to the HDI container's schema by executing the below:
1. In DBX, connect to HDI container and Open SQL Admin Console
2. Grant access to the HDI container's schema by executing the below statements
3. Confirm that the USER can now access the database objects in the container's schema.
Create remote source to the Hana Cloud Database
1. In an SQL console, connected to the SAP HANA on-premise database, create a remote source to the HC database using HANA adapter:
2. Create the virtual table VT in the target system based on the table "EMPLYOEE DETAILS" in the "MY_SCHEMA" schema of the source system
3. Create the replica table RT using the virtual table VT as the source for the definition
4. Create a remote subscription, specifying VT as the virtual table on which the changes are to be captured and RT as the target table to which they are to be applied
5. Initialize real-time data processing using ALTER REMOTE SUBSCRIPTION with QUEUE command
6. Activate replication using the DISTRIBUTE command
7. Check for the real time data replicated on to the target table
8. Deactivate replication and Drop the replication when it is no longer needed
In this blog we have seen how to grant access to HDI's schema, setup real time replication using HANA adapter, create a virtual table, a target table, a remote subscription, and then activate replication on the target system.
It uses containers to store design-time artifacts and the corresponding deployed run-time objects.
Inside the database, the HDI container is represented as a schema but is owned by a technical user and isolated from other database objects. Only local object access inside the container is allowed and to access objects outside the container explicit grants is required from the object owner.
In this blog, you will learn to create HDI module for database content in the BAS, enable access to the schema of an HDI container to a database object consumer and replicate the data from object.
Create Hana Database Project
1. Create SAP HANA Native Application Dev space
6. Retain the module name as default "db" and click Next
Create database artifacts
1. Navigate to View > Find Command > Create Database Artifact > Choose Artifact type as Table > Provide Artifact Name > Create
2. Create table with required details and click Deploy in SAP HANA PROJECTS View
3. Create CSV file
4. Enter the data in CSV file and click Deploy in SAP HANA PROJECTS View
5. Create hdbtabledata to import the data from CSV into Table
6. Define the mappings in the hdbtabledata file and click Deploy in SAP HANA PROJECTS View
Grant Access to an SAP HDI Container's Schema
To grant access privileges for the entire container schema where the database objects are located to a database object consumer USER, perform the following steps.
Grant access to the HDI container's schema by executing the below:
1. In DBX, connect to HDI container and Open SQL Admin Console
2. Grant access to the HDI container's schema by executing the below statements
| CREATE LOCAL TEMPORARY COLUMN TABLE #PRIVILEGES LIKE _SYS_DI.TT_SCHEMA_PRIVILEGES; INSERT INTO #PRIVILEGES ( PRIVILEGE_NAME, PRINCIPAL_SCHEMA_NAME, PRINCIPAL_NAME ) VALUES ( 'SELECT', '', 'USER' ); CALL C#DI.GRANT_CONTAINER_SCHEMA_PRIVILEGES( #PRIVILEGES, _SYS_DI.T_NO_PARAMETERS, ?, ?, ?); DROP TABLE #PRIVILEGES; |
3. Confirm that the USER can now access the database objects in the container's schema.
Replicate artifacts data from HDI container into SAP HANA On Premise
Create remote source to the Hana Cloud Database
1. In an SQL console, connected to the SAP HANA on-premise database, create a remote source to the HC database using HANA adapter:
| CREATE REMOTE SOURCE "<SOURCE_NAME>" ADAPTER "HanaAdapter" AT LOCATION AGENT "<AGENT>" CONFIGURATION '<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <ConnectionProperties name="configurations"> <PropertyGroup name="database" displayName="Database"> <PropertyEntry name="host" displayName="Host"><HANA_CLOUD_HOST></PropertyEntry> <PropertyEntry name="port" displayName="Port Number"><PORT></PropertyEntry> <PropertyEntry name="schema" displayName="Schema"><SCHEMA_NAME></PropertyEntry> </PropertyGroup> <PropertyGroup name="cdc_properties" displayName="CDC Properties"> <PropertyEntry name="prefix" displayName="System Object Prefix">HADP_</PropertyEntry> <PropertyEntry name="ddl_scan_interval" displayName="DDL Scan Interval in Minutes">1</PropertyEntry> </PropertyGroup> </ConnectionProperties> ' WITH CREDENTIAL TYPE 'PASSWORD' USING '<CredentialEntry name="credential"> <user><USERNAME></user> <password><PASSWORD></password> </CredentialEntry>'; |
2. Create the virtual table VT in the target system based on the table "EMPLYOEE DETAILS" in the "MY_SCHEMA" schema of the source system
| CREATE VIRTUAL TABLE VT AT "REMOTE_SOURCE"."<NULL>"."MY_SCHEMA"."EMPLOYEE_DETAILS"; |
3. Create the replica table RT using the virtual table VT as the source for the definition
| CREATE COLUMN TABLE RT LIKE VT; |
4. Create a remote subscription, specifying VT as the virtual table on which the changes are to be captured and RT as the target table to which they are to be applied
| CREATE REMOTE SUBSCRIPTION SUB ON VT TARGET TABLE RT; |
5. Initialize real-time data processing using ALTER REMOTE SUBSCRIPTION with QUEUE command
| ALTER REMOTE SUBSCRIPTION SUB QUEUE ; |
6. Activate replication using the DISTRIBUTE command
| ALTER REMOTE SUBSCRIPTION SUB DISTRIBUTE; |
7. Check for the real time data replicated on to the target table
| SELECT * FROM RT; |
8. Deactivate replication and Drop the replication when it is no longer needed
ALTER REMOTE SUBSCRIPTION SUB RESET; DROP REMOTE SUBSCRIPTION SUB; |
Conclusion
In this blog we have seen how to grant access to HDI's schema, setup real time replication using HANA adapter, create a virtual table, a target table, a remote subscription, and then activate replication on the target system.
- SAP Managed Tags:
9 Comments
