How to Setup Databases¶

In the Project Wizard, you have the option to configure Oracle Databases during the initial stage of your project setup. This section guides you through the process of configuring supported databases according to your requirements.

Button functionality overview¶

Figure: Project Wizard - Setup Oracle Databases pane

Name	Functionality
Add	Will open a new window where you can either add from existing or create new connections.
Remove	Selecting a database connection from the list and pressing button will remove connection from the project.
Edit	Selecting a database connection from the list and pressing button will give the opportunity to edit it.
Set As Main Database	Selecting a database connection from the list and pressing button will select connection as the primary of the project. Once a connection is set as the main database, it will appear in bold.
Reverse Engineering	Selecting a database connection from the list and pressing button will select connection to be used for Reverse Engineering (RE) in the project. Once a connection is set as the RE database, it will appear in italic. If an already selected RE connection is selected again and RE button is pressed, that will unselect that connection and leave no connection as RE connection.

General info¶

JDBC URL can always be found in tooltip.
At least one Database connection has to be set up to continue project wizard.

Detailed info¶

Add:¶

Add registered database connection(s) using the Add button, in the Oracle Databases pane.

Figure: Project Wizard - Oracle Databases Pane - Add Database Connections

Use this section to add database connections to the project by selecting any of the existing databases listed under Connections (already registered to Developer Studio), or create a new database connection.

Creating a New database connection:¶

You can register a new database connections to Developer Studio by using the New button, in the Add Database Connection pane.

Figure: Project Wizard - Oracle Databases Pane - Add Database Connections - Register New Database Connection to Developer Studio

Figure: Project Wizard - Oracle Databases Pane - Add Database Connections -Values entered in New Database Connection Dialog.

Fill out all the fields with appropriate values and press OK to proceed.
Filling out the Display Name field is optional. If left blank, the URL will serve as the default display name.
JDBC URL can always be found in tooltip.

Figure: Project Wizard - Oracle Databases Pane - Add Database Connections - Newly Created Database Added to the Available Connections

Adding Database Connections to the Project¶

You can add one or multiple databases to the project by selecting multiple lines in the Available Connections section.

Example: Selecting the last two connection and press OK, will add them to the current project.

Figure : Project Wizard - Add Database Connection - Adding Multiple Connections

Figure: Project Wizard - Oracle Databases - Multiple Databases added to the project.

Remove:¶

If you want to remove any database connections from the project, utilize the Remove option to remove unnecessary database connections.

Select any database connection from the Database Connections list and press the Remove button to remove the connection.

Edit:¶

You can edit any already existing database connection by using the Edit option.

Click the Edit button to access Edit Database Connection popup to edit the connection.

*

Figure: Project Wizard - Oracle Databases - Edit Database Connection popup

Set As Main Database:¶

Use this option to set one database connection as the main connection. Once a connection is set as the main database, database name will appear in bold on the Database Connections list.

Figure: Project Wizard - Oracle Databases - Setting up the available database connection as main for the project.

Reverse Engineering:¶

Selecting a database connection from the Database Connections list and pressing the Reverse Engineering button will mark the selected connection to be used for Reverse Engineering (RE) in the project.

Once a database connection is set as the RE database, it will appear in the Database Connections list in italic. If you pick a connection already marked for RE, clicking the Reverse Engineering button again will unselect it, leaving no connection designated for RE.

Figure: Project Wizard - Oracle Databases - Selecting one of the connections for Reverse Engineering

Figure: Project Wizard - Oracle Databases - Removing one of the connections from Reverse Engineering