Administrator Server Database Details

You can choose to use the Administrator server with a default in-process database during development. In production systems, use an external database instead. This screen allows you to configure database details.

Field Description
Use Default In-Process Database Select to use the embedded in-memory database, or clear to use an external database. If cleared, the database configuration fields are displayed.

Default: Selected.

If you decide to use a non-default database, the wizard prompts you for database details.

Note: Use the default embedded database only during development.

If you are using an external database, see Database Requirements. To enable SSL communications, see Secure Communication Channels and SSL Requirements.

Note: The properties that the wizard sets in the build.properties file depend on the context in which the prompts are displayed. By default, specify the properties for the Administrator Server database and the information is then used for the Notification Service database, the Log Service database, and the Payload Service database. You can, however, overwrite the values for the Notification Service, Log Service, and Payload Service, and you can change them in the build.properties file.

Field Description
Database Driver Driver for the external database:
  • TIBCO enabled JDBC driver for IBM DB2 4.12.55
  • TIBCO enabled JDBC driver for IBM DB2 4.19.66
  • TIBCO enabled JDBC driver for IBM DB2 4.24.92
  • TIBCO enabled JDBC driver for Oracle 11.1.0
  • TIBCO enabled JDBC driver for Oracle 18.3.0
  • TIBCO enabled JDBC driver for Oracle 19.3.0
  • TIBCO enabled JDBC driver for Microsoft SQL Server 4.0.0
  • TIBCO enabled JDBC driver for Microsoft SQL Server 4.2.0
  • TIBCO enabled JDBC driver for Microsoft SQL Server 6.0.0
  • TIBCO enabled JDBC driver for Microsoft SQL Server 7.0.0
  • TIBCO enabled JDBC driver for Microsoft SQL Server 11.2.3
  • TIBCO enabled JDBC driver for PostgreSQL 10.7.0 (postgresql-42.2.8.jar is required)
  • TIBCO enabled JDBC driver for PostgreSQL 11.5.0 (postgresql-42.2.8.jar is required)
  • TIBCO enabled JDBC driver for PostgreSQL 14.4.0 (postgresql-42.2.8.jar is required)

Default: JDBC driver provided for HSQL 1.8.400.

Database URL

URL of the external database.

Default: jdbc:hsqldb:hsql://localhost:1234/amx.

Note: For PostgreSQL database, you must add client machine IP address entry in the pg_hba.conf file. If the TIBCO ActiveMatrix Administrator is replicated, you must also add IP address of the machine on which ActiveMatrix Administrator is replicated in the pg_hba.conf file. For more information, see PostgreSQL documentation.

Username External database username.

Default: sa.

Password External database password.

Default: None.

Max Connections Maximum number of database connections to allocate.

Default: 10.

Database Server is SSL Enabled Check to enable the database server for SSL. When checked, the SSL Keystore Configuration fields are enabled.

Default: Cleared.

Note: PostgreSQL database with SSL enabled is not supported in TIBCO ActiveMatrix Service Grid 3.4.2.

Test Connection Click Test Connection to ensure that you can connect to the database.
Field Description
Create a Trust Store... Invokes a wizard to import certificates from a server and create the trust store.
  1. Specify a password to protect the trust keystore and click Next. The SSL setup wizard displays certificates imported from the trusted server.
  2. In the Trusted Certificates area, select the checkboxes next to the certificates to trust and click Finish.
Browse Invokes a dialog to navigate to a keystore file.
Keystore Location Location of the keystore.
Keystore Type Type of the keystore: JKS or JCEKS.

Default: JKS.

Keystore Password Password that protects the keystore.

Starting with TIBCO ActiveMatrix 3.4.0 Hotfix 002, PostgreSQL database versions 11.5 and 10.7 are supported. In PostgreSQL, the client authentication is controlled by apg_hba.conf file in the database cluster's /data directory.

By default, a PostgreSQL database listens to TCP/IP connections only on the local loopback address localhost.

Therefore, before configuring a PostgreSQL database by using TIBCO Configuration Tool (TCT), you must add a client machine IP address entry in the pg_hba.conf file.

If the TIBCO ActiveMatrix Administrator is replicated, you must also add the IP address of the machine on which the ActiveMatrix Administrator is replicated in the pg_hba.conf file.

For example, if the client machine IP address is 172.20.143.0, then you must add an entry in the pg_hba.conf file as: 

# TYPE  DATABASE        USER            ADDRESS                 METHOD
host    all             all             172.20.143.0/24         trust
For more information about the pg_hba.conf file, see PostgreSQL documentation.

Note: PostgreSQL database with SSL enabled is not supported in TIBCO ActiveMatrix 3.4.2.