You can translate the question and the replies:

Retrodocumentation fo denodo bv/table with power designer through ODBC does not work fully

Hello we managed to connected power designer to denodo with odbc 3.0 following documentation provided. It does expose the different base views and tables but when we ask for retro document it only shows the tables with no field and no relation between tables are shown. Did anyone succeed in performing a full retrodocumentation with power design with denodo. Is there a something we missed. Help will be appreciated. Please not that retroducmentation did not work for any of our different db types (sybase, mssql, oracle)....
Connecting to remote databases power designer
Vincent Boucheron
13-10-2023 16:35:25 -0400
code

1 Answer

Hi, Please refer to the Knowledge Base article [How to Connect to Denodo from SAP PowerDesigner](https://community.denodo.com/kb/en/view/document/How%20to%20connect%20to%20Denodo%20from%20SAP%20PowerDesigner). Please review the section ‘Connecting to Denodo using ODBC’. You’ll need to: * Use the ‘Reverse Engineer’ feature under the File menu * Use the DSN created for the ODBC connection * Use the check boxes for Primary/Foreign keys, etc. Checking these options should give you more information about the data model, where fields came from originally, etc. Lastly, please refer to the DSN [Configuration for ODBC Connections to VDP](https://community.denodo.com/kb/en/view/document/DSN%20configuration%20for%20ODBC%20connections%20to%20VDP) Knowledge Base Article to verify that the DSN was set up correctly. Hope this helps!
Denodo Team
18-10-2023 12:57:58 -0400
code
You must sign in to add an answer. If you do not have an account, you can register here