Skip to Content

Integrate and Monitor Data with SAP Data Warehouse Cloud

test
0 %
Integrate and Monitor Data with SAP Data Warehouse Cloud
Details

Integrate and Monitor Data with SAP Data Warehouse Cloud

September 14, 2021
Created by
September 14, 2021
Get started with Data Integration Monitor, which allows you to monitor the frequency and status of data loads for each table within a Space.

You will learn

  • How to access the Data Integration Monitor
  • How to use the Data Integration Monitor dashboard
  • The types of monitoring you can do with the Data Integration Monitor
QR code

The Data Integration Monitor helps you to monitor and manage table replication from sources outside of SAP Data Warehouse Cloud, showing you the frequency of data refresh. It makes it easy to see how many tables you have, how much space they are using, and which actions were recently performed on them. It allows you also to replicate data, create persistent views, analyse remote connections, and get details of these actions.

CSV files uploaded directly to SAP Data Warehouse Cloud are not monitored.

In the video below, you can see an overview of Data Integration Monitor in SAP Data Warehouse Cloud. The steps in this tutorial will guide you through the same process.

Step 1: Access the Data Integration Monitor
  1. In SAP Data Warehouse Cloud, click on the Data Integration icon on the left- side menu.

    DIM
  2. Choose your Space and you see the Remote Table Monitor dashboard.

    RTM

Here you can see an overview of all remote tables that currently exist in this Space.

Log on to answer question
Step 2: Use the Data Integration Monitor dashboard

The Data Integration Monitor works like a dashboard, allowing you to drill down to details about the use of storage within a Space, particularly detailing how many tables are stored in the Space, and giving other details about these tables.

You will get an overview of the remote tables within the Space you have selected, as well as the following details about each table from the remote table monitor dashboard:

  • Name
  • Number of records within that table
  • Connection name
  • Amount of storage space each table is using
  • Date of latest update
  • Date of most recent load and refresh frequency
  • Next run

You can change the way the list is sorted or filter it to find more easily the information you are looking for by clicking on the sort icon next to the table column. As an example, you can find the tables that are consuming more space by filtering the list.

sort

From this main list, you can drill down further by clicking on the drill down icon on the right of the dashboard. This can help you understand how often a table is loaded and what is the status of each time the table was loaded, that is, each time the data within this table was refreshed.

Drill down

You will also be able to go directly from here into the table editing feature of the Data Builder. Click on the open in editor option on the top right to do so.

Log on to answer question
Step 3: Types of monitoring you can do in the dashboard

These are the types of monitoring you can do with the Data Integration Monitor dashboard:

Remote Table Monitor

With this monitor, you can:
• Copy data from remote tables that have been deployed in your Space.
• Monitor the replication of the data.
• Schedule a copy of the full set of data from the source.
• Set up replication of data changes in real time via the change data capturing option.

View Persistency Monitor

The View Persistency Monitor is where you load new snapshot of the data and schedule persisted data views. You can turn your views into persistent views to improve performance while accessing your data.

Data Flow Monitor

The Data Flow Monitor is where you view and monitor the details of the executed data flows.

Remote Query Monitor

The Remote Query Monitor is where you check and analyse how the communication is running between the underlying database of SAP Data Warehouse Cloud, which is SAP HANA Cloud; SAP HANA database, and the connected remote source systems.

Well done!

You have completed the second tutorial of this group! Now you understand the how to access the Data Integration Monitor and what you can use it for.

Learn more about the Remote Table Monitor in SAP Data Warehouse Cloud in the next tutorial.

Log on to answer question
Step 4: Test yourself
What are the metrics you can use to monitor data from the Data integration Monitor Dashboard in SAP Data Warehouse Cloud? (Multiple correct answers)
×

Next Steps

Back to top