- SAP HANA Admin Tutorial
- SAP HANA Admin - Home
- SAP HANA Admin - Overview
- Architecture Overview
- Multitenant Database
- Multiple Host Systems
- Tools
- Cockpit
- Studio
- SAP HANA Admin - System Mngmt
- Multitenant DB Container Mgmt
- Starting a HANA System
- Stopping a HANA System
- License Keys
- Monitoring the HANA System
- SAP HANA Admin - Table Mngmt
- SAP HANA Admin - Table Partition
- SAP HANA Admin - Table Replication
- Data Compression
- Solman Integration
- SAP HANA Admin - Lifecycle Mngmt
- Securing HANA System
- User Provisioning
- Authentication Methods
- Auditing Activities
- Backing Up HANA System
- Recovery HANA System
- HANA XS Application Service
- Data Provisioning
- Smart Data Access
- New Remote System Connection
- Integration with Hadoop
- Key Commands
- Job Responsibilities
- SAP HANA Admin Useful Resources
- SAP HANA Admin - Quick Guide
- SAP HANA Admin - Useful Resources
- SAP HANA Admin - Discussion
SAP HANA Admin - Integration with Hadoop
In SAP HANA system, you can also integrate SAP HANA computing power with Hadoop to process huge amount of data at faster speed. Hadoop system is used for storing huge amount of unstructured data and HANA provides high speed data analysis.
Following scenarios can be used to connect SAP HANA system to Hadoop −
- Hive ODBC Driver
- Smart Data Integration
- HANA Spark Controller
To use Smart Data Access to connect to Hadoop system in HANA Studio, select Adapter Name: Hadoop
In Connection Properties, enter the URL and Credentials.
You can also use the following SQL statement to create a remote connection to connect to Hadoop system. We have selected Authentication type as Password here −
CREATE REMOTE SOURCE RC_Hadoop ADAPTER "hadoop" CONFIGURATION 'webhdfs_url = http:// <full_qualified_domain_name> : 50070;webhcat_url = http:// <full_qualified_domain_name> :50111' WITH CREDENTIAL TYPE 'PASSWORD' USING 'user = username;password = pwd';
Enter the above SQL statement in HANA Studio SQL editor and click the Execute button.
This way you can integrate your SAP HANA system with Hadoop using Smart data integration in HANA Studio.
