Skip to Content
Product Information
Author's profile photo Tammy Powlas

SAP HANA Smart Data Integration and Smart Data Quality Webcast Recap

This was a SAP User Group webcast from last week.

Abstract is here:

Analytics is the core of running the business with deep insight for decision making. Running the business is better or rather say best, when the platform is SAP HANA. The critical fuel for analytics is right data. Data can be raw and as is or it can be enriched and improved to make it meaningful. Data Integration with Data Quality is the key to procure and make data meaningful. In this session we will be sharing level two information about SAP HANA Smart Data Integration and Smart Data Quality with additional information on Data Virtualization.

1sdi.png

Source: SAP

The legal disclaimer applies

Everything subject to change

SAP assumes no responsibility.

Source: SAP

Use interface

Take advantage of SAP HANA memory speed

3sdi.png

Source: SAP

Capabilities in SAP HANA

Operational/analytical use cases

SDI – real time, batch, ELT

SDQ – data quality – data cleansing, geo-coding matching

Embedded in SAP HANA

Can deploy on premise or in cloud

4sdi.png

Source: SAP

Supports IT team

Development tool for IT team

Access, move, transform, cleanse data in real time or batch

5sdi.png

Source: SAP

One HANA platform

Part of HANA platform

From any data source

6sdi.png

Source: SAP

SDI – ingest data from wide variety of data sources

Combines capabilities of SAP Data Services and SLT

Get changes in real time depending on type of source

Can be log based scanning

Some cases is trigger based, resembling SLT

Can send data back into certain targets; check PAM

Use SAP WebIDE going forward, use URL to access design time

7sdi.png

Source: SAP

Install agent on premise

Agent acts as a proxy

On premise use TCP/IP; use HTTPS in cloud

Agent compresses data (to minimize bandwidth) and sends over TCP/IP in HANA

8sdi.png

Source: SAP

DP agent can be downloaded from SMP

Connect to DP Server

9sdi.png

Source: SAP

Transformations executed in calc engine

10sdi.png

Source: SAP

Supports design time artifacts

Drag and drop interface

Flowgraph

11sdi.png

Source: SAP

Available transformations

12sdi.png

Source: SAP

Supports real time

RestAPI can be used in consuming applications

Not all transformations are available in real time

13sdi.png

Source: SAP

Replication task is another artifact

Single or mass replication

Basic transformations

14sdi.png

Source: SAP

Data masking to protect information with SSL

Data masking transformation

Different data masking variants

15sdi.png

Source: SAP

In-built capability for data quality; part of SAP HANA

Use in-memory capabilities

Cleanse transformation to identify duplicates

Match transformation

Geocode transformation to enrich data with lat/longitude

Reverse geo coding to provide address

Geocoding integrates with HANA spatial

16sdi.png

Source: SAP

Executes on the script server

Turn on script server and data provisioning server

17adi.png

Source: SAP

SDQ helps get accurate geo code information

19sdq.png

Source: SAP

Real time data quality check and verification

20sdq.png

Source: SAP

Data Hub manages data movement

21sdq.png

Source: SAP

Outlook for Data Hub; SDI/SDQ already there

ADP is a work in progress

22sdq.png

Source: SAP

Data Hub architecture

23sdq.png

Source: SAP

Road map was not covered during webcast

24sdq.png

Source: SAP

Road map was not covered during the webcast

Replay is here

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo David Nguyen
      David Nguyen

      Great info Tammy!

      Thanks

      David