Skip to main content

Sources

Connect to databases, SaaS platforms, and APIs to ingest data into your warehouse.

What are Sources?

Sources are data connectors that pull data from external systems. Once connected, you can create pipelines to sync data from these sources into your warehouse destinations.

To add a source:

  1. Navigate to Sources in the sidebar
  2. Click + New Source
  3. Select your connector type
  4. Follow the connector-specific setup guide below
  5. Click Test & Save

Available Source Connectors

CRM & Sales

Salesforce Sync Sales Cloud and Service Cloud data including Accounts, Contacts, Leads, Opportunities, and custom objects.

HubSpot Sync CRM data including Contacts, Companies, Deals, Marketing Events, and custom objects.


Marketing Automation

Salesforce Marketing Cloud Sync Data Extensions, Email tracking, Journey Builder data, and subscriber information.


Databases

PostgreSQL Replicate PostgreSQL database tables with support for batch sync and Change Data Capture (CDC).

SQL Server Replicate SQL Server and Azure SQL Database tables with support for batch sync and Change Tracking.

MongoDB Sync collections from MongoDB Atlas or self-managed MongoDB with full-refresh and cursor-based incremental sync. Community connector built on dltHub.


Productivity & Collaboration

Airtable Sync Airtable bases, tables, and views.


File Storage

Google Drive Sync structured data (CSV, TSV, Excel, Google Sheets) from Google Drive folders. CSV/TSV folders map to tables and files become rows; Excel/Google Sheets worksheets become tables.

SFTP Sync CSV, TSV, JSON, and JSONL files from SFTP servers, with gzip and ZIP support, password or RSA key authentication, and file modification-time incremental sync.


Logistics & Transportation

Oracle Transportation Management Sync shipment data, orders, releases, and logistics information.


Billing & Finance

Stripe Sync customers, subscriptions, invoices, products, prices, coupons, events, and balance transactions from Stripe. Community connector built on dltHub.


E-commerce

Shopify Sync products, orders, and customers from a single Shopify store with incremental sync and a read-only custom app token. Community connector built on dltHub.


Project Management

Jira Cloud Sync issues (with components, fix versions, links, subtasks, transitions, comments, worklogs, and changelog history), projects, users, and workflows from Atlassian Jira Cloud. Community connector.


Developer Tools

GitHub Sync repository events, issues, pull requests, and stargazers across one or more repositories. Supports Airbyte-style repository rules (owner/repo, owner/*, owner/prefix*). Community connector.


Web Analytics

Google Analytics 4 Sync 50 standard GA4 reports across acquisition, traffic, events, ecommerce, publisher ads, demographics, and technology, plus optional custom reports. Daily incremental sync with configurable lookback.


Authentication Methods

OAuth - One-click authorization for Salesforce and HubSpot Username/Password - Direct credentials for databases API Tokens - Token-based authentication for SaaS platforms Service Account - GCP service account key for Google Drive

All credentials are encrypted at rest.


Next Steps

After connecting a source:

  1. Add a Destination - Choose where to load your data
  2. Create a Pipeline - Configure what data to sync
  3. Schedule Syncs - Automate your data pipeline

Support

Need help? Contact us at support@supa-flow.io