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.

Once connected to a database, you can work on the data provided by the database and, provided you have the required permissions, also perform administrative actions for this specific database.

Note: For details on how to initially connect PLA 3.0 to a database, see the Connect PLA 3.0 to a database topic.

Examples

In our first example, PLA 3.0 is connected to a Development and a Production database.

Nick develops assays based on customer requirements and provides the respective templates to his colleagues. As his first task, Nick wants to develop an assay template and therefore logs in to the Development database as his work environment.

Having finished this task, he now wants to employ the new template to analyze assays. Therefore, he exports the template, logs out of the Development database and in to Production database. He imports the new template into the database and performs a trial assay analysis to test the template in a productive environment.
Template development and assay analysis employing two database connections
Figure 1. Template development and assay analysis employing two database connections

In our second example, PLA 3.0 is again connected to the Development and the Production database from our first example.

Ignacio is responsible for IT-related tasks. His first task is to add users to the Development database. He logs in to PLA 3.0, connects to the respective database, and uses the account management feature to add new users. As his second task, he wants to check how many users work in the production environment. He logs out of the Development database and switches his work environment by logging in to the Production database. In this database, he creates a configuration report.
Database administration tasks employing two database connections
Figure 2. Database administration tasks employing two database connections