Mysql – PowerDesigner CDM, PDM and MySQL

MySQLpowerdesigner

I am currently trying to pickup on PowerDesigner and there are two things I wish to ask:

  1. Is there any difference between generating Physical Data Model(PDM) from Conceptual Data Model and directly creating the PDM?
  2. Is there any way to generate database from PowerDesigner to MySQL. I tried but cannot create ODBC for MySQL as there are no option available when trying to create data source?

Best Answer

  1. PowerDesigner tries to keep track of the links between CDM and PDM objects. If you change (denormalize, or rename) something in the PDM, change something in CDM, and generate again, it will use this linking information to update your PDM properly, rather than just generating a default PDM from the CDM.

  2. Which version of PowerDesigner are you using? You should be able to create a PDM targetting a MySQL DBMS; outside PowerDesigner create an ODBC data source after installing Connector/ODBC; connect to your data source with Database > Connect; and generate your model inside your database with Database > Generate Database.

  3. Don't know...