Create a shareable SQLite database
Create an SQLite database and make it available for multiple users on a shared folder or a file server.
Procedure
To create a shareable SQLite database:
- In the Database connection management wizard, select the Standard mode option and select Next >.
- Select the Create new database option.
- To make the new database shareable in your network, select the Database profile is available for all users on this computer option.
- From the Type drop-down list, select SQLite and select Next >.
-
Enter the database connection parameters:
Figure 1. Database connection parameters for an SQLite database -
The SQLite database is created in the directory displayed in the
Value field. To select a different directory,
select the field and use the ellipsis button
(…) to navigate to the directory you want to
use.
Note: If you change the default directory, make sure the new directory is accessible by all users who should be able to connect to the database.
-
In the Description text box, enter a name for
the database connection profile and select Next
>.
When logging in to PLA 3.0, this name will be displayed in the Database drop-down list.
-
The SQLite database is created in the directory displayed in the
Value field. To select a different directory,
select the field and use the ellipsis button
(…) to navigate to the directory you want to
use.
- Select Next >.
- Select the Standard template option and select Next >.
-
Enter the credentials that you want to use for the administrative account of
the database and select Finish.
Important: We recommend you keep the credentials in a safe place. You need them to manage the database and the user accounts, and we cannot restore them as they are not known to us.