Marcin Nagly
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.
Data Lineage
Data Lineage 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.
Select a driver and configure DSN.
Connecting 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.
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.