PowerDesigner common settin

1. Using JDBC to connect to Oracle to reverse generate database PDM

Using ODBC to connect to Oracle database can learn from this brother's blog: http://www.cnblogs.com/clivehua/articles/4593211.html

Personally, I feel that it is relatively simple to connect to Oracle by JDBC.

[Database]-> [Configure Connections]

A few points to note:

1. If you cannot initialize JVM, the number of digits of your JDK version and PowerDesigner is not the same, please adjust.

2. JDBC driver jar: select the driver Jar that connects to the database in your project, and add the location of the jar to the system variable classPath.

3. Connection profile: the name of the connection is whatever you want.

4. Description: the description of the connection, which can be left empty.

5. Fill in the UserName/JDBC driver class/connecton URl correctly and click on the test link.

Back to the top.

two。 Desynchronization of tables Name and Code in logical model

[Tool]-> [General Options]-> [Dialog]-> [Operating modes]-> [Name to Code mirroring] cancel √

Back to the top.

3. In the logical model, Name is automatically populated with comments when comments are empty.

Back to the top.

4. Generate database SQL to remove table names and field double quotation marks

[Database]-> [Edit current database]-> [Script]-> [Sql]-> whether [Format] uses case to specify identifiers