SQL Connection Objects

As a developer and object designer you need SQL Connection (CONN) objects when you define VARA objects that retrieve values from an SQL database. As an administrator user, you create the SQL Connection objects that provide the required connection data.

Database Page

  1. In the Connection section you specify the type of database and the connection data.

    The system supports multiple database types. If you do not find yours in the Database Type dropdown list, select Generic JDBC and enter the Connection String as indicated by your provider.

    For all other database types in the dropdown list the following must be specified:

    1. Server:Port

      Name of the computer on which the database is available and the port number. If you specify Port 0 the database agent itself attempts to find a suitable port.

    2. Database Name

      Name of the database that should be used.

  2. In the Login Data section specify:

    • Login Object

      Optionally, enter theLogin (LOGIN) that provides the login data (client, user, password).

    • Alternative User Name and Alternative Password

      Alternative user and password in case the data delivered by the Login object fails.

  3. In the Connection Test section click the Test button to try the connection. A message displays the results of the test.

Advanced Settings Page

On this page you can define the JDBC connection settings.

Example: If you want to enable TLS v1.2 for MySQL, enter enabledTLSProtocols in Connection Properties Extension.

For detailed information, please refer to your official database documentation, for example:

See also: