Skip to Content
SAP IQ

Big Data with SAP IQ and Hadoop

Tags:

We have created guides to assist you with the setup required to use SAP IQ with different Hadoop options:

  • Set Up Hortonworks Hadoop with SAP IQ: This guide is intended to provide directions on the setup required to use IQ with the Hortonworks distribution of the Hive server and HiveQL. This is not a guide to help with IQ installation or setup. For instructions on IQ setup, please check the SAP website.

  • Set Up Intel Hadoop with SAP IQ: This guide is intended to provide directions on the setup required to use IQ with the Intel distribution of the Hive server and HiveQL. This is not a guide to help with IQ installation or setup. For instructions on IQ setup, please check the SAP website.

  • Hadoop to SAP IQ through FIFO Pipe: This document describes yet another ETL method: push data from the Hadoop file system (HDFS) to a FIFO pipe, and then load the data into a global temporary table in IQ using the LOAD TABLE command. In tests performed on a virtual machine (VM) with modest configurations, it took approximately 2 seconds to load 100,000 rows with 2 columns worth of data from HDFS to IQ. The zip file also contains the scripts and data that implement the approach.

View our webcast replay Integrating Hadoop with SAP HANA and SAP IQ presented by Courtney Claussen, Director of SAP Sybase IQ Product Management, on November 12, 2013

No comments