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

Apply OS: Windows, Mac

Apply Navicat Product: Navicat Data Modeler

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

 

Mac

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.
Have more questions? Submit Ticket.
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.