The first step, Control Panel---Management tool---ODBC Data source---User DNS---Click Add, fill in the configuration and save according to the connection data information (one of which is "change the default database to", click and modify 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 added.
Fourth step, click "Database", "Reverse Engineer database ..." (Update Model from Database) (shortcut Ctrl + R) "
Fifth step, according to their own needs to tick the appropriate 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.
PowerDesigner Connecting SQL Server databases