Documentation

Table of Contents:


    Connecting to database with ODBC

    Marcin Nagly - Dataedo Team Marcin Nagly 2019-03-14 2019-05-16

    Available in beta from version 7.3.

    Configuring the ODBC Driver

    First, download and install ODBC Driver for your database.

    Then, create a User or System DSN (data source name). To do this, open Control Panel, access Administrative Tools, then open either ODBC Data Sources (64-bit) or ODBC Data Sources (32-bit).

    Click User or System DSN tab, then click add.

    Connection with ODBC

    Select a driver and configure DSN.

    Connection with ODBC

    Connect to database with ODBC

    Create a new documentation by clicking Add documentation and choosing Database connection.

    Connection with ODBC

    In the DBMS field, select Other (ODBC connection).

    Connection with ODBC

    Select and choose the DSN you created and click connect. Connection with ODBC

    Importing schema

    If connection is successful, Dataedo will show a list of objects from the database. You can choose which objects to import.

    Confirm the selection by clicking Next.

    You can now change the name of your documentation.

    Click Import to start the import, and when it ends, close the window with Finish button.

    Your database schema has been imported to new documentation in the repository.

    List of ODBC Drivers

    We have tested and successfully connected to and imported metadata from database with ODBC drivers listed below. It is highly likely it will work with other drivers as well.

    Access

    Supported schema elements and metadata

    ODBC configuration

    ODBC version: Microsoft Access Driver 64 bit

    Amazon Athena

    Supported schema elements and metadata

    Download Simba ODBC driver

    ODBC configuration

    ODBC version: Simba 1.0.3.1004 64 bit

    Apache Cassandra

    Supported schema elements and metadata

    Download DataStax ODBC driver

    ODBC configuration

    ODBC version: DataStax ODBC 2.5 64-bit

    Apache Cassandra version: 3.11.3

    Apache Hive

    Supported schema elements and metadata

    Download Hive ODBC driver

    ODBC configuration

    ODBC version: 2.6.1 (64 bit)

    Apache Impala

    Supported schema elements and metadata

    Download Impala ODBC driver

    ODBC configuration

    ODBC version: 2.6.4 (64 bit)

    Google BigQuery

    Supported schema elements and metadata

    Download ODBC driver

    ODBC configuration

    ODBC version: 2.1.20.1025 64 bit

    IBM Db2 for iSeries (Db2 for IBM i)

    Supported schema elements and metadata

    Download IBM Db2 ODBC driver

    ODBC configuration

    ODBC version: 11.01.2021.1452

    Microsoft Dynamics 365

    Supported schema elements and metadata

    Download ODBC driver

    ODBC configuration

    ODBC version: Devart for Dynamics CRM 1.6.11 64 bit Microsoft Dynamics 365 version: 9.1

    SAP ASE (Sybase)

    Supported schema elements and metadata

    Download Devart for ASE ODBC driver

    ODBC configuration

    ODBC version: 1.4.8 64-bit

    SAP ASE (Sybase) version: 16.0

    SAP Hana

    Supported schema elements and metadata

    The driver is installed as part of the SAP HANA client installation.

    Download HDBODBC driver

    ODBC configuration

    ODBC version: HDBODBC 2.3.106 64 bit

    SAP Hana version: 2.0 SPS03

    SAP IQ

    Supported schema elements and metadata

    The driver is installed as part of the SAP IQ client installation.

    Download ODBC driver

    ODBC configuration

    SAP IQ ODBC version: SYBASE IQ 17.00.09.1031 64 bit

    SAP IQ version: 16.1

    Salesforce

    Supported schema elements and metadata

    Download Devart for Salesforce ODBC driver

    ODBC configuration

    ODBC version: 1.7.16 64-bit

    Salesforce version: Professional Edition

    SQLite

    Supported schema elements and metadata

    Download SQLlite ODBC driver

    ODBC configuration

    ODBC version: 64 bit

    SQLite version: 3.26.0

    Teradata

    Supported schema elements and metadata

    Download Teradata ODBC driver

    ODBC configuration

    ODBC version: 16.20 64-bit

    Teradata version: 16.20

    Vertica

    Supported schema elements and metadata

    Download Vertica ODBC driver

    ODBC configuration

    ODBC version: 9.2.x 64-bit

    Vertica version: 9.0.1-5

    Found issue with this article? Comment below
    0
    There are no comments. Click here to write the first comment.