One of the biggest challenges in taking advantage of the power SAP HANA is getting data into SAP HANA seamlessly. Data takes different forms and shapes in different places – on premise and in the cloud. SAP HANA smart data integration, launched in SAP HANA SPS09 and further enhanced in SAP HANA SPS10, is your solution.
Traditionally, a plethora of tools are used to bring data to SAP HANA from SAP Business Suite, non-SAP Data sources, and cloud sources, with an added tier between the data sources and SAP HANA, as shown in the following diagram.
The vision of SAP HANA smart data integration and SAP HANA smart data quality is to build the data provisioning tier natively within HANA; to simplify the SAP HANA landscape by removing an entire tier previously built with heterogeneous non-native tools.
The native integration capability of SAP HANA smart data integration is architected for on premise, cloud or hybrid deployments, and supports all styles of data delivery including
- Real Time (not all data sources)
In addition, the architecture benefits in-memory processing in HANA, which gets a massive performance boost along with an open framework and SDK. All of this enables you to build custom adapters to integrate any data sources your imagination allows to get data into HANA
Use Cases for SAP HANA smart data integration
Like an ETL tool, SAP HANA smart data integration can be used for a wide variety of use cases. With new functionalities coming in each HANA SP release, it can support almost all your data integration requirements. However, we recommend you start with the following use cases.
- Virtualized access for non-critical data
- Side car scenarios for OLTP based reporting
- ETL for HANA native data marts and data warehouses
- Migration of data from legacy systems into SAP HANA or other external systems
- Batch or real time integration of external systems and SAP HANA
SAP HANA smart data access (SDA) functionality is further enhanced in SAP HANA smart data integration to provide virtual access for non-critical data. Using the http(s) protocol, SAP HANA smart data integration enables you to access non-critical data sitting outside of the firewall. Also, replication is possible for some data source types. Moreover, processing is done in a new HANA process called DPServer which enhances the stability of core HANA processes.
Where do you start?
If SAP HANA is core in your landscape, we suggest you identify a few data integration scenarios based on the above use cases and implement these with SAP HANA smart data integration. If you are new to our products, please check our HANA SP09 and HANA SP10 video playlists to see how SAP HANA smart data integration and SAP HANA smart data quality can help you simplify your data integration landscape and open your new avenues to bring data from new sources to build new applications leveraging breakthrough innovation in SAP HANA. You can also check out SAP HANA SPS10 – What’s new in Information Management.
VN:F [1.9.22_1171]Simplifying your SAP HANA data integration landscape,