DynamoDB is serverless with no servers to provision, patch, or manage and no software to install, maintain, or operate. DynamoDB automatically scales tables up and down to adjust for capacity and maintain performance. Availability and fault tolerance are built in, eliminating the need to architect your applications for these capabilities. Amazon DynamoDB; Google Bigtable; InfluxDB; Apache Cassandra; Redis; Apache Hive; All these databases have SQL interface and you can work with them as with good old relational databases. And this is not some kind of JDBC driver abstraction – DBeaver EE supports all native data types and databases structure explorer for these databases. Create a JDBC Data Source for Amazon DynamoDB Data Follow the steps below to load the driver JAR in DBeaver. Open the DBeaver application and, in the Databases menu, select the Driver Manager option. Click New to open the Create New Driver form.
On this page are instructions on how to configure database clients for non-SQL databases. If you use any of the below SQL databases, see the Connect to SQL Databases page.
- MySQL
- Aurora MySQL
- Clustrix
- MariaDB
- MemSQL
- PostgreSQL
- Aurora PostgreSQL
- Citus
- Greenplum
- Microsoft SQL Server
The Connection Process
- Connect to the datasource in your GUI by clicking on its name in the GUI or running
sdm connect <name>at the command line. - Ensure that there is a green lightning bolt next to the datasource name in the GUI or the datasource is listed as
connectedif you runsdm statusat the CLI. - Find your preferred database client from the tables below and use the specified parameters to configure the connection. Note that every client is different and if you do not use the correct parameters, the connection will fail! If your client is not listed below, please contact support@strongdm.com with details.
- Initiate the connection within your database client.
GUI Clients
The connection matrix below contains required connection parameters for many popular database GUI clients. Please note that if you are using port overrides or custom ports you may need to change the default database port to the specific port specified in your local GUI, in addition to the hostname field.
MongoDB
| Client | Hostname | Username | Password | Initial DB | Additional Settings |
|---|---|---|---|---|---|
| dbKoda | localhost | empty | empty | empty | |
| MongoDB Compass | localhost | empty | empty | empty | |
| Mongotron | localhost | empty | empty | empty | |
| NoSQLBooster | localhost | empty | empty | empty | |
| Robo 3T (Robomongo) | localhost | empty | empty | empty |
Redshift
See the JDBC Drivers section for information on how to use the Redshift JDBC driver.
| Client | Hostname | Username | Password | Initial DB | Additional Settings |
|---|---|---|---|---|---|
| DBeaver | localhost | empty | empty | empty | |
| DataGrip | localhost | empty | empty | empty | |
| DbVisualizer | localhost | empty | empty | any string | |
| HeidiSQL | localhost | empty | empty | empty | |
| Navicat | localhost | empty | empty | empty | |
| Postico | localhost | empty | empty | empty | |
| SQLPro Studio | localhost | any string | empty | empty | |
| Tableau | localhost | any string | any string | any string | |
| SQL Workbench/J | localhost | any string | any string | empty |
Snowflake
| Client | Hostname | Username | Password | Initial DB | Additional Settings |
|---|---|---|---|---|---|
| DBeaver | localhost | empty | empty | empty | any string as account property and false as SSL property under Driver Properties |
Db2 LUW
| Client | Hostname | Username | Password | Initial DB | Additional Settings |
|---|---|---|---|---|---|
| DBeaver | localhost | any string | any string | any string | |
| DbVisualizer | localhost | any string | any string | any string |
Db2i
| Client | Hostname | Username | Password | Initial DB | Additional Settings |
|---|---|---|---|---|---|
| DBeaver | localhost | any string | any string | any string | From the Driver Properties settings, portNumber must be set to the SDM port-override value. |
| DbVisualizer | localhost | any string | any string | any string | Load a driver compatible with DB2 iseries, such as: jt400-10.4.jar. Once added go to the Driver Properties and set the portNumber to the SDM port-override value. |
Sybase ASE, Sybase IQ
| Client | Hostname | Username | Password | Initial DB | Additional Settings |
|---|---|---|---|---|---|
| DBArtisan | localhost | any string | any string | empty | |
| DataGrip | localhost | any string | any string | empty | |
| Dbeaver | localhost | any string | any string | empty | |
| DBVisualizer | localhost | any string | any string | empty | |
| ERStudio | localhost | any string | any string | empty | |
| RapidSQL | 127.0.0.1 | any string | any string | empty | |
| SQL Workbench/J | localhost | any string | any string | empty |
JDBC Drivers
Some JDBC drivers have very specific connection string requirements. When using the below JDBC drivers, we recommend entering the connection string directly. Replace <port> with the configured port. Where it says any you can replace with any string, but a string must be there for proper functionality.
| Driver | Connection String |
|---|---|
| Athena (driver versions 2.0.5, 2.0.6) | jdbc:awsathena://UseResultsetStreaming=0;ProxyHost=localhost;ProxyPort=port;Protocol=http;AwsRegion=us-any-1;UID=any;PWD=any;S3OutputLocation=s3://any/ |
| jTDS | jdbc:jtds:sqlserver://localhost:port/any;user=any;password=any;ssl=request |
| Redshift | jdbc:redshift://localhost:port/any?ssl=false&UID=any&PWD=any |
| Snowflake | jdbc:snowflake://localhost:port/?account=any&SSL=FALSE |
Command-line Clients
| Database type | Sample connection string with port | Sample connection string with database* |
|---|---|---|
| BigQuery | bq --api http://localhost:20000 --disable_ssl_validation ls | |
| Cassandra | cqlsh localhost port | |
| DynamoDB | dynamodb --endpoint-url http://localhost:port | |
| Microsoft SQL Server | sqlcmd -s 127.0.0.1,port | sqlcmd -s 127.0.0.1 -d <database> |
mssql-cli -S 127.0.0.1,port -U sdm -P sdm | mssql-cli -S 127.0.0.1 -U sdm -P sdm -d <database> | |
| MongoDB | mongo --host localhost --port port | |
| MySQL, Aurora MySQL, MariaDB, MemSQL | mysql -h 127.0.0.1 -P port | |
| PostgreSQL, Aurora PostgreSQL, Citus, Greenplum, Redshift | psql -h localhost -p port | psql -h localhost -d <database> |
| Redis | redis-cli -h localhost -p port | |
| Snowflake | SNOWSQL_PWD=none snowsql -u sdm -a sdm -d <database> -s <schema> -w <warehouse> -h localhost -p port -D protocol=http |
See the following section for why you may need to specify a database with these database types
Dbeaver Dynamodb Global
REST API Connections
Dbeaver Dynamodb
Some database types allow REST API access---Druid in fact requires it. To connect to these databases, replace the host and port in the URL with localhost and the configured port in strongDM.
Dbeaver Amazon Dynamodb
Example for Druid: http://localhost:18090/druid/indexer/v1/task
Dbeaver Community Dynamodb
If you have trouble connecting with your database client, please contact support@strongdm.com with details.