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:
- Navigate to Sources in the sidebar
- Click + New Source
- Select your connector type
- Follow the connector-specific setup guide below
- 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:
- Add a Destination - Choose where to load your data
- Create a Pipeline - Configure what data to sync
- Schedule Syncs - Automate your data pipeline
Support
Need help? Contact us at support@supa-flow.io