Why are objects not being imported when a Reverse Engineer is performed on a MySQL Database?
When performing a Reverse Engineer from a MySQL 5.x database the connection is made successfully, but when the model is created there are no objects (tables, columns, relationships etc.).
If the SQL Trace is enabled (https://support.erwin.com/hc/en-us/articles/360020985611-How-to-Enable-SQL-Trace-Logging-for-Reverse-Engineer-) the following result may be seen:
--This file is published using to trace the executed SQL
--ERwin RE SQL Trace for MySQL 5.x started on 2020-07-31 13:48:02
--[2020-07-31 13:48:02] Retrieve Tables for owner All
--[2020-07-31 13:48:03] Retrieve rows for query
--[2020-07-31 13:48:03] Return from Retrieve - 0 Rows
--ERwin RE SQL Trace for MySQL 5.x ended on 2020-07-31 13:48:03
1. First ensure that an ODBC Data Source Driver is created and configured correctly with the following KB Article: https://support.erwin.com/hc/en-us/articles/360032130251-How-to-set-up-an-ODBC-Data-Source-and-Reverse-Engineer-a-database-using-it-
2. Next, ensure that the User credentials used in the ODBC Data Source have proper privileges to Read the objects from the Database.
3. If the above has been met, a "Database" (MySQL Schema) will need to be specified from the drop-down, similar to what is found in the following screenshot:
4. After specifying the Database name and clicking the "Test" button, confirm that the connection is successful. The Reverse Engineer can then be performed once again with the ODBC Data Source created in the steps above.