Enhance your modern data warehouse

IBM® Db2® Big SQL is a hybrid SQL engine for Hadoop that delivers data querying for the enterprise. Use a single database connection or query to connect to disparate sources such as HDFS, RDMS, NoSQL databases, object stores and WebHDFS. Enjoy low latency, support for ad-hoc and complex queries, high performance, security, SQL compatibility and federation capabilities to get the most from your data warehouse and SQL on Hadoop. Get started in 30 minutes with Db2 Big SQL Sandbox. This personal desktop environment is preconfigured with sample data, a tutorial and an exercise to help you test, and try out new software features.

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

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

Product images

Easy deployment and configuration
Easy deployment and configuration
Intuitive query editor
Intuitive query editor
Cluster monitoring
Cluster monitoring
Overview of SQL execution
Overview of SQL execution
Administer Hadoop tables
Administer Hadoop tables
Graphical query execution plan
Graphical query execution plan