Connect to an existing database

Use the database connection management feature to connect PLA 3.0 to existing databases.

Note: This task explains how to add connection profiles for existing databases. If you have already added a connection profile, the related database appears in the Database drop-down list of the Login dialog, where you can select it to connect.

Procedure

To connect PLA 3.0 to an existing database:
  1. Start PLA 3.0 but do not log in.
  2. In the Login dialog, select Tools > Database management.
    Figure 1. Database management feature in the Login dialog
  3. At the bottom of the Manage database connection profiles dialog, select Add....
  4. In the Database connection management wizard, select the Standard mode option and select Next >.
  5. Select the Connect to existing database option.
  6. From the Type drop-down list, select the database type you want to connect to and select Next >.
  7. On the Properties tab, set up the properties of your database connection.
    1. For SQLite databases, in the Value column, use the ellipsis button (…) to navigate to the folder where you have saved the database file, select it, and select Open.
    2. For Microsoft SQL Server databases, select the server name and enter the port. Select the authentication type, enter the user credentials, and select the database name.
  8. In the Name text box, enter a name for the database connection profile and select Next >.
    Tip: When logging in to PLA 3.0, you see this name in the Database drop-down list.
  9. Verify the connection properties and, if everything is correct, select Finish.
    Otherwise, use < Back to correct the respective settings.

Result

In the Manage database connection profiles dialog, you see the database connection you just created listed under Database connection profiles.