Oracle
Boltic supports Integration with SQL databases like Oracle. It fetches data from your Oracle 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 Oracle With Boltic
This guide will give you a brief idea of what steps you need to follow to integrate Oracle into Boltic.
Step 1: Add Integration
Before configuring the MS SQL, first, visit the Add Integration page to select Oracle as an integration.
Step 2: Configuration
Once you select the Oracle data source, provide the following details to your Configure MS SQL Integration Page-
| Description | |
|---|---|
| Host | A hostname is the IP address of the Oracle. |
| Port | A list of Oracle port numbers. (Default- 1522) |
| 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
Click the Name of Connection dropdown and authenticate the database by selecting either of the two options (Service Name or SID)
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 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 Oracle 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