cancel
Showing results for 
Search instead for 
Did you mean: 

PowerDesigner reverse Engineer Physical Model from Azure SQL ODBC - Error

01-24-2021 8:18 AM
934 views 1 comments
0 Likes
SAP Managed Tags
Subscribe

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.

0 Likes

Accepted Solutions (0)

Answers (0)