Connectors for Databases

Find here all information about connectors for databases.

For all databases, the related database driver must be installed first.

Amazon Athena DB

Amazon Athena DB

Amazon Athena DB is a query service in that companies are able to run SQL queries against their data as though it resides in a local data center.

Prerequisites

• Preparing Amazon Athena DB - Set up your Amazon Athena database accordingly.
• Uploading the Database Driver - Set up the database driver in the 'Admin' tab.

Configuring Amazon Athena as a Connection

To configure Amazon Athena DB as a connector:

1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

2. Select "Amazon Athena DB" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

3. Enter the connection string from the database driver.

4. Choose "Provide credentials", enter the username and password from the connection string and confirm with "Next". The 'Save Connection' tab opens.

5. If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.

6. Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring the Athena DB connection is finished.

Amazon Redshift

Amazon Redshift

INFO

In order to use this connector, you must install the proper database driver.

Configuring Amazon Redshift as a Connection

To configure an Amazon Redshift connection:

1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

2. Select "Amazon Reshift" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

3. Fill in the "Connection String" field with the connection to your Oracle database.

4. Select whether credentials should be provided or asked for. Add the required user name and password.

5. Indicate whether the connection should be used for import, export, or both.

6. Select the authentication mode and fill in the needed information below.

7. Click "Next".

8. If required, add a description and click "Save".

Azure Cosmos DB

Azure Cosmos DB

INFO

Azure Cosmos DB is a fully managed NoSQL database service.

Prerequisites

• **Preparing Azure Cosmos DB ** - Set up your Cosmos DB instance in your Cosmos DB endpoint.
• Uploading the Database Driver - Set up the database driver in the 'Admin' tab.

Configuring Azure Cosmos DB as a Connection

To configure Azure Cosmos DB as a connector:

1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

2. Select "AzureCosmos" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

3. Enter the connection string from the database driver.
   INFO: Find your account key on your Azure Cosmos DB instance under 'settings/keys: SECONDARY KEY'.

4. Choose "Provide credentials", enter the username and password from the connection string and confirm with "Next". The 'Save Connection' tab opens.

5. If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.

6. Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring Azure Cosmos DB as a JDBC connection is finished.

Azure Databricks

Azure Databricks

INFO

Azure Databricks is an Apache Spark based analytics service with an interactive workspace that enables collaboration between data scientists, data engineers, and business analysts.

Prerequisites

• Preparing Azure Databricks - Set up your cluster in the Databricks workspace on https://portal.azure.com.
• Uploading the Database Driver - Set up the database driver in the 'Admin' tab.

Configuring Azure Databricks as a Connection

To configure Azure Databricks as a connector:

1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

2. Select "Databricks" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

3. Enter the connection string from the database driver.
   INFO: End the connection string with ';UseNativeQuery=1'.
   INFO: Note that the pattern must contain the expression 'token' as the 'UID' parameter and the '\<personal-access-token>' as the 'PWD' parameter that you created both in Azure Databricks before.

4. Choose "Provide credentials", enter the username and password from the connection string and confirm with "Next". The 'Save Connection' tab opens.

5. If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.

6. Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring Azure Databricks as a JDBC connection is finished.

Azure Synapse

Azure Synapse

Prerequisites

• Preparing Azure Synapse - Set up your Azure Synapse database accordingly.
• Uploading the Database Driver - Set up the database driver in the 'Admin' tab.

Configuring Azure Synapse as a Connection

To configure Azure Synapse as a connector:

1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

2. Select "AzureSynapse" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

3. Enter the connection string from the database driver.

4. Choose "Provide credentials", enter the username and password from the connection string and confirm with "Next". The 'Save Connection' tab opens.

5. If needed, enter a description and confirm with "Next". The 'Save Connection' dialog opens.

6. Select the folder to save the connection, enter a name in "Save as" and confirm with "Save". The connection is saved. Configuring the Athena DB connection is finished.

DB2

DB2

Prerequisites

• Uploading the Database Driver - Make sure you have the database driver installed in the 'Admin' tab.

• Configuring DB2 as a Connection - and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

• Select "DB2" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

• Enter the DB2 "Connection String" and authentication credentials.

• Select if the connection to be used for import, export, or both.

• If required, add a description and click "Save".

Greenplum

Greenplum

Prerequisites

• Uploading the Database Driver - Make sure you have the database driver installed in the 'Admin' tab.

Configuring Greenplum as a Connection

To configure a Greenplum connection:

1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

2. Select "PostgreSQL82/Greenplum" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

3. Fill in the "Connection String" field with the connection to your Oracle database.

4. Indicate whether the connection should be used for import, export, or both.

5. Select whether credentials should be provided or asked for. Add the required user name and password.

6. Click "Next".

7. If required, add a description and click "Save".

MSSQL

MSSQL

Prerequisites

• Uploading the Database Driver - Make sure you have the database driver installed in the 'Admin' tab.

Configuring MSSQL as a Connection

To configure a MSSQL connection:

1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

2. Select "MSSQL" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

3. Fill in the "Connection String" field with the connection to your Oracle database.

4. Indicate whether the connection should be used for import, export, or both.

5. Select whether credentials should be provided or asked for. Add the required user name and password.

6. Click "Next".

7. If required, add a description and click "Save".

Netezza

Netezza

Prerequisites

• Uploading the Database Driver - Make sure you have the database driver installed in the 'Admin' tab.

Configuring Netezza as a Connection

To configure a Netezza connection:

1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

2. Select "Netezza" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

3. Fill in the "Connection String" field with the connection to your Oracle database.

4. Indicate whether the connection should be used for import, export, or both.

5. Select whether credentials should be provided or asked for. Add the required user name and password.

6. Click "Next".

7. If required, add a description and click "Save".

Orcale

Orcale

Prerequisites

• Uploading the Database Driver - Make sure you have the database driver installed in the 'Admin' tab.

Configuring Orcale as a Connection

To configure a Orcale connection:

1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

2. Select "Orcale" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

3. Fill in the "Connection String" field with the connection to your Oracle database.

4. Indicate whether the connection should be used for import, export, or both.

5. Select whether credentials should be provided or asked for. Add the required user name and password.

6. Click "Next".

7. If required, add a description and click "Save".

PostgreSQL

PostgreSQL

Prerequisites

• Uploading the Database Driver - Make sure you have the database driver installed in the 'Admin' tab.

Configuring PostgreSQL as a Connection

To configure a PostgreSQL connection:

1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

2. Select "PostgreSQL" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

3. Fill in the "Connection String" field with the connection to your Oracle database.

4. Indicate whether the connection should be used for import, export, or both.

5. Select whether credentials should be provided or asked for. Add the required user name and password.

6. Click "Next".

7. If required, add a description and click "Save".

Sybase IQ

Sybase IQ

Prerequisites

• Uploading the Database Driver - Make sure you have the database driver installed in the 'Admin' tab.

Configuring Sybase IQ as a Connection

To configure a Sybase IQ connection:

1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

2. Select "Sybase IQ" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

3. Fill in the "Connection String" field with the connection to your Oracle database.

4. Indicate whether the connection should be used for import, export, or both.

5. Select whether credentials should be provided or asked for. Add the required user name and password.

6. Click "Next".

7. If required, add a description and click "Save".

Teradata Aster

Teradata Aster

Prerequisites

• Uploading the Database Driver - Make sure you have the database driver installed in the 'Admin' tab.

Configuring Teradata Aster as a Connection

To configure a Teradata Aster connection:

1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

2. Select "Teradata Aster" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

3. Fill in the "Connection String" field with the connection to your Oracle database.

4. Indicate whether the connection should be used for import, export, or both.

5. Select whether credentials should be provided or asked for. Add the required user name and password.

6. Click "Next".

7. If required, add a description and click "Save".

Vertica 5.1+

Vertica 5.1+

Prerequisites

• Uploading the Database Driver - Make sure you have the database driver installed in the 'Admin' tab.

Configuring Vertica 5.1+ as a Connection

To configure a Vertica 5.1+ connection:

1. Select "+" and then select "Connection" or right-click on a folder in the File Browser and select ""Create New" and then ""Connection". A 'New Connection' tab opens.

2. Select "Vertica 5.1+" from the drop-down in section 'Type' and confirm with "Next". The section 'Connection Details' opens.

3. Fill in the "Connection String" field with the connection to your Oracle database.

4. Indicate whether the connection should be used for import, export, or both.

5. Select whether credentials should be provided or asked for. Add the required user name and password.

6. Click "Next".

7. If required, add a description and click "Save".