Importing metadata with ODBC drivers

Applies to: Dataedo 10.x (current) versions, Article available also for: 9.x, 8.x, 7.x

Dataedo supports generic ODBC connection. You can import basic metadata from any source that has an ODBC connector. Please note that scope and quality of extracted metadata depends on the specific ODBC provider, and that often leaves much to be desired.

Supported metadata

  • Tables
  • Columns
  • Data types
  • Nullability
  • Views (imported as tables)

Data Profiling

Data Profiling is not supported for ODBC connector.

Limitations

This metadata is not imported with ODBC connector:

  • Stored procedures
  • User defined functions
  • View scripts
  • Primary key
  • Foreign keys / Relationships
  • Unique constraints

Scope of metadata depends on specific connector.

Prerequisites

ODBC driver installed and configured with the connection to the database on the system that will perform import.

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

Connecting 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 metadata

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.

ODBC connnection guides

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