Versions Compared

Old Version 1

changes.mady.by.user Juliane Wetzel

Saved on

compared with

New Version 2

changes.mady.by.user Juliane Wetzel

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Info
titleINFO

Find here all information about uploading a database driver. You can add a new database driver or edit an existing database driver as well as delete one.

Info
titleINFO

Note that for the HSQL (file) database driver which is pre-installed, in the list of available database drivers, the 'File' column might be empty. The same applies for running Datameer X in MySQL: The 'File' column for the MySQL database driver may also be empty.

Datameer X supports the following database drivers: 

Table of Contents

Info
titleINFO

Untested 3rd party JDBC drivers haven't been qualified by Datameer. Generally, ANSI SQL compliant JDBC connections (such as SharePoint or SQL Azure) should work by loading the corresponding JDBC driver. Drivers such as Apache Phoenix that don't support SCHEMA, INSERT, and UPDATE, but do support UPSERT, don't work. At this time, Impala JDBC isn't working.

Amazon Athena DB

Info
titleINFO

Receive the Amazon Athena database driver, e.g. from https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html.

To add the Amazon Athena database driver:

  1. Open the "Admin" tab and select "Database Drivers". The page 'Database Drivers' opens. 
    Image Removed 
  2. Click on "New". The page 'Add/ Edit Database Driver' opens. 
    Image Removed 
  3. Enter the database name. 
    Image Removed 
  4. Click on "Upload" and upload the JAR file.  
    Image Removed 
  5. Select "AWS Athena" from the drop-down. 
    Image Removed 
  6. Enter the driver class. 
    Image Removed 
  7. Enter the connection pattern and confirm with "Save". The configuration is saved and displayed in the database driver list. 
    Image Removed

...

  • Select the correct driver. 
  • Change your working directory to the download folder.

  • Extract the Zip file.

  • In Datameer X go to the Admin tab and then to the Database Drivers tab.
    Click New to add a new database driver.
  • Enter the following information:
    • Name: Redshift
    • Jar File: (your driver)
    • Database Driver Template: Amazon Redshift
    • Driver Class:  
      • Redshift: com.amazon.redshift.jdbc41.Driver (4.1 recommended)
      • PostgreSQL: org.postgresql.Driver
    • Connection Pattern: 
      • Redshift: jbdc:redshift://%host%:%port%/%dbName% 
      • PostgreSQL: jbdc:postgresql://%host%:%port%/%dbName%
      Image Removed
  • Redshift should now appear as an available database driver.

...

Info
titleINFO

Find here all information about uploading a database driver. You can add a new database driver or edit an existing database driver as well as delete one.

Info
titleINFO

Note that for the HSQL (file) database driver which is pre-installed, in the list of available database drivers, the 'File' column might be empty. The same applies for running Datameer X in MySQL: The 'File' column for the MySQL database driver may also be empty.

Datameer X supports the following database drivers: 

Table of Contents

Info
titleINFO

Untested 3rd party JDBC drivers haven't been qualified by Datameer. Generally, ANSI SQL compliant JDBC connections (such as SharePoint or SQL Azure) should work by loading the corresponding JDBC driver. Drivers such as Apache Phoenix that don't support SCHEMA, INSERT, and UPDATE, but do support UPSERT, don't work. At this time, Impala JDBC isn't working.

Amazon Athena DB

Info
titleINFO

Receive the Amazon Athena database driver, e.g. from https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html.

To add the Amazon Athena database driver:

  1. Open the "Admin" tab and select "Database Drivers". The page 'Database Drivers' opens. 
    Image Added 
  2. Click on "New". The page 'Add/ Edit Database Driver' opens. 
    Image Added 
  3. Enter the database name. 
    Image Added 
  4. Click on "Upload" and upload the JAR file.  
    Image Added 
  5. Select "AWS Athena" from the drop-down. 
    Image Added 
  6. Enter the driver class. 
    Image Added 
  7. Enter the connection pattern and confirm with "Save". The configuration is saved and displayed in the database driver list. 
    Image Added

Anchor
redshift
redshift
Amazon Redshift

  • Select the correct driver. 
  • Change your working directory to the download folder.

  • Extract the Zip file.

  • In Datameer X go to the Admin tab and then to the Database Drivers tab.
    Click New to add a new database driver.
  • Enter the following information:
    • Name: Redshift
    • Jar File: (your driver)
    • Database Driver Template: Amazon Redshift
    • Driver Class:  
      • Redshift: com.amazon.redshift.jdbc41.Driver (4.1 recommended)
      • PostgreSQL: org.postgresql.Driver
    • Connection Pattern: 
      • Redshift: jbdc:redshift://%host%:%port%/%dbName% 
      • PostgreSQL: jbdc:postgresql://%host%:%port%/%dbName%
      Image Added
  • Redshift should now appear as an available database driver.

Anchor
DM_Admin_AzureCosmosDatabaseDriver
DM_Admin_AzureCosmosDatabaseDriver
Azure Cosmos DB  

Info
titleINFO

Receive the Azure Cosmos database driver from https://www.cdata.com/drivers/cosmosdb/jdbc/.

To add the Azure Cosmos database driver:

  1. Open the "Admin" tab and select "Database Drivers". The page 'Database Drivers' opens. 
    Image Added 
  2. Click on "New". The page 'Add/ Edit Database Driver' opens. 
    Image Added 
  3. Enter the database name. 
    Image Added 
  4. Click on "Upload" and upload the JAR file.  
    Image Added 
  5. Select "Azure Cosmos" from the drop-down. 
    Image Added 
  6. Enter the driver class. 
    Image Added 
  7. Enter the connection pattern and confirm with "Save". The configuration is saved and displayed in the database driver list. 
    INFO: Find your account key on your Azure Cosmos DB instance under 'settings/keys: SECONDARY KEY'. 
    Image Added


Anchor
DM_Admin_AzureDatabricksDatabaseDriver
DM_Admin_AzureDatabricksDatabaseDriver
Azure Databricks Database Driver (JDBC)

Info
titleINFO

Receive the Azure Cosmos Databricks database driver from https://www.cdatadatabricks.com/drivers/cosmosdbde/jdbcspark/odbc-driver-download.

To add the Azure Cosmos Databricks database driver:

  1. Open the "Admin" tab and select "Database Drivers". The page 'Database Drivers' opens. 
    Image RemovedImage Added 
  2. Click on "New". The page 'Add/ Edit Database Driver' opens. 
    Image Modified 
  3. Enter the database name. 
    Image RemovedImage Added 
  4. Click on "Upload" and upload the JAR file.  
    INFO: Get the file from https://databricks.com/de/spak/odbc-driver-download.  
    Image Modified 
  5. Select "Azure CosmosDatabricks JDBC V2.6.x" from the drop-down. 
    Image RemovedImage Added 
  6. Enter the driver class. 
    Image RemovedImage Added 
  7. Enter the connection pattern and confirm with "Save". The configuration is saved and displayed in the database driver list. 
    INFO: Find your account key on your Azure Cosmos DB instance under 'settings/keys: SECONDARY KEY'. 
    Image Removed    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 in Azure Databricks before.
    Image Added 

Anchor
DM_Admin_

...

AzureSynapseDatabaseDriver
DM_Admin_

...

AzureSynapseDatabaseDriver
Azure

...

Synapse Database Driver 

Info
titleINFO

Receive the Azure Databricks database driver from https://databricks.com/de/spark/odbc-driver-downloadAzure Synapse database driver from e.g. CData or the Microsoft Download Center.

To add the Azure Databricks Synapse database driver:

  1. Open the "Admin" tab and select "Database Drivers". The page 'Database Drivers' opens. 
    Image RemovedImage Added 
  2. Click on "New". The page 'Add/ Edit Database Driver' opens. 
    Image RemovedImage Added 
  3. Enter the database name, e.g. 'Synapse_Driver' . 
    Image RemovedImage Added 
  4. Click on "Upload" and upload the JAR file. 
    INFO: Get the file from https://databricks.com/de/spak/odbc-driver-download.  
    Image Removedfile. 
    Image Added 
  5. Select "Databricks JDBC V2.6.xMicrosoft Azure Synapse" from the drop-down. 
    Image RemovedImage Added 
  6. Enter View the driver class. 
    Image RemovedImage Added 
  7. Enter View the connection pattern and confirm with "Save". The configuration is saved and displayed in the database driver list. 
    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 in Azure Databricks before.
    Image Removed     Image Added

Anchor
db2
db2
DB2

...

    1. Open the "Admin" tab and select "Database Drivers". The page 'Database Drivers' opens. 
       
    2. Click on "New". The page 'Add/ Edit Database Driver' opens. 
      Image Modified 
    3. Enter the database name. 
      Image Modified 
    4. Click on "Upload" and upload the JAR file. 
      Image Modified 
    5. Select "Netezza" or "Netezza V7.0.2" from the drop-down. 
      Image Modified 
    6. Enter the driver class. 
      Image Modified 
    7. Enter the connection pattern and confirm with "Save". The configuration is saved and displayed in the database driver list. 
      Image Modified

Anchor
oracle
oracle
Oracle

...