Apply OS: Windows, macOS, Linux

Apply Navicat Product: Navicat Data Modeler

Apply Navicat Version No.: 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.

 

Setting Up an ODBC Data Source Connection

Windows

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.

macOS

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.

Linux

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.

 

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

Windows & Linux

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

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.

 

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

1. In the Workspace window, choose Tools -> Manage Connections.
2. Click New.
3. Click ODBC.
4. Enter the connection information.
5. Follow the remaining steps to import tables.