Create Persistent Views in the Data Integration Monitor
- How to access the View Persistency Monitor
- How to create a persistent view
- How to schedule persistent data access
jmmargoOctober 13, 2023
SAP Datasphere already includes options to persist data from the remote tables and schedule its regular replication. You can also pre-compute the modeled views instead of the remote tables themselves by determining the data that a view uses and scheduling them for the required data replication.
Whether you choose to persist a view or remote tables depends on your performance and data storage needs. Remote tables are always replicated as exact copies from the original source. On the other hand, replicating a view will replicate and persist only the data that is included in the view.
This way you can filter the original data from a remote source and replicate only the data that you need.
- Step 1
-
In SAP Datasphere, click on the Data Integration icon on the left- side menu.
-
Choose your Space and you see the Remote Table Monitor dashboard. You can now click on the View Persistency Monitor tab on the top menu.
-
- Step 2
-
To select a view to persist, click on the plus icon.
-
In the next dialog, you can see the list of views available in your Space. As an example, you can see a view in the screenshot below.
-
Click on the view you want in the dialog and select OK to persist a view.
-
Click on the refresh icon and the status of the view will change to Available.
-
- Step 3
-
Once the view persistency is created for a view, click on the view and go to the Schedule option on the top right of the View Persistency Monitor dashboard.
-
In the Create schedule dialog, you will see the scheduling details similar to scheduling data replication for remote tables. This includes the refresh frequency, month, day, year, start date, and end date.
-
Click on OK. You will see the updated fields in the view persistency monitor dashboard with refresh frequency, last updated, next run.
Well done!
You have completed the Introduction to Data Preparation tutorial group in SAP Datasphere. Now it is time to continue learning.
Please check out the other SAP Datasphere tutorials available here, and do not forget to follow the SAP Datasphere tag in the SAP Community to hear about the most up to date product news. -