Monday 15 July 2019

SAP HANA Smart Data Integration and Smart Data Quality Webcast Recap

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.

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

The legal disclaimer applies

Everything subject to change

SAP assumes no responsibility.

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

Use interface

Take advantage of SAP HANA memory speed

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

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

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

Supports IT team

Development tool for IT team

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

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

One HANA platform

Part of HANA platform

From any data source

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

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

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

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

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

DP agent can be downloaded from SMP

Connect to DP Server

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

Transformations executed in calc engine

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

Supports design time artifacts

Drag and drop interface

Flowgraph

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

Available transformations

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

Supports real time

RestAPI can be used in consuming applications

Not all transformations are available in real time

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

Replication task is another artifact

Single or mass replication

Basic transformations

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

Data masking to protect information with SSL

Data masking transformation

Different data masking variants

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

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

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

Executes on the script server

Turn on script server and data provisioning server

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

SDQ helps get accurate geo code information

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

Real time data quality check and verification

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

Data Hub manages data movement

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

Outlook for Data Hub; SDI/SDQ already there

ADP is a work in progress

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

Data Hub architecture

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

Road map was not covered during webcast

SAP HANA Tutorial and Material, SAP HANA Certifications, SAP HANA Study Materials, SAP HANA Guides

Road map was not covered during the webcast

Source: SAP

No comments:

Post a Comment