Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat Data Modeler

Apply Navicat Version No.: Windows & macOS version 1.x or above, Linux version 3 or above

 

You can import the data source using Import from ODBC feature. The following instruction guides you through the process of creating a new ODBC connection.

 

Windows

Setting Up an ODBC Data Source Connection

1. On the Control Panel, select Administrative Tools.
2. Select Data Sources (ODBC).
3. Select User DSN tab.
4. Click Add.
5. Select the correct ODBC driver you wish and click Finish.
6. Enter the required information.
7. Select OK to see your ODBC Driver in the list.

Connecting to ODBC data source in Navicat Data Modeler

1. Choose Tools -> Import from Database.
2. Choose Manage Connection -> New Connection -> ODBC.
3. Enter the connection information.
4. Follow the remaining steps to import tables.

 

macOS

Setting Up an ODBC Data Source Connection

1. To setup the connection of the data source, you need to install the corresponding driver.
2. Then, setup the DSN (Data Source Name) using the ODBC Administrator.

[Version 2 or below] Connecting to ODBC data source in Navicat Data Modeler

1. Choose File -> Import from Database or New from Database.
2. Choose + button -> ODBC.
3. Enter the connection information.
4. Follow the remaining steps to import tables.

[Version 3 or above] Connecting to ODBC data source in Navicat Data Modeler

1. Choose File -> Import from Database or New from Database.
2. Click Manage Connection.
3. Choose + button -> ODBC.
4. Enter the connection information.
5. Follow the remaining steps to import tables.

 

Linux

Setting Up an ODBC Data Source Connection

1. To setup the connection of the data source, you need to install the corresponding driver.
2. Then, add the DSN (Data Source Name) to the odbc.ini configuration file, e.g. /etc/odbc.ini.

Connecting to ODBC data source in Navicat Data Modeler

1. Choose Tools -> Import from Database.
2. Choose Manage Connection -> New Connection -> ODBC.
3. Enter the connection information.
4. Follow the remaining steps to import tables.