(8.17.X) Lists from an external data source
- Alvaro Aranda Jiménez
List with an external data source
The values of a list in Projectrak can depend on the values of an external data source. So far only databases are available.
1. To create a database connection, go to Projectrak → Connections.
2. Select Create connection.
3. Enter the required information.
For connection string you have the following examples of the most important databases:
Database | Connection String |
|---|---|
SQLServer | jdbc:sqlserver://<server>[:<port>];databasename=<databasename>;schema=<schema>;user=<user id>;password=<password> |
Oracle | jdbc:oracle:thin:[<user>/<password>]@<host>[:<port>]:<SID> (if the password contains speacial characters, please parse it with double quotes: "password") |
MySQL | jdbc:mysql://<server>[:<port>]/<database>?user=<user>&password=<password> |
PostgreSQL | jdbc:postgresql://<server>[:<port>]/<database>?user=<user>&password=<password> |
4. Select a list in the Fields manager (Go to Projectrak → Fields.)
5. Under External sources, select a source.
6. Enter the field name, the connection (previously created) and the SQL query that will be used to get the values.
