Due to MySQL's interpretation of SCHEMA differing from the common SQL understanding (as seen in IRIS/SQL Server/Oracle), our automated Linked Table Wizard may encounter errors when attempting to retrieve metadata information to build the Linked Table.
(This also applies to Linked Procedures and Views)
When attempting to create a Linked Table through the Wizard, you will encounter an error that looks something like this:
ERROR #5535: SQL Gateway catalog table error in 'SQLPrimaryKeys'.