SQL Database integration setup

What does the SQL Database integration do?

The SQL Database integration in Rewst allows users to connect to their existing Postgres, MySQL, or MSSQL database and perform queries on the database, including those hosted in Azure SQL or AWS RDS.

Our integration works with versions of MSSQL that are actively supported by Microsoft.

When enabling SQL Database integration and not using BYOD, the following completion handlers will still be automatically enabled, and will need to be disabled manually:

• BOYD: Insert Data Into Database

• BYOD: Upsert Cache DB Data Listener

Set up the integration

Once you've set up the database and have the necessary credentials, follow the below steps to configure a new integration:

1. Navigate to Configuration > Integrations in the left side menu of your Rewst platform.

2. Click or search for SQL Database.

3. Click on the integration tile to launch the configuration page.

4. Under Parameters, click to add a new database.

5. Complete the fields with your database information.

   
6. Click Save Configuration.

If you are using the database integration to cache information from options generators, follow the BYOD For Options Generators document