Skip to Content
Author's profile photo Shibajee Dutta Gupta

SAP HANA Smart Data Integrator on SAP HANA, express edition (HXE)

SAP HANA Smart Data Integrator on SAP HANA, express edition (HXE)



We’re very pleased to announce that SAP HANA, express edition (HXE) now includes SAP HANA smart data integration, which provides the ability to integrate data from a variety of different data sources.


High level architecture


Any data integration must procure data and output data or information. To address the procurement and output of data there are components that need to play in harmony. Primary components of SAP HANA Smart Data Integration are:


  1. Data Provisioning Agent*
  2. Data Provisioning Server
  3. HANA_IM_DP_DU (Deployed on SAP HANA XSC**)


* Previously installed DP Agent should be un-installed or use a different host.

**SAP HANA extended application services, classic model

Connecting to data sources


SAP HANA smart data integration includes a set of adapters for a wide variety of different data sources (for example SAP systems, databases, files, social media, and so on) Please have a look at the SAP HANA smart data integration Product Availability Matrix (PAM***) for more details on supported adapters and their functional overview.

Some of the common and frequently used connectors are:

  • Microsoft SQL Server
  • Oracle Database
  • SAP ECC and SAP BW

SAP HANA smart data integration also has an adapter SDK that allows customers and partners to build custom adapters to other data sources. Please have a look at the Adapter SDK Guide for more details.


*** You will need a valid SAP user id (aka S-ID) to access PAM


Virtualize Data


Query data from external data sources via the SAP HANA SQL interface, regardless of its physical location (for example, on your laptop, in your corporate network, in the cloud, and so on), how it’s stored (for example, in a database, a file, and so on) or how it needs to be accessed (for example, JDBC, ODBC, OData, REST, and so on)


Replicate Data

  • Replicate data from a variety of data sources into SAP HANA.
  • Perform a one-time data load or an initial load with subsequent real time replication of changes.
  • Replicate a table as-is or modify the target structure by adding or removing columns.
  • Change the value of any column by using SAP HANA SQL functions.
  • Reduce the number of records to be replicated by applying filters.


Extract, Transform, and Load Data


Extract data from a variety of data sources, transform it using one of the many available data integration nodes (for example, Case, Join, History Preserving, Table Comparison, and so on) and load it into SAP HANA. You can perform a one-time data load, an initial load with subsequent periodic delta loads, or an initial load with subsequent real time replication of changes.


Monitoring & Operations


Registering Data Provisioning Agents and Data Provisioning Adapters is possible through a graphical user interface. Interactive execution and scheduling of Flowgraph and Replication Task is provided, followed by the monitoring of such tasks. The capability extends to batch as well as real-time tasks. Email alerts on task failure is also a part of the solution and helps prototype operational governance before rolling out to the enterprise platform.


Design time tools


Design time tools for building data integration scenarios are available in the SAP HANA Web Based Development Workbench. The ‘Editor’ option within the Development Workbench has two primary utilities for SDI

  • The Replication Task editor allows you to build Replication Tasks to replicate data from an external system into SAP HANA, as an initial load or with real time replication.
  • The Flowgraph editor allows you to design partition based data transformation logic including data cleansing and enrichment. There are additional functionalities of the flowgraph that are documented in the product documentation

Try it Out

If you’re interested in taking it for a test spin, the easiest way to get started is to follow this link. which takes you through the steps of installation and configuration of SAP HANA Smart Data Integrator


More Information

There’s lots of material available to help you build your data integration scenarios:


Assigned Tags

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

      Thanks for sharing this.

      can you please share how we can configure sdq with MDG. I’m not able to find any document in sap portal.