Table of Contents:
Connecting to database with ODBC
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.
Select a driver and configure DSN.
Connect to database with ODBC
Create a new documentation by clicking Add documentation and choosing Database connection.
In the DBMS field, select Other (ODBC connection).
Select and choose the DSN you created and click connect.
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.
ODBC version: Simba 22.214.171.1244 64 bit
ODBC version: DataStax ODBC 2.5 64-bit
Apache Cassandra version: 3.11.3
ODBC version: 126.96.36.1995 64 bit
IBM Db2 for iSeries (Db2 for IBM i)
ODBC version: 11.01.2021.1452
SAP ASE (Sybase)
ODBC version: 1.4.8 64-bit
SAP ASE (Sybase) version: 16.0
ODBC version: 1.7.16 64-bit
Salesforce version: Professional Edition
ODBC version: 64 bit
SQLite version: 3.26.0
ODBC version: 16.20 64-bit
Teradata version: 16.20
ODBC version: 9.2.x 64-bit
Vertica version: 9.0.1-5