Dbeaver Dynamodb

The CData JDBC Driver for PostgreSQL implements JDBC standards that enable third-party tools to interoperate, from wizards in IDEs to business intelligence tools. This article shows how to connect to PostgreSQL data with wizards in DBeaver and browse data in the DBeaver GUI.

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. 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.

Create a JDBC Data Source for PostgreSQL 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.
In the Driver Name box, enter a user-friendly name for the driver.
To add the .jar, click Add File.
In the create new driver dialog that appears, select the cdata.jdbc.postgresql.jar file, located in the lib subfolder of the installation directory.
Click the Find Class button and select the PostgreSQLDriver class from the results. This will automatically fill the Class Name field at the top of the form. The class name for the driver is cdata.jdbc.postgresql.PostgreSQLDriver.
Add jdbc:postgresql: in the URL Template field.

Create a Connection to PostgreSQL Data

Follow the steps below to add credentials and other required connection properties.

In the Databases menu, click New Connection.
In the Create new connection wizard that results, select the driver.
On the next page of the wizard, click the driver properties tab.
Enter values for authentication credentials and other properties required to connect to PostgreSQL.
To connect to PostgreSQL, set the Server, Port (the default port is 5432), and Database connection properties and set the User and Password you wish to use to authenticate to the server. If the Database property is not specified, the data provider connects to the user's default database.
Built-in Connection String Designer
For assistance in constructing the JDBC URL, use the connection string designer built into the PostgreSQL JDBC Driver. Either double-click the JAR file or execute the jar file from the command-line.
java -jar cdata.jdbc.postgresql.jar
Fill in the connection properties and copy the connection string to the clipboard.
Below is a typical connection string:
jdbc:postgresql:User=postgres;Password=admin;Database=postgres;Server=127.0.0.1;Port=5432;

Query PostgreSQL Data

You can now query information from the tables exposed by the connection: Right-click a Table and then click Edit Table. The data is available on the Data tab. Mac os x transformation pack for xp.

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 connected if you run sdm status at 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
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
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
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