Use the Configure Connection dialog box to configure database connections and select the database you want to log into.
Available Databases
: Adds a new database configuration. Select the appropriate module heading (P6 Professional) before you click this icon.
: Deletes the selected database configuration.
P6 Professional: Lists all the database connections you have previously configured for P6 Professional.
Database Details
Database Connection
Database type: The type of database you want to connect to, either Oracle or Microsoft SQL Server.
Host Name/IP Address: The name or IP address of the database server hosting the P6 Professional database.
Database Name/Service Name: For SQL server databases, enter the database name. For Oracle databases, enter the name of the SID that stores the P6 Professional database tables.
Port: The database's port number. For Oracle databases, the default port number is 1521; for SQL Server databases, the default port number is 1433. However, your administrator may have configured a different port number.
SSL: This checkbox appears when configuring a connection for an Oracle database. Mark if you want to connect to the database using SSL.
Username: The database's public username. For example, pubuser.
Password: The database's public password. For example, pubuser.
Test Connection: Click to test the database connection settings you specified. If successful, click Close to return to the login screen.
Advanced
The fields in this section are automatically set to the best default value and do not need to be updated unless you are instructed to do so by your administrator.
Tips
- Contact your P6 Professional administrator if you need assistance when configuring database connections.
- Database connections you configured in releases prior to P6 Professional version 7.0 are not retained when you upgrade to 7.0; you must recreate these connections.
- To modify a configuration, select it in the list of available databases, modify connection settings as necessary, then click Close.
- To select a database to connect to, select it in the list of available databases, then click Close.
- To delete a configuration, select it in the list of available databases, then click .
- To rename a configuration, double-click it in the list of available databases, then type a new name.