HANA integration involves setting up data pipelines, authentication mechanisms and data provisioning procedures as well as the use of Smart Data Access (SDA) and Smart Data Integration (SDI). These technologies ensure seamless and efficient data integration and processing within different systems and platforms. By using these advanced integration methods, SAP HANA specialists can optimize data integration and processing, resulting in a more efficient and powerful SAP HANA environment.
We are happy to support you in the following areas:
| Smart Data Access | SAP HANA Smart Data Access (SDA) enables access to remote data as if it were stored in local tables in SAP HANA, without physically copying the data to SAP HANA. This capability allows data from multiple remote systems to be integrated in real time. Linked databases are used in SAP HANA or virtual tables are created that reference remote tables in different databases. SQL queries can then be written in SAP HANA using these virtual tables. SAP HANA’s query processor optimizes these queries by executing the relevant part of the query in the remote database, returning the results to SAP HANA and completing the operation there. Physical data movements are not supported by SDA. As Smart Data Access is part of the SAP HANA core system, no additional licenses are required. Additional support packages and patches are available from the SAP Software Download Center and are installed using the SAP HANA Database Lifecycle Manager (HDBLCM). For a list of supported remote data sources and versions, see SAP Note 2600176 – SAP HANA Smart Data Access Supported Remote Sources. SAP HANA SDA enables the creation of virtual tables that reference remote sources such as SAP ASE, SAP IQ, Hadoop and Teradata. |
| Smart Data Integration | SAP HANA Smart Data Integration (SDI) provides the architecture that supports all types of data provisioning in SAP HANA: Real-time, Batch and Federation (SDA). It includes both data replication and data transformation services. Data can be loaded into HANA (on-premise or in the cloud) from various sources using SAP HANA Smart Data Integration and SAP HANA Smart Data Quality in batch or real-time modes, using pre-built and custom adapters. This method is implemented by installing a Data Provisioning Agent that hosts adapters and connects the source system to the Data Provisioning Server in the HANA system. Replication tasks are created using WebIDE to replicate data, or flowgraphs are created using Application Function Modeler nodes to transform and cleanse the data on its way to HANA. For more information on deploying Smart Data Integration, see the SAP HANA Smart Data Integration and SAP HANA Smart Data Quality Master Guide on the SAP Help Portal. |
| Data Replication Technologies | The trigger-based replication method uses the SAP Landscape Transformation (LT) Replication Server component to transfer data from the source system to the SAP HANA database system. The SAP HANA Direct Extractor Connection (DXC) provides SAP HANA preconfigured data models based on SAP Business Suite entities and is also a method for data acquisition. ETL-based data replication (Extraction Transformation Load) uses SAP Data Services to load relevant business data from SAP ERP into the SAP HANA database, making it possible to read business data at the application layer level. Log-based replication with SAP Replication Server (SRS) moves and synchronizes transactional data (including DML and DDL) across the enterprise, providing low impact, guaranteed data transfer, real-time business intelligence and zero business interruption. |
| SAP HANA Hadoop Integration | Regardless of the structure, you can combine the in-memory processing power of SAP HANA with Hadoop’s ability to store and process large amounts of data. SAP HANA is designed for high-speed data and analytics scenarios, while Hadoop is designed for very large, unstructured data scenarios. Hadoop can scale to thousands of nodes and is designed for use in large distributed clusters to handle big data. By combining SAP HANA and Hadoop, you leverage the lower storage costs and flexibility of Hadoop with the high-speed in-memory processing and highly structured data compliance of SAP HANA. The SAP HANA Hadoop integration is for users who want to use SAP HANA with their Hadoop ecosystem. For more information on the SAP HANA Hadoop integration and how to install the SAP HANA Spark Controller, please refer to the SAP HANA Hadoop integration documentation. |
