The data returned from a Hadoop analysis can be integrated into an
SAP Sybase IQ database in several ways.
- ETL Processing – Bulk load data from Hadoop data stores into SAP Sybase IQ
using the open source utility SCOOP.
- Data Federation – Expose HDFS files as tables in an SAP Sybase IQ database
that participate in SQL queries. The HDFS files do not need to be loaded into
SAP Sybase IQ.
- Query Federation – Allow SQL queries in SAP Sybase IQ to execute Hadoop
processes that return data that is incorporated into the SQL result set.
- Client-side Federation – Federate queries across SAP Sybase IQ databases and Hadoop
files using the TOAD© SQL tool.