HANA Cloud Replication Services enable real-time or scheduled (snapshot) data replication from various source systems into SAP HANA Cloud. These services are designed to ensure high data availability, consistency, and low-latency access by synchronizing data between operational and analytical environments. Replication is done via Smart Data Access (SDA) and can be set up for replicating from HANA on-premise databases to HANA Cloud databases.
SAP HANA Cockpit provided the platform for managing replication services. While this service has been widely used, now it is being phasing out from HANA Cockpit in favor of SAP HANA Cloud Central. SAP HANA Cloud Central is the unified management platform for all SAP HANA Cloud services, including replication. Moving forward, this platform will provide the functionalities for managing replication tasks and improve user experience.
The below are the steps of creating data replication using the SAP HANA Cloud Central.
Step 1: Log in to SAP BTP Cockpit. Navigate to Instances and Subscriptions. Launch the SAP HANA Cloud tools (SAP HANA Cloud Central) application. If it is not present, kindly subscribe for the same by selecting it from the Create button of Instances and Subscriptions page.
Step 2: Select (click) the SAP HANA Cloud Database in which the data replication needs to be configured.
Step 3: Once the SAP HANA Cloud Database is selected, a right panel will open with Overview of the selected SAP HANA Cloud Database.
Step 4: Inside the panel, search for the Data Replication tile and click on Create Replication Task button.
Step 5: Under Connection Type, ‘+ Create a New Connection’ will be selected by default. Depending on the source, select the required connection type and click on Next Step.
Please note that ‘SAP HANA 2.0 On-Premise SPS 05 or Higher’ is selected here for illustration purposes.
Step 6: Provide an appropriate Connection Name, Host along with its Port, and SAP Cloud Connector Location ID. To ensure secure communication, enable SSL Encryption. Also, enter a Technical User from the source system that has the following privileges, along with its Password. Click on Next Step once details are provided.CATALOG READ.SELECT on the schemas of the users to be replicated.SELECT on schemas with objects to be replicated.SELECT on any other objects to be replicated.
Step 7: Upon entering valid details, a Green tick with “Connection (TEST_REPLICATION) has been created” message will appear.
Optional Step: Select the users if it needs to be replicated to the SAP HANA Cloud database and for this, specify whether to allow or disallow the replication of privileges. For each replicated user, a new password needs to be set. Post this, Click on Next Step.
Step 8: Now, select the objects (Table / View) for which replication needs to be enabled. Use the search bar for getting the required objects. Choose the replication schedule as “Real Time” for real-time data replication or “None” for data snapshots. Once the objects are selected, click Confirm.
Step 9: By clicking the Confirm button, the replication will be configured and triggered. Once the tables are replicated, the status for Real Time will show as “Loading…” and the status for None (Snapshot) will show as “Completed.” For snapshot replication, you can schedule it based the requirement by clicking the “Set Replication Schedule” button. If there are multiple objects, the overall replication status can be seen on the left-hand side.
Step 10: Cross-verify all the details by opening the SAP HANA Database Explorer and perform the following check.The connection name provided initially will appear under Remote Sources.The replicated tables will appear under Tables with the name VT_CONNECTIONNAME_SCHEMANAME_TABLENAME. Select it and click on Open Data to view the replicated table data.
HANA Cloud Replication Services enable real-time or scheduled (snapshot) data replication from various source systems into SAP HANA Cloud. These services are designed to ensure high data availability, consistency, and low-latency access by synchronizing data between operational and analytical environments. Replication is done via Smart Data Access (SDA) and can be set up for replicating from HANA on-premise databases to HANA Cloud databases.SAP HANA Cockpit provided the platform for managing replication services. While this service has been widely used, now it is being phasing out from HANA Cockpit in favor of SAP HANA Cloud Central. SAP HANA Cloud Central is the unified management platform for all SAP HANA Cloud services, including replication. Moving forward, this platform will provide the functionalities for managing replication tasks and improve user experience.The below are the steps of creating data replication using the SAP HANA Cloud Central.Step 1: Log in to SAP BTP Cockpit. Navigate to Instances and Subscriptions. Launch the SAP HANA Cloud tools (SAP HANA Cloud Central) application. If it is not present, kindly subscribe for the same by selecting it from the Create button of Instances and Subscriptions page.Step 2: Select (click) the SAP HANA Cloud Database in which the data replication needs to be configured.Step 3: Once the SAP HANA Cloud Database is selected, a right panel will open with Overview of the selected SAP HANA Cloud Database.Step 4: Inside the panel, search for the Data Replication tile and click on Create Replication Task button.Step 5: Under Connection Type, ‘+ Create a New Connection’ will be selected by default. Depending on the source, select the required connection type and click on Next Step.Please note that ‘SAP HANA 2.0 On-Premise SPS 05 or Higher’ is selected here for illustration purposes.Step 6: Provide an appropriate Connection Name, Host along with its Port, and SAP Cloud Connector Location ID. To ensure secure communication, enable SSL Encryption. Also, enter a Technical User from the source system that has the following privileges, along with its Password. Click on Next Step once details are provided.CATALOG READ.SELECT on the schemas of the users to be replicated.SELECT on schemas with objects to be replicated.SELECT on any other objects to be replicated.Step 7: Upon entering valid details, a Green tick with “Connection (TEST_REPLICATION) has been created” message will appear.Optional Step: Select the users if it needs to be replicated to the SAP HANA Cloud database and for this, specify whether to allow or disallow the replication of privileges. For each replicated user, a new password needs to be set. Post this, Click on Next Step.Step 8: Now, select the objects (Table / View) for which replication needs to be enabled. Use the search bar for getting the required objects. Choose the replication schedule as “Real Time” for real-time data replication or “None” for data snapshots. Once the objects are selected, click Confirm.Step 9: By clicking the Confirm button, the replication will be configured and triggered. Once the tables are replicated, the status for Real Time will show as “Loading…” and the status for None (Snapshot) will show as “Completed.” For snapshot replication, you can schedule it based the requirement by clicking the “Set Replication Schedule” button. If there are multiple objects, the overall replication status can be seen on the left-hand side.Step 10: Cross-verify all the details by opening the SAP HANA Database Explorer and perform the following check.The connection name provided initially will appear under Remote Sources.The replicated tables will appear under Tables with the name VT_CONNECTIONNAME_SCHEMANAME_TABLENAME. Select it and click on Open Data to view the replicated table data. Read More Technology Blogs by Members articles
#SAP
#SAPTechnologyblog
