Skip to main content

MYSQL

Boltic supports Integration with SQL databases like MYSQL It fetches data from your MYSQL data source and allows you to create a Pipe that contains a sequence of actions such as source integration, choosing databases and destination integration. In addition to this, you can schedule a pipe at a fixed interval or date and time.

Getting Started​

Requirements​

To integrate MySQL as a source, you'll need:

  1. MySQL User Access

    • A MySQL user with read access to both:
      • The target database
      • The local database

  2. SSH Details

    • SSH access details (if using an SSH tunnel server)
    • A private key for secure connections

  3. IP Whitelisting

    • Visit our IP Whitelisting Guide for whitelisting IPs and CIDR ranges to ensure secure access to your database or service.

  4. MySQL Configuration

    • To ensure smooth and efficient operation of Change Data Capture (CDC) in MySQL, it's crucial to follow the recommended configuration steps. For a detailed guide, refer to the MySQL Configuration documentation.

Setup Guide to Integrate MYSQL With Boltic​

This guide will give you a brief idea of what steps you need to follow to integrate MYSQL into Boltic.

  1. Integration Name: Enter a unique name for this integration.

    Integration Name

  2. Host Details:

    ParameterDescription
    Host nameIP address of the MySQL server.
    Port NumberEnter MySQL port number (default is 3306).
    Database NameName of the database to connect to (required).

    Using Host

Authentication​

To validate the identity of database users and ensure high-level security, authentication can be done using the following methods:

  • Username and Password (Required)

  • SSH Authentication (If needed):

  • SSH Host

  • SSH Port

  • SSH Username

  • SSH Authentication Method (supports private key and password). For more details, refer to SSH Authentication.

Both Basic Authentication (username and password) and SSH Authentication can be used independently or together.​

Additional Info​

Provide metadata to enhance data management:

FieldDetails
TagsUse tags for easy data discovery for you and your team.
DescriptionProvide a detailed and meaningful description of your database.

Tags & Description

Test & Save​

Click on Test & Save to validate your data source configuration and confirm that the connection is successfully established.

Test & Save

Congratulations! You have successfully integrated PostgreSQL with Boltic.

🤓 Have Questions?​

We're here to help! Feel free to reach out via email at 📧 [email protected].