An Introduction to SAP HANA Enterprise Information Management (EIM): A New Way to Move Data into SAP HANA
- by Ned Falk, Senior Education Consultant, SAP
- June 24, 2015
Learn the steps needed to set up an SAP Enterprise Information Management (EIM) task to real-time replicate and manipulate a data feed to SAP HANA from an external source database. Learn how to integrate the Smart Data Integration and Smart Data Quality transforms within EIM to clean, join, and otherwise manipulate data via SAP HANA studio or on the cloud.
Reading this article, you will learn how to:
- Position SAP Enterprise Information Management (EIM) tools within your organization
- Set up a project and create an SAP HANA EIM flowgraph
- Make settings to initiate a continuous real-time replication from external database tables to SAP HANA
- Manipulate SAP EIM Smart Data Integration transformations
- Cleanse data with EIM smart data quality transformations
Support Package 9 of SAP HANA introduced the new toolset, SAP HANA Enterprise Information Management (EIM). With it you can load, manipulate, and cleanse data from other databases before moving it into SAP HANA.
SAP Enterprise Information Management (EIM) is a new toolset that is built into SAP HANA with expertise in extraction, transformation, and loading (ETL) combined with the existing SAP real-time replication technology of the SAP Replication Server (SRS) in one tool. It joins a long list of other SAP tools that companies can use to load data into SAP HANA. These existing tools include Direct Extraction Connection (DXC), SAP Landscape Transformation (SLT), SAP BusinessObjects Data Services (BODS), and SRS as a stand-alone.
Although I am not in SAP product management, it is obvious that SAP HANA EIM, like any new product, is evolving. In its current state as a graphical transformation toolset and paired with real-time replication, it is a very handy tool. That said, IT system landscapes from one company to the next are very different. One day soon most companies will, I hope, and SAP hopes, have all their software running on SAP HANA. Until that day arrives, many companies have SAP products running in a heterogeneous landscape with a vast mixture of databases and applications that are non-SAP. I am sure there are more robust positioning guides somewhere on SAP.com but I could not find one. Therefore, in my opinion, if your project is very SAP HANA-centric, you should use SAP HANA EIM wherever its feature list (contained in SAP HANA EIM documentation) meets your needs, as it combines many of the cleansing and manipulation features of SAP data services, along with the real-time replication power of SRS.
Some reasons you may not be able to use it (at least as of May 2015) include, for example, the lack of support for all databases as sources. Another reason is that the feed is at the table or view level and that means you can’t leverage the BW extractors as you can with SAP’s Data Services product (BODS). For these and other features that you might need to feed into an SAP HANA environment, SAP continues to support the more established toolsets of DXC, SLT, SRS, and BODS.
SAP HANA EIM Initial Preparation and Installation Steps
Like other features of SAP HANA, SAP HANA EIM first requires a technical installation of various software components, and then the assignment of roles containing privileges to the users who will perform the EIM modeling.
Would you like to see this full item?