How can I import tables from other data sources in Data Modeler (e.g. Access)?

From Navicat Wiki
Jump to: navigation, search

Apply OS : Windows, Mac

Apply Version No. : Version 1.x or above


Windows

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

  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.


Mac

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

  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.

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.