DynamoDB ODBC and JDBC Drivers

Deliver SQL on NoSQL, full reporting capabilities to data analysts

Current Versions ODBC 1.1.1 | JDBC 1.1.3

OEM & Distribution
  • DB Visualizer
  • Excel
  • Looker
  • Microstrategy
  • NoSQL
  • Other JDBC
  • Other ODBC
  • PowerBI
  • SAP
  • Sisense
  • Tableau

Magnitude Simba Amazon DynamoDB ODBC and JDBC connectors with SQL Connector are simply the best ways to connect your BI application of choice to your DynamoDB data.

Simba Amazon DynamoDB ODBC and JDBC connectors with SQL Connector give you relational access to your NoSQL data, so you (and your analysts) can leverage existing SQL expertise to query NoSQL data. The Simba connectors can also virtualize your data, which ensures that your traditional BI tools work effectively—even with unstructured data.

Since the Amazon DynamoDB data warehouse is schema-less, Simba DynamoDB connectors with SQL Connector allow users to define schemas on the fly, providing a powerful SQL window into DynamoDB data. In addition, Simba SQL engine’s built-in Collaborative Query Execution (CQE) passes down filters to provide high-performance access to DynamoDB databases.

Features

  • Provides SQL ODBC and JDBC interfaces that enable applications to work with data stored in DynamoDB
  • Support complex DynamoDB data types such as lists, maps, and sets, by converting them into virtual tables
  • Generates a database schema that maps the DynamoDB data to a SQL-compatible format
  • Expanded Schema support for numeric data types
  • Allows easy editing of generated schema using bundled Schema Editor
  • Renormalization supported for multiple levels of nested data
  • Improved connector performance thanks to configurable parallelization of data scans
  • Support for on-premises and AWS-hosted DynamoDB instances
  • Support for IAM credentials and credentials file

Specifications

ODBC 3.80 support
JDBC 4.2, 4.1 and 4.0 support
Support for 32- and 64-bit platforms
Unicode support
Support for iODBC 3.52.7 or later, or unixODBC 2.3.0 or later
Support for Mac OS X 10.9 or 10.10
Supported on Red Hat Enterprise Linux 5,6, or 7, CentOS 5, 6, or 7,
SUSE Enterprise Server 11 or 12, Ubuntu 12.04 or 14.04, Debian 7 or 8
Supported on Windows 7 SP1, 8, or 8.1, Windows Server 2019 R2 SP1, 2012, or 2012 R2

Documentation

User Guides, Release Notes, and FAQs.

Ready to buy? We're here to help!

If you are evaluating our drivers or our Simba SDK, our Sales Engineers would be happy to assist you.