H2
Boltic supports Integration with SQL databases like H2. It fetches data from your H2 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 H2 With Boltic
This guide will give you a brief idea of what steps you need to follow to integrate H2 into Boltic.
Step 1: Add Integration
Before configuring the H2, first, visit the Add Integration page to select as an in H2 integration
Step 2: Configuration
Once you select the H2 data source, provide the following details to your Configure H2 Integration Page-
| Description | |
|---|---|
| Host | A hostname is the IP address of the H2 |
| Port | A list of H2 port numbers (Default- 9092) |
| 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 H2 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