Changes have been made to AIP Core and other CAST AIP tools to make it possible to connect to a custom CAST Storage Service/PostgreSQL database other than the default "postgres" (previously custom databases were not permitted for use with CAST). The current compatibility matrix is as below:
≥ 1.27.0-funcrel / 2.0.0-funcrel
|When using AIP Console with automatic synchronization to CAST Imaging, custom databases are supported as long as the releases of AIP Console and CAST Imaging are supported for this scenario.
|This includes any tool/application delivered with AIP Core such as CAST Server Manager, CAST Management Studio, CAST Enlighten, CAST Transaction Configuration Center, CSS Admin Tools etc.
|Standalone CAST Dashboards and RestAPI
|CAST Imaging export tools
|This includes exporter.exe and etl-automation.exe.
|≥ 9.0.2-funcrel is also embedded in AIP Core ≥ 8.3.41.
|Architecture Checker (as an extension)
|Not supported yet.
To be able to exploit this change, if required, please see information below.
Release ≥ 1.27 / ≥ 2.0 has this ability built in:
AIP Node installation:
AIP Node app-node-app.properties:
Measurement schema configuration:
When adding a new CAST Storage Service/PostgreSQL instance:
CAST Dashboards and RestAPI
CAST Storage Service/PostgreSQL connections are defined using JDBC URLs which specify the database "postgres" out of the box:
These JDBC URLs must be modified to change the "postgres" database to the custom database name (as described in https://jdbc.postgresql.org/documentation/head/connect.html) for example:
See Standalone CAST Dashboard deployment process for more information.
Legacy tools in AIP Core
CAST Server Manager / CAST Enlighten
The UI has not been modified, however to connect to a database other than "postgres", create a new profile and either use the Server name/IP:port field or the Connection string field, for example:
- See SRV - Creating Connection Profiles and ENL - Creating Connection Profiles.
- When you install a set of Application schemas with CAST Server Manager, a connection profile (PMX format) for use with CAST Management Studio will be automatically created for your target CAST Storage Service/PostgreSQL instance, including the custom database name.
CAST Management Studio/pmx files
The UI for tools using .pmx connection files (such as CAST Management Studio) has not been modified to allow a connection to a database other than "postgres", however, it is possible to build/edit your own custom cast-ms.connectionProfiles.pmx and specify your custom database name in this .pmx file. See Using the CAST-Connection-Profile-Configuration.py file.
The Database Connections Manager in CAST Management Studio will show the details about a connection to a custom database:
CAST Transaction Configuration Center
The UI has not been modified, however to connect to a database other than "postgres", use the Quick Connection option and specify the custom database name (or select a PMX based profile if one has already been created):
|PMX based profile