index.md

Amazon DocumentDB JDBC Driver Documentation

Overview

The JDBC driver for the Amazon DocumentDB managed document database provides an SQL-relational interface for developers and BI tool users.

License

This project is licensed under the Apache-2.0 License.

Documentation

• Setup
  • Amazon DocumentDB JDBC Driver Setup
  • Connection String Syntax and Options
• Managing Schema
  • Schema Discovery and Generation
  • Managing Schema Using the Command Line Interface
  • Table Schemas JSON Format
• SQL Compatibility
  • SQL Support and Limitations
• JDBC Compatibility
  • JDBC Support and Limitations
• Support
  • Troubleshooting Guide

Getting Started

Follow the requirements and setup directions to get you environment ready to use the Amazon DocumentDB JDBC driver. Assuming your Amazon DocumentDB cluster is hosted in a private VPC, you'll want to create an SSH tunnel to bridge to your cluster in the VPC. If you're a Tableau or other BI user, follow the directions on how to setup and use BI tools with the driver.

Setup and Usage

To set up and use the DocumentDB JDBC driver, see Amazon DocumentDB JDBC Driver Setup.

Connection String Syntax

jdbc:documentdb://[<user>[:<password>]@]<hostname>[:<port>]/<database-name>[?<option>=<value>[&<option>=<value>[...]]]

For more information about connecting to an Amazon DocumentDB database using this JDBC driver, see the connection string documentation for more details.

Schema Discovery

The Amazon DocumentDB JDBC driver can perform automatic schema discovery and generate an SQL to DocumentDB schema mapping. See the schema discovery documentation for more details of this process.

Schema Caching

Once schema is discovered, it is cached in the database to improve performance for subsequent access. See the schema caching documentation to learn more about schema caching behaviour and access requirements.

Schema Management

The SQL to DocumentDB schema mapping can be managed in the following ways:

• generated
• removed
• listed
• exported
• imported

See the schema management documentation and table schemas JSON format for further information.

Note: A common schema management task is to regenerate or clear the existing schema that has become out of date when your database has changed, for example, when there are new collections or new fields in an existing collection. To regenerate or clear the existing schema, please refer to the Schema Out of Date topic in the troubleshooting guide.

SQL and JDBC Limitations

The Amazon DocumentDB JDBC driver has a number of important limitations. See the SQL limitations documentation and JDBC limitations documentation for more information.

Troubleshooting Guide

If you're having an issue using the Amazon DocumentDB JDBC driver, consult the Troubleshooting Guide to see if it has a solution for your issue.