SAP HANA EIM
I was in 2 minds where to put this short blog. Do I put it in the HANA or Enterprise Information Management areas of SCN. I decided to put it in the EIM area as there are already a number of articles in HANA and I wanted to introduce some new capabilities within the more traditional EIM space.
SAP HANA SP09 introduced a whole host of new capabilities. In this blog I’m going to cover 2 of those, Smart Data Integration (SDI) and Smart Data Quality (SDQ), which fall under the umbrella of SAP HANA Enterprise Information Management.
SDI & SDQ have the ability to source data, replicate data, transform and cleanse data in batch or real time into SAP HANA, in on-premise or cloud environments. This provides a simplified landscape where we can provision and consume data.
I’m not going to go into detail about the architecture etc but more information can be found at help.sap.com/hana_options_eim
For those that are familiar with SAP Data Services then the design concepts for SDI / SDQ are similar. We have a HDBFlowGraph (dataflow), sources, transforms and targets.
Transforms are split into 2 main categories, General and Data Provisioning.
|General contains the standard capabilities;
Data Provisioning contains the more advanced transforms;
To create a flowgraph we drag a combination of the required transforms on to the canvas a join them together. In the example below I’m joining 3 source tables in SAP ASE_Orders, ASE_Order_Details & ASE_Customers. The customer data is then passed through the cleanse transform where we are parsing / cleansing name & address information before we load the result set into a template table in HANA.
This is just a brief overview of the new capabilities SAP HANA EIM brings in SP09.
More detailed information and demonstrations can be found here http://scn.sap.com/community/developer-center/hana/blog/2014/11/27/hana-sp9-data-provisioning–overview