In the example video above, you can see an example of SalesOrders
table and SalesOrderItems
table already existing on the system and the demo starts with a completely federated environment where all the data access is remote. The next steps will guide you to do live replication of data instead of a remote access.
-
As an example, imagine you have a table created from SAP HANA connection. To confirm this, go to the home page of SAP Datasphere and click on the Data Builder icon on the left-hand side of the control menu.
-
Choose your Space and click on any of the views for which the SalesOrders
or the SalesOrderItems
remote table was used. This opens the modeling canvas.
-
Here, you will see the information about remote tables that is used for the creation of this view. Click on the SalesOrders
or SalesOrderItems
table on the modelling canvas to see the connection name on the remote properties’ canvas on the right side of the screen. You will see that the connection is from an SAP HANA database. You can check the connection names for any tables in the same way.
-
Now go back to the Data integration Monitor to optimise the remote system and keep the existing data view synchronized.
-
In the tables listed, click on the SalesOrder
or SalesOrderItems
row and then click on the Table Replication option next to the search bar.
-
From the dropdown menu, select Enable Real-Time Access to get the real time data replication of the table.
-
The status now changes to active. You can do the same for any tables you wish to replicate. Now the views which are dependent on these tables get data from SAP Datasphere replica and is stored locally.
-
From the same dropdown menu in step 7 you can select load a snapshot replica to have a one-time data replication from remote tables.