Skip to main content

Database settings

System database selection begins in Connections.json; General Setup is then loaded from the selected VxConfig as the VX_SETUP module. Do not confuse these system roles with reusable DB Connection modules used inside integrations.

RolePurposeImportant boundary
Config / ConfigTestVxConfig modules, relationships and setup for production/testDetermines the configuration context loaded by Designer and services
Log / LogTestLogical log database mappingReviewed core SQLL resolves to the active configuration connection for VX_LOG*; verify the deployed schema before assuming a separate log server
Data / DataTestVxData business transaction dataSeparate from configuration; access and schema depend on the integration/portal deployment

The Connections.json database profile controls engine type, host, database, authentication, username/password, driver and certificate trust. Change those values through the environment procedure, not as a speculative General Setup tuning action.

Safe validation

  1. Confirm the current connection key and test/production context.
  2. Verify actual Config/Log/Data hosts and databases against the approved environment record.
  3. Test under both the interactive and service identities.
  4. Confirm schema updates are applied before service start; reviewed service startup does not run the upgrade check.
  5. Run a controlled read/write Flow and inspect the actual output and log persistence.

See environment properties and the DB Connection guide for integration databases.