SQL Database integration

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

If you’re new to integrations in Rewst, read through our introductory integration documentation here.

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. Note the drop-down menu in the top left of the configuration page. You'll need to add each database into Rewst separately. Click Add Configuration to add each new database, and follow the rest of these steps each time, for each new database.

   

5. Complete the fields with your database information.

   1. Database Config Name - Unique identifier to pick database for action

   2. Database Type - Supported SQL databases

   3. Hostname - Hostname for database connection

   4. Port - Port for database connection

   5. Username - Database user username

   6. Password - Database user password

   7. Database Name - Database name for database connection

   8. SSL Required - SSL encryption provides end-to-end security of data sent during the session

   9. SSL Hostname Verification - Verify that the SSL certificate hostname matches the connection hostname. Disable for cloud databases (GCP, AWS, Azure) that use dynamic hostnames or load balancers. SSL certificates are still validated when disabled. SSL Required must be enabled.

   10. Custom Connection Timeout (seconds) - Default database connection timeout is 5 seconds

   11. Custom SSL Certificate - Leave this blank if using AWS RDS or Azure SQL, which are supported by default. If your database needs a custom SSL, copy and paste the raw CA certificate here.

6. Click Save Configuration.

7. In your workflows, be sure to use integration overrides to select which database configuration should be run.

If you are using the database integration to cache information from options generators and speed up the flow of information between Rewst and your RMM, follow the BYOD For Options Generators document steps after initial integration setup.

Actions and endpoints

Category	Action	Description
Query	Custom Query	Run custom SQL Query on cloud database
Query	Query Tables List	Get list of tables from database configuration
Query	Query Users List	Get list of users from database configuration
Query	Test All Configurations	Test all databases by getting list of tables from each database
Query	List Database Configurations	Get list of all set up databases