Skip to Content
0
Jan 24, 2021 at 07:18 AM

PowerDesigner reverse Engineer Physical Model from Azure SQL ODBC - Error

220 Views Last edit Jan 25, 2021 at 02:10 PM 2 rev

Hi, I'm looking to reverse engineer a Physial Data Model from an Azure SQL Database via ODBC. I'm using odbc 17 for SQL Server. Tables get regenerated but no objects are present in terms of columns / indexes etc...

When trying to connect, I get an error message saying -

Unable to list the triggers.

[Microsoft][ODBC Driver 17 for SQL Server][SQL Server] Catalog view

'trigger_events' is not supported in this version

SQLSTATE=37000

Now, after clicking okay, I can see the tables and when I choose them for reverse engineering - got the following:

Reverse Engineering Reverse engineers the database ... Unable to list the rules. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'syscomments' is not supported in this version. SQLSTATE = 37000 Reverse engineering tables...

Table DAY_MTD Unable to list the columns. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'xml_schema_collections' is not supported in this version. SQLSTATE = 37000

Unable to list the indexes. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'xml_indexes' is not supported in this version. SQLSTATE = 37000

Unable to list the alternate keys. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'sysindexkeys' is not supported in this version. SQLSTATE = 37000

Table DAY_OF_WEEK Unable to list the columns. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'xml_schema_collections' is not supported in this version.

SQLSTATE = 37000 Unable to list the indexes. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'xml_indexes' is not supported in this version. SQLSTATE = 37000

Unable to list the alternate keys. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'sysindexkeys' is not supported in this version. SQLSTATE = 37000

Table DAY_YTD Unable to list the columns. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'xml_schema_collections' is not supported in this version. SQLSTATE = 37000

Unable to list the indexes. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'xml_indexes' is not supported in this version. SQLSTATE = 37000

Unable to list the alternate keys. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'sysindexkeys' is not supported in this version. SQLSTATE = 37000

Table GEO_SOURCE Unable to list the columns. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'xml_schema_collections' is not supported in this version. SQLSTATE = 37000

Unable to list the indexes. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'xml_indexes' is not supported in this version. SQLSTATE = 37000

Unable to list the alternate keys. [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Catalog view 'sysindexkeys' is not supported in this version. SQLSTATE = 37000

4 object(s) have been reverse engineered. Reverse engineering references... 0 object(s) have been reverse engineered.