Home
Administration
Details on system administration tasks such as setup and maintenance of databases and add-ons, user accounts, access rights, and migration and update procedures.
Databases
Current regulations, such as 21 CFR 11.10 in the pharmaceutical industry, require you to ensure that only authorized individuals can access your systems, perform operations, and sign records. The database-driven approach of PLA 3.0 enables you to take major steps toward meeting these requirements.
Database creation
PLA 3.0 supports local databases, databases shared on a local network, and databases used in a client-server scenario, thus allowing you to create databases for single users and multiple users in a shared environment.

Get started
Explore PLA 3.0, its key features and ongoing enhancements, and learn how to log in and register.
User interface
PLA 3.0 supports you in your daily work by providing a set of graphical and textual user interface elements. Learn about the different elements and how to use them efficiently.
Key concepts
Details on documents and templates, the data editors and the Content editor of PLA 3.0. Learn about the position factors and data aggregation features.
Data analysis
Data analysis add-ons offer a wide range of capabilities, ranging from analytical methods over comprehensive analysis to statistical process control. PLA 3.0 also provides a set of add-ons that support and supplement data analysis add-ons.
Data import
Use data acquisition and data import add-ons to import external response values and observation data into PLA 3.0 for further processing and evaluation.
Installation
Details on the deployment, installation, initial and advanced setup of PLA 3.0.
Licensing
Details on the licensing solution of PLA 3.0, the available licensing options, and the activation and management of licenses.
Administration
Details on system administration tasks such as setup and maintenance of databases and add-ons, user accounts, access rights, and migration and update procedures.
- Databases
  Current regulations, such as 21 CFR 11.10 in the pharmaceutical industry, require you to ensure that only authorized individuals can access your systems, perform operations, and sign records. The database-driven approach of PLA 3.0 enables you to take major steps toward meeting these requirements.
  - Database types
    PLA 3.0 supports Microsoft SQL Server and SQLite databases.
  - Database creation
    PLA 3.0 supports local databases, databases shared on a local network, and databases used in a client-server scenario, thus allowing you to create databases for single users and multiple users in a shared environment.
    - Create a local not shareable SQLite database
      Create a local SQLite database if the data should only be accessible by you. PLA 3.0 creates the database in your Microsoft Windows home directory.
    - Create a shareable SQLite database
      Create an SQLite database and make it available for multiple users on a shared folder or a file server.
    - Initialize a Microsoft SQL Server database
      Initialize an empty Microsoft SQL Server database to create a database that can be simultaneously accessed by multiple users.
  - Database connections
    You can connect PLA 3.0 to multiple databases. Since most settings in PLA 3.0 apply to individual databases, you can differentiate, for example, between production and test databases, catering to tasks that require different work environments.
  - Database templates
    To enable you to create new databases more efficiently, PLA 3.0 provides a database template feature. This feature allows you to use existing SQLite databases as templates for the creation of new databases.
  - Database administration
    Use the database administration features to set up, monitor, and maintain your PLA 3.0 database system.
- Extensibility with add-ons
  PLA 3.0 consists of a framework and add-ons. The PLA 3.0 framework handles data as electronic documents. It provides the features you need to achieve regulatory compliance such as access control, data integrity, security, validation, and traceability.
- Rights and permissions
  PLA 3.0 provides the features you need to control access to your data in a sophisticated and compliant manner. It combines role-based user rights with resource-based permissions, which enables you to exercise fine-grained control over who can perform particular tasks in a given context and which tasks are allowed with particular data.
- Update, upgrade, and migrate
  Find details on how to update, upgrade or migrate your environment to work with the latest version of PLA 3.0.
Regulatory compliance
PLA 3.0 supports you in achieving compliance with regulations such as ISPE GAMP^® 5 and 21 CFR Part 11. It also provides options to validate PLA 3.0 in your environment.
PDF downloads
Download PDF guides of current and previous framework and add-on versions.
Sample lab
Meet the team at Stegmann Labs, where PLA 3.0 plays an essential role in every step of bioassay management.
Glossary
Find definitions of terms.

Database creation

PLA 3.0 supports local databases, databases shared on a local network, and databases used in a client-server scenario, thus allowing you to create databases for single users and multiple users in a shared environment.

Create databases in PLA 3.0

To support you in the creation of databases, PLA 3.0 offers the Database connection management wizard.

This guided tool lets you set up new database connections, modify existing ones, and switch between different databases. The wizard simplifies the process by providing step-by-step instructions and validation checks to ensure a successful connection.

For a detailed description of the wizard, see the Add database connections topic.

Key aspects

The choice of database depends on several key factors. PLA 3.0 supports SQLite and Microsoft SQL Server databases. When selecting which database to create, consider the following key aspects:


Number of users	Amount of data	Database location	Simultaneous use	Database type
single user	small amount	local computer	no	SQLite database (local)
multiple users	small amount	shared folder/file server	no	SQLite database (shareable)
multiple users	larger amount	database server	yes	Microsoft SQL Server database

Video: How to create your first PLA 3.0 database