Database Connector Report
Database connectors often run silently on a schedule, which means a stalled or failing sync can go unnoticed until customer data is already out of date. The Database Connector report breaks results down by session, so you can confirm every snapshot or incremental sync completed cleanly before it becomes a data quality problem.
1. Overview
- Definition: Tracks synchronized data in sessions.
- Benefits/Value: Monitor sync quality, spot failed sessions, and track snapshot/incremental progress.
- Target users: System Admin, Data Engineer.
2. Terminology & Specifications
- Sync type: Snapshot – Incremental.
- Sync status: Sync Complete, Syncing, Sync Stopped, Failed Sync, Awaiting processing.
- Session metrics: Session ID, Session Status, Sync Type, Sync Time, Total Successful Records, Total Failed Records.
- Display mode: Table View and Pipeline View.
3. Prerequisites
- Previous article: Complete a database connector setup and data sync configuration for at least 1 entity.
- Permissions: Your Mobio account must have the
INTEGRATIONRBAC permission. See the RBAC permissions guide. - Access Path: Go to Settings → Data Integration → Data Flow/Data Source → select any Database connector (MySQL, Oracle…) → Report.
- Input data: At least one sync session has run in the Database connector.
4. Implementation steps
4.1. Set up filters
- Select a sync time range: today, yesterday, 7 days ago, 30 days ago, this month, last month, 90 days ago, or custom.
- Select a sync status.
4.2. Check the summary metrics
- Check the summary metrics:
- Records: Total Records, Total Successful Records, Total Failed Records, Total Pending Records.
- Entity: New Profile
- Check the session metrics.
4.3. Analyze the session list
- Open the Table View to see the session list.
- Filter sessions by Sync status to spot sessions with unusual patterns.
- Switch to Pipeline View for more details on processing sessions and pending sessions.
4.4. Check processing progress by session
- Select a specific session to see its details.
- Compare successful and failed records within the session.
- If a snapshot checkpoint is available, use it to confirm the actual processing position.
5. Operational Rules & Use Cases
- For Database connectors, check the sync session and sync type to separate snapshot issues from incremental issues.
- If “Sync Stopped” appears repeatedly, cross-check the schedule against users’ actions.
- Move any session with a low success rate straight to technical log review.
6. Frequently Asked Questions (FAQ)
- Q: When should I use Pipeline View?
- A: Use it to quickly see the flow of processing sessions and completed sessions.