Navicat Tips: How to create model from an existing database using Navicat Data Modeler?

Conditions:

1.       Import tables through ODBC (through MariaDB in Linux version)
2.       Use the “Microsoft Access Driver” to add a new data source

Windows:

Select “Tools” in the menu bar > Choose “Import from Database…” > Click “Manage Connection” > (Bottom left corner) “Manage Connection” > Select “ODBC” in “New Connection” from the dropdown list

Go to “Administrative Tools” in Control Panel > Select Database Sources

(select 32-bit ODBC Database Sources if using a 32-bit Navicat Data Modeler; select 64-bit ODBC Database Sources while using a 64-bit Navicat Data Modeler)

“User DSN” tab > Click “Add…” > Select “Microsoft Access Driver (*mdb) > Input Data Source Name in the setup window > Click “Select…” > Select database file > Click “OK” > Close the window when finish the settings 

Click “Manage Connection” > “New Connection” > Select “ODBC” > Set up the connection by inputting Connection Name > Select Data Source > Click “OK”

(You can also import connections that established in other Navicat Software to Navicat Data Modeler.)

Select the connection > Click “Manage Connection” > Choose “Import Connections from Navicat…” > Select connection(s) to import > Click “OK” 

Choose objects > Click “Start” to import 

Mac:

Select “import from Database” from “File” menu > Click “New Connection” > Choose “ODBC” 

Set up the connection > Click “OK”

(You can also import connections that established in other Navicat Software to Navicat Data Modeler.)

Click “Import Connection” > Select connection(s) to import > Click “OK” 

Select the connection > Click “Continue” > Choose object(s) to import > Click “Continue” > Click “Import” to start 

Linux:

Select “Tools” from menu bar > Choose “Import from Database…” > Click “Manage Connection” > Click “Manage Connection” button at the bottom left corner > Click “New Connection > Select “ODBC” > Set up the connection > Click “OK” 

(You can also import connections that established in other Navicat Software to Navicat Data Modeler.)

Click “Manage Connection” > Choose “Import Connections from Navicat…” > Select connection(s) to import > Click “OK” 

Select the connection > Choose object(s) to import > Click “start” to import 

Check out our other tutorials at bit.ly/navicatyoutube.