Today's dynamic business world, requirement trends change like anything. But most common scenario is as follows:
• Multiple Data Sources with different Technology
• Only one-time or recursive requirement
Challenges !!!
- Complex Data Management for Simplest Query
- May leads to duplicate data storage for central analysis
- Data Security
- Legal or Risk Factors
- Huge Cost
Easy Solution???
Using SAP HANA Smart Data Access we can provide the solution. For EMCWorld 2014 Demo, I had created this demo with Oracle use case; although video quality is not good here & without audio as it is before professional editing; but still hope it will be helpful & informative.
In this demo, I had discussed a scenario between Oracle and SAP HANA data with following activities:
• Oracle Table Data showing in SAP HANA
• Simple Query in SAP HANA Studio for Oracle data
• Union between two Oracle tables data from SAP HANA Studio
• Update data in SAP HANA – changes reflect in Oracle
• Update data in Oracle – Changes reflect in SAP HANA Studio
• Union between Oracle table data with SAP HANA table data in SAP HANA Studio
• Smart Data Access – Monitoring/Admin Console in SAP HANA Studio
Setup used for this demo -
SAP HANA Sever : running on VM – 24GB Standalone HANA 1.0 SPS 7 - SLES 11 SP1
Oracle Server : Oracle 12c - Windows - Standard Edition - on Dell Laptop, OS Win7, 64bit with 8GB RAM