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.


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.


Logistics & Transportation

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


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