Lists from an external data source

List with an external data source

The values of a list in Profields can depend on the values of an external data source. So far only databases are available.

  1. To create a database connection, go to Profields → 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>
    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 Profields → Fields.)
  5. Under External sources, select a source.  

  6. Enter the required information, including the SQL Query that will be used to get the values.