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:
* 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:
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.
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)
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