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: The module will only make connections to PostgreSQL databases using SSL encryption. Unencrypted connections are not supported for security reasons.

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.