Use this procedure to configure the Oracle ODP.NET connection.
If you select
Oracle ODP.NET in the
Provider list, the Oracle Data Provider for .NET (ODP.NET) Connection Properties dialog box displays.
To configure the Oracle ODP.NET connection:
-
On the General tab, perform the appropriate set of actions.
- In the
Data Source field, enter the server name.
- In the
User name field and
Password field, enter the user ID and password to use for authentication when you log into the connection.
- Select the
Save my password option to save and encrypt your password so that you do not need to enter the password each time you open the connection.
-
On the Advanced tab, set the additional initialization properties for your data.
-
Click
Test Connection to confirm that the connection to your database connection works.
The PPM Datasource Management Tool displays a message box that confirms the database connection.
-
Click
OK.
If the PPM Datasource Management Tool is unable to establish a connection, return to the General tab and check your settings, or consult your database administrator.