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.
- Access the Setup section.
- Expand the Environment item in the menu.
- Click on BizzStream 2 SQL.
- 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.