SAP Hana EIM (SDI/SDQ) setup
In my documentation I’ll explain how to setup and configure SAP Hana SP10 EIM (SDI/SDQ) with Sybase IQ database and ERP on Hana database schema source system to replicated data for realtime data replication.
I will show in detail step and configuration point to achieve it.
In order execution
- Create Sybase IQ database
- Enable DP server for SDI
- Enable Script server for SDQ
- Install SDQ cleanse and geocode directory
- Install DU HANA_IM_DP (Data provisioning)
- Install and Register Data Provisioning Agent
- Create remote source
- Data replication and monitoring
Configuration required on SP9
The xsengine needs to be turn to true (if not done)
The statistic server needs to be turn to true (if not done)
The DU HANA_IM_ESS needs to be imported
Guide used
SAP Hana EIM Administration Guide SP10
SAP Hana EIM Configuration guide SP10
Note used
179583 – SAP HANA Enterprise Information Management SPS 10 Central Release Note
Link used
http://help.sap.com/hana_platform
Overview Architecture
Starting Hana SP9 the new features call SDI (Smart Data Integration) and SDQ (Smart Data Quality) has been introduce.
The purpose of these new features is to leverage an integrated ETL mechanism directly into Hana over SDA
To make it simple:
- Smart Data Integration provide data replication and transformation services
- Smart Data Quality provide an advanced transformation to support data quality functionality
Create Sybase IQ database
In order to have a dedicated database to work with I’ll create my own database into IQ server:
From the SCC go to administration and proceed as follow
SCC agent password: the password define during the IQ server installation
Utility server password: auto fill do not change it
IQ server
如若转载,请注明出处:https://www.gavindong.com/2453.html