MS SQL
Boltic supports Integration with SQL databases like MS SQL. It fetches data from your MS SQL data source and allows you to create a Bolt that contains a sequence of actions such as Integration, Transformation, and Destination. In addition to this, you can schedule a Bolt at a fixed interval or date and time.
Note
You will need to Whitelist the following IPs to allow Boltic to connect to your database:
3.108.32.225 , 13.234.253.96
Setup Guide to Integrate MS SQL With Boltic
This guide will give you a brief idea of what steps you need to follow to integrate MS SQL into Boltic.
Step 1: Add Integration
Before configuring the MS SQL, first, visit the Add Integration page to select MS SQL as an integration.
Step 2: Configuration
Once you select the MS SQL data source, provide the following details to your Configure MS SQL Integration Page-
| Description | |
|---|---|
| Host | A hostname is the IP address of the MS SQL. |
| Port | A list of MSSQL port numbers. (Default- 1433) |
| Database Name | Name of the Database that has to be connected. |
Step 3: Authentication
To validate the identity of database users and ensure high-level security, you can authenticate the database by using any combination of the methods mentioned below-
Option 1- Basic Authentication
Username
Password
Option 2- SSH Authentication
Note
Basic authentication and SSH can also work together or independently.
Step 4: Test & Save
To validate data source configuration, click on the Test & Save, and determine whether the connection is successfully established or not.
Add Info
Its metadata, which includes a description, can be used for surfacing information to end-users and as tags for monitoring. Click on the More Options button to enter the metadata.
Congratulations
You have now successfully integrated your MS SQL database to Boltic!
Any Question? 🤓
We are always an email away to help you resolve your queries. If you need any help, write to us at - 📧 support@boltic.io