The first step, Control Panel---Management tool---ODBC Data source---User DNS---Click Join, fill in the configuration and save according to the information of the connection data (one of which is "change the default database to", click and change to need to configure the database)
Step two, open powerdesigner, build a physical data model
Third step, after the new success, click on "Database", "Connect", connect to the data source just joined.
Fourth step, click "Database", "Reverse Engineer database ..." (Update Model from Database) (shortcut Ctrl + R) "
Fifth step, according to their own need to check the corresponding operation can be
Description
1. If "PowerDesigner unable to list the users" error appears:
Reason: The current database management system needs to be changed.
WORKAROUND: Select database-and change-current DBMS in the menu bar, and select your DB type for the DBMS to determine it.
PowerDesigner Connecting SQL Server databases