1. Overview

• Definition: Connects Mobio directly to your relational database management system (RDBMS) to retrieve and synchronize data.
• Users: System Admin, Data Engineer.

2. Terminology & Configuration Parameters

• Relational database (RDBMS) — Data stored in tables and rows (e.g., MySQL, PostgreSQL).
• Host/IP — The address of the server hosting your database.
• Port — The open service port for the connection.
• Credentials — The database username and password Mobio uses (needs Read permission).

3. Prerequisites

• Related article: Sync Mechanisms: Snapshot vs. Streaming
• Permissions: Your Mobio account must have the INTEGRATION RBAC permission. See the RBAC permissions guide.
• Access Path: 
  • Go to Settings → Data Integration → Connector → Data Source → Create New Data Source, or 
  • Settings → Data Integration → Data Flow → Data Source → Add New.

4. Step-by-step instructions

Step 1: Select a Connector by database type

• Select Add New Data Source on the Data Source screen, or click Add New from the Data Flow screen.
• Choose your database type, then click Continue to open the integration screen.

Step 2: Enter connection details

• Enter a Connector name and description.
• Enter your credentials:
  • Database Name — the database you want to pull from.
  • Host/IP — your server’s address.
  • Port — the connection port.
  • Username — the read-only user Mobio connects as.
  • Password — the account password.
• For setup details specific to your database type, see:
  • PostgreSQL Connector
  • Oracle DB Connector
  • MySQL Connector
  • IBM Db2 Connector
  • SQL Server Connector

Step 3: Test the connection

• Click Check Connection — Mobio only lets you save the Connector once the connection succeeds.

5. Operational Rules

• Database user permissions: Limit your database user to READ-only (Select) access to prevent accidental deletes or writes back to your source system.
• Internal network: For on-premise databases, open the port or whitelist Mobio’s server IP.
• Connection validation: Mobio validates the format and connectivity of your details (self-test) as soon as you enter them.
• Health check before sync: Before every sync session, Mobio checks the connection. If it’s not ready, Mobio skips the session to avoid wasting resources.

6. Frequently Asked Questions (FAQ)

• Q: Why does saving the Connector fail even though I entered everything correctly?
  • A: Mobio can’t save a Connector until Check Connection has run and succeeded.

7. Next Steps

Database Connector Report