Simba Amazon DynamoDB ODBC and JDBC drivers 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 drivers 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