PowerDesigner importing a data model from a SQL Server database

Source: Internet
Author: User
Tags creative commons attribution odbc connection powerdesigner

PowerDesigner import data from the database first step, open PowerDesigner, select "File" option in the menu, then select "Reverse Engineer" option in the pop-up drop-down list and select "Database" Options

The second step is to select the button to the right of the Using a data source option

The third step pops up the Connect to a Data Source dialog box, click Configure

Fourth step to create a new ODBC connection

Fifth step in the dialog box that pops up, select the "System Data source" option, and then click Next

Sixth step in the popup dialog box, select the driver, here is SQL Server, then click Next

Seventh step, click Finish, fill in the name description and connect the server name

Eighth Step Select authentication method and user, password

Nineth Step Client Configuration

Tenth step, click Next to start the import

Test Connection Results

Save after successful configuration

Connecting to a database

Data Table Import succeeded

Disclaimer: This blog attaches great importance to the protection of intellectual property rights, found that the information posted by this blog contains a violation of its copyright link content, please contact me, I will be the first time to do the corresponding processing, contact email [email protected].


Mark Fan (small idea) Source:http://cube.cnblogs.com
Note: This statement must be retained without the consent of the author, and the original text connected in the obvious position of the article page, otherwise the right to hold the legal responsibility. In case of doubt, you can contact the author via [email protected] , this article is licensed under the Creative Commons Attribution-NonCommercial use-share 2.5 China mainland license agreement in the same way

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.