IBM SAP International Competence Center
Connect data sources to SAP HANA on IBM Power Systems via SAP HANA Smart Data Integration
© Copyright IBM Corporation, 2018 Page 4 of 55
1 BACKGROUND AND SCENARIOS ........................................................................................................ 5
1.1 SCOPE AND MOTIVATION ...................................................................................................................... 5
1.2 SAP HANA ENTERPRISE INFORMATION MANAGEMENT ...................................................................... 5
1.3 SAP HANA SMART DATA INTEGRATION USE-CASES .......................................................................... 6
1.4 POSITIONING AND OVERLAP WITH OTHER TOOLS .................................................................................. 6
1.4.1 Secondary database connection in SAP NetWeaver AS ABAP........................................................ 6
1.4.2 SAP HANA Smart Data Access ....................................................................................................... 7
1.4.3 SAP HANA Smart Data Integration Architecture ........................................................................... 8
1.4.4 Data Federation Comparison ......................................................................................................... 9
1.5 DOCUMENTATION ................................................................................................................................. 9
2 CONFIGURE SMART DATA INTEGRATION ................................................................................... 11
2.1 SETUP OF THE TEST SCENARIO ........................................................................................................... 11
2.2 SDI BASE SETUP ................................................................................................................................. 13
2.2.1 Create an DP Agent Admin User in SAP HANA ........................................................................... 13
2.2.2 Create an DP Agent Monitor User in SAP HANA ........................................................................ 14
2.2.3 Enable the Data Provisioning Server ............................................................................................ 15
2.2.4 Download SDI components ........................................................................................................... 16
2.2.5 Download Oracle JDBC Driver .................................................................................................... 17
2.2.6 Deploy Data Provisioning Delivery Unit ...................................................................................... 18
2.2.7 Install the Data Provisioning Agent .............................................................................................. 19
2.2.8 Configure the Data Provisioning Agent ........................................................................................ 21
2.3 SDI APPLICATION SETUP .................................................................................................................... 25
2.3.1 Create a Remote Source in SAP HANA ......................................................................................... 25
2.3.2 Create Remote Source with a SQL statement ................................................................................ 27
2.4 SAP HANA SDI MONITORING ........................................................................................................... 28
2.4.1 Data Provisioning Adapter Monitoring ........................................................................................ 28
2.4.2 Monitoring using the HANA_IM_DP Deployment Unit ................................................................ 28
3 ACCESSING REMOTE DATA SOURCE SCENARIOS ..................................................................... 30
3.1 SAP SDI VIRTUAL TABLE SCENARIO ................................................................................................. 30
3.1.1 Create User and Schema ............................................................................................................... 30
3.1.2 Grant Schema Access .................................................................................................................... 31
3.1.3 Create Virtual Table ...................................................................................................................... 31
3.1.4 Check Virtual Table Definition and Content ................................................................................. 33
3.1.5 Create a Virtual Table using SQL Statements ............................................................................... 38
3.2 SECONDARY DB CONNECTION – DIRECT SCENARIO ........................................................................... 39
3.2.1 Secondary Database Connection – ABAP Coding Options .......................................................... 39
3.2.2 Prepare Secondary DB Connection on the SAP Application Server ............................................. 40
3.2.3 Define Secondary DB Connection in the Database Administrator Cockpit .................................. 40
3.2.4 Access Data in ABAP via Secondary Database Connection ......................................................... 43
3.3 SECONDARY DB CONNECTION – SAP HANA SDI SCENARIO ............................................................ 45
3.4 SECONDARY DB CONNECTION – SAP HANA SDI NATIVE SQL SCENARIO ...................................... 49
3.5 REMOTE DATABASE ACCESS – SAP HANA SDI NATIVE SQL SCENARIO ......................................... 51
4 SUMMARY ................................................................................................................................................ 54