Using the PowerDesigner design table and importing Oracle databases

1, in the Powerdesinger design table
(1) After downloading Powerdesinger, right key new-->physical data model default name is: Physicaldiagram_1, right key new-->table, start table design
(2) Configuring an ODBC data source
Configure the ODBC data source in your computer's control Panel \ System and security \ Management Tools (my W7 system).
After selecting the database drive and connection pool, click Add to generate a. dsn file
(3) Configure the data source, in the Powerdesinger database-->connect. , select the file you just generated, and fill in the username and password, point Connect, test the connection database
(4) After the connection is normal, start to import the datasheet

2, import the table to the database
(1) in Powerdesinger, Database-->generate Database ...
Select the table to import, and whether to generate script files, if you do not generate a script file, choose Odbcgeneration, however, if directly to the database to import, generally not very easy to succeed, I guide the time, reported a lot of error, then checked a bit, Because of the SQL statement table name generated by PowerDesigner, the field names are automatically added with double quotes, so there is a problem importing. But it's said that this problem can be solved by capitalizing all the letters in your form, I haven't tried it, we can try it.
(2) I am the exported. SQL script file, and then convert all the double quotes to spaces
(3) Access to Oracle server, how to connect, here is not said, put this. sql file in the $oracle_home directory, typing at the command line
sql>@ file name. sql
It's OK.