Skip to content

Configuring BizzStream 2 SQL

To set up BS2SQL, ensure the module is enabled in your environment. If it is not yet enabled, contact BizzStream Support.

  1. Access the Setup section.
  2. Expand the Environment item in the menu.
  3. Click on BizzStream 2 SQL.
  4. Provide required information and click on Save.

To use BS2SQL you have to provide the following information:

Field Description
connection string A connection string for the PostgreSQL database. Example: postgres://username:password@hostname:port/database
enabled When checked, document definitions and the insert, update, and delete actions on documents will be queued and processed to SQL.

Note 1: The module will only make connections to PostgreSQL databases using SSL encryption. Unencrypted connections are not supported for security reasons.

Note 2: Since we restricting network traffic in our clusters, we only allow the default (Postgres) port for outgoing connections. If a non-default port is preferable, please reach out to your consulting partner to discuss.

Document Definition

To start using the BizzStream 2 SQL feature, you will need to enable the Expose to SQL checkbox at the document definition level. Toggling the setting off and on re-queues all documents for that definition. This overwrites existing records with their latest versions,