Access, query & analyze data across data warehouse & Hadoop
Access data from disparate sources
Provides federation and integration capabilities, enabling you to virtualize and join disparate data sources in a single query.
Leverage SQL knowledge
Not only allows you to run SQL on Hadoop, but understands SQL dialects from Db2, Netezza, Oracle SQL and PL/SQL to enable unchanged porting of applications.
Improve query performance
Can run all 99 TPC-DS queries up to 100TB with numerous concurrent users. Supports multiple workers per node for efficient CPU and memory utilization.
Gain secure access to data
Provides centralized security administration using role-based access control, row-based dynamic filtering, column-based dynamic masking and ranger integration.
Explore key features
- Standards-compliant ODBC and JDBC
- Point queries
- Apache Spark integration
- Federation capabilities
- Compatibility with multiple SQL dialects
- Available on IBM Power
- HDMP Flex