https://community.sap.com/t5/technology-q-a/powerdesigner-reverse-engineer-physical-model-from-azure-sql-odbc-error/qaa-p/12302831#M4611201 Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with <A href="https://community.sap.com/resources/questions-and-answers" target="test_blank">https://community.sap.com/resources/questions-and-answers</A> (if you haven't already), as it provides tips for preparing questions that draw responses from our members.<BR />Should you wish, you can revise your question by selecting Actions, then Edit.<BR />Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: <A href="https://www.youtube.com/watch?v=F5JdUbyjfMA&amp;list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS" target="test_blank">https://www.youtube.com/watch?v=F5JdUbyjfMA&amp;list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS</A>. By personalizing your profile with a photo of you, you encourage readers to respond. Sun, 24 Jan 2021 07:20:35 GMT moshenaveh 2021-01-24T07:20:35Z https://community.sap.com/t5/technology-q-a/powerdesigner-reverse-engineer-physical-model-from-azure-sql-odbc-error/qaq-p/12302830 <P>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...</P> <P>When trying to connect, I get an error message saying - </P> <P>Unable to list the triggers.</P> <P>[Microsoft][ODBC Driver 17 for SQL Server][SQL Server] Catalog view</P> <P>'trigger_events' is not supported in this version</P> <P>SQLSTATE=37000</P> <P>Now, after clicking okay, I can see the tables and when I choose them for reverse engineering - got the following:</P> <P>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... </P> <P> 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 </P> <P>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 </P> <P>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 </P> <P> 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.</P> <P> 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 </P> <P>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 </P> <P> 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 </P> <P>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 </P> <P>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 </P> <P> 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 </P> <P>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 </P> <P>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 </P> <P> 4 object(s) have been reverse engineered. Reverse engineering references... 0 object(s) have been reverse engineered.</P> Sun, 24 Jan 2021 07:18:49 GMT https://community.sap.com/t5/technology-q-a/powerdesigner-reverse-engineer-physical-model-from-azure-sql-odbc-error/qaq-p/12302830 Former Member 2021-01-24T07:18:49Z https://community.sap.com/t5/technology-q-a/powerdesigner-reverse-engineer-physical-model-from-azure-sql-odbc-error/qaa-p/12302831#M4611201 Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with <A href="https://community.sap.com/resources/questions-and-answers" target="test_blank">https://community.sap.com/resources/questions-and-answers</A> (if you haven't already), as it provides tips for preparing questions that draw responses from our members.<BR />Should you wish, you can revise your question by selecting Actions, then Edit.<BR />Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: <A href="https://www.youtube.com/watch?v=F5JdUbyjfMA&amp;list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS" target="test_blank">https://www.youtube.com/watch?v=F5JdUbyjfMA&amp;list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS</A>. By personalizing your profile with a photo of you, you encourage readers to respond. Sun, 24 Jan 2021 07:20:35 GMT https://community.sap.com/t5/technology-q-a/powerdesigner-reverse-engineer-physical-model-from-azure-sql-odbc-error/qaa-p/12302831#M4611201 moshenaveh 2021-01-24T07:20:35Z