Documentation
  • Overview
  • Concepts
  • User Interface Basics
  • Collaboration
  • Profile Management
    • Two-Factor Authentication
  • Account Management
    • Creating and Deleting Accounts
    • Inviting and Deleting Users from Accounts
    • Adding and Deleting Workspaces
    • Workspace Roles
    • Subscriptions, Payments and Trials
    • Subscription Limits and Plans in More Details
    • Email Notifications
  • Gallery
  • Connections
    • How to Configure Local Database Server to Access It from Skyvia
    • Authentication
    • Agent Connections
    • Metadata Cache
  • Agents
  • Data Integration
    • Import
      • Import Package
      • How to Create Import Task
      • Importing Binary Data
      • Importing CSV Files via File Masks
      • Performing UPSERT Operation
      • Performing UPDATE and DELETE
      • Importing Only Recently Added or Changed Data from Cloud Sources
    • Export
      • Export Package
      • How to Create Export Task
    • Replication
      • Configuring Replication Package
      • Editing Replication Task for Amazon Redshift
    • Synchronization
      • Synchronization Package
      • How to Create Synchronization Task
    • Data Flow
      • How to Build or Edit Data Flow
      • Components
      • Parameters and Variables
      • Results
    • Control Flow
      • Components
      • How to Design Control Flow
    • Common Package Features
      • Mapping
        • Column Mapping
        • Expression Mapping
        • Lookup Mapping (Target Lookup and Source Lookup)
        • Constant Mapping
        • External ID Mapping
        • Relation Mapping
        • Zip File Mapping
      • CSV Options
      • Filter Settings
      • Data Types and Limitations
    • Package Run History
    • Actions
    • Scheduling Packages for Automatic Execution
    • Tutorials
      • Import Tutorials
        • How to Import Contacts for Existing Accounts
        • How to Import Products with Prices from Dropbox
        • How to Import Tables from SQL Azure
        • How to Import Accounts with Binary Attachments
        • How to Import Deals and Contacts from Zoho CRM to HubSpot Preserving Relations
        • How to Import Data from Salesforce Opportunities to QuickBooks Invoices
        • How to Import QuickBooks Invoices to Salesforce Opportunities
        • Easy Importing Invoices and Customers Between QuickBooks Online Accounts
      • Export Tutorials
        • How to Export Salesforce Attachments for Specific Object
        • How to Set Up Daily Backup of Salesforce Contacts to Dropbox
      • Replication Tutorials
        • How to Set Up Replication of Salesforce Accounts and Contacts to SQL Azure
        • How to Set Up Replication of Dynamics 365 Data to SQL Azure
      • Synchronization Tutorials
        • How to Synchronize Product Data
        • How to Synchronize Zoho CRM Contacts with Mailchimp Subscribers
        • How to Configure Cloud Data Synchronization with Empty Database
      • Data Flow Tutorials
        • Loading New Records from Autoincrement Table
        • Updating Existing Records and Inserting New Ones
  • Backup
    • Working with Backups
      • How to Create Backup
      • Editing Backup
      • Managing Storage Space and Deleting Old Snapshots
      • Monitoring Backup Activity
    • Working with Backed Up Data
      • Restoring Data
      • Comparing Snapshots and Viewing Data Differences
    • Backup Security
    • Backup Limitations
    • Troubleshooting
  • Query
    • Configuring Queries with Query Builder
    • Managing Existing Queries
    • Query Gallery
    • Tutorials
      • How to Configure Filters in Queries
      • How to Create Joins in Queries
  • Skyvia Query Google Sheets Add-on
    • How to Query Data to Google Sheets
    • Filtering Data in Skyvia Query Add-on
    • Query Gallery in Google Sheets Add-on
    • Query Parameters in Google Sheets Add-on
    • Skyvia Query Add-on Options
  • Skyvia Query Excel Add-in
    • How to Query Data to Excel
    • Filtering Data in Skyvia Query Add-in
    • Query Gallery in Excel Add-in
  • Connect
    • OData Endpoints
      • How to Configure OData Endpoint in Simple Mode
      • How to Configure OData Endpoint in Advanced Mode
      • Adjusting Entities
      • Supported OData Protocol Features
      • How to Link External Data to Salesforce via Salesforce Connect (Salesforce Lighting)
      • How to Link External Data to Salesforce via Salesforce Connect (Salesforce Classic)
    • SQL Endpoints
      • ODBC Driver
      • ADO.NET Provider
      • Google Data Studio Connector
    • Security Settings
    • Monitoring Endpoint Activity
  • Supported SQL for Cloud Sources
    • SELECT Statements
    • DML Statements
  • Connectors
    • Cloud Sources
      • Connecting to ActiveCampaign
      • Connecting to Acuity Scheduling
      • Connecting to AfterShip
      • Connecting to Aha!
      • Connecting to Asana
      • Connecting to BigCommerce
      • Connecting to Capsule CRM
      • Connecting to Chargify
      • Connecting to Close
      • Connecting to Constant Contact
      • Connecting to DEAR Inventory
      • Connecting to Delighted
      • Connecting to Drip
      • Connecting to Dynamics 365
      • Connecting to EmailOctopus
      • Connecting to Facebook Ads
      • Connecting to Float
      • Connecting to Formstack
      • Connecting to Formstack Documents
      • Connecting to FreshBooks
      • Connecting to Freshdesk
      • Connecting to Freshsales
      • Connecting to Freshservice
      • Connecting to Freshworks CRM
      • Connecting to G Suite
      • Connecting to GitHub
      • Connecting to Google Ads
      • Connecting to Google Analytics
      • Connecting to Google Sheets
      • Connecting to Harvest
      • Connecting to Help Scout
      • Connecting to HubSpot
      • Connecting to Insightly CRM
      • Connecting to Intercom
      • Connecting to Iterable
      • Connecting to Jira
      • Connecting to Jira Service Management
      • Connecting to Klaviyo
      • Connecting to LinkedIn Ads
      • Connecting to Magento
      • Connecting to Mailchimp
      • Connecting to Mailgun
      • Connecting to Mailjet
      • Connecting to Marketo
      • Connecting to NetSuite
      • Connecting to OData Endpoint
      • Connecting to Okta
      • Connecting to Onfleet
      • Connecting to Outbrain
      • Connecting to Podio
      • Connecting to Pipedrive
      • Connecting to QuickBooks
      • Connecting to QuickBooks Time
      • Connecting to ReCharge
      • Connecting to RepairShopr
      • Connecting to Salesforce
      • Salesforce API and API Calls Usage
      • Connecting to Marketing Cloud
      • Connecting to SendGrid
      • Connecting to Sendinblue
      • Connecting to SendPulse
      • Connecting to Shippo
      • Connecting to ShipStation
      • Connecting to Shopify
      • Connecting to Slack
      • Connecting to Square
      • Connecting to Starshipit
      • Connecting to Streak
      • Connecting to Stripe
      • Connecting to SugarCRM
      • Connecting to SurveyMonkey
      • Connecting to Timely
      • Connecting to Todoist
      • Connecting to Twitter Ads
      • Connecting to Typeform
      • Connecting to WooCommerce
      • Connecting to WordPress
      • Connecting to Wrike
      • Connecting to Xero
      • Connecting to Zendesk
      • Connecting to Zendesk Sell
      • Connecting to Zoho Books
      • Connecting to Zoho CRM
      • Connecting to Zoho Desk
      • Connecting to Zoho Inventory
      • Connecting to Zoho Invoice
      • Connecting to Zoho People
      • Connecting to Zoom
    • Databases
      • Connecting to Amazon Redshift
      • Connecting to Azure Synapse Analytics
      • Connecting to Google BigQuery
      • Connecting to MySQL
      • Connecting to Oracle
      • Connecting to PostgreSQL
      • Connecting to Snowflake
      • Connecting to SQL Server or SQL Azure
    • File Storages
      • Connecting to Amazon S3
      • Connecting to Azure File Storage
      • Connecting to Box
      • Connecting to Dropbox
      • Connecting to Google Drive
      • Connecting to OneDrive
      • Connecting to FTP
      • Connecting to SFTP
    • Backup Connections
  • Expression Syntax
    • Main Differences between Old and New Runtime Syntax
    • Data Types and Type Conversion
    • Literals
    • Operators
    • Functions
    • Examples

Cloud Sources

Skyvia supports the following cloud data sources:

Accounting:

  • FreshBooks
  • QuickBooks
  • Xero
  • Zoho Books

Ads & Conversion:

  • Facebook Ads
  • Google Analytics
  • Google Ads
  • LinkedIn Ads
  • Outbrain
  • Twitter Ads

Communication

  • Slack
  • Zoom

CRM:

  • Capsule CRM
  • Close
  • Dynamics 365
  • Freshsales
  • Freshworks CRM
  • HubSpot
  • Insightly CRM
  • NetSuite
  • Pipedrive
  • RepairShopr
  • Salesforce
  • Streak
  • SugarCRM
  • Zendesk Sell
  • Zoho CRM

Documents:

  • Formstack Documents

E-commerce:

  • AfterShip
  • BigCommerce
  • DEAR Inventory
  • Drip
  • Magento
  • ReCharge
  • Shippo
  • ShipStation
  • Shopify
  • Starshipit
  • WooCommerce
  • Zoho Inventory
  • Zoho Invoice

Email Marketing:

  • ActiveCampaign
  • Constant Contact
  • Email Octopus
  • G Suite
  • Intercom
  • Iterable
  • Klaviyo
  • Mailchimp
  • Mailgun
  • Mailjet
  • Marketing Cloud
  • Marketo
  • SendGrid
  • Sendinblue
  • SendPulse

Forms & Surveys:

  • Delighted
  • Formstack
  • SurveyMonkey
  • Typeform

Help Desk:

  • Freshdesk
  • Freshservice
  • Help Scout
  • Zendesk
  • Zoho Desk

Misc:

  • GitHub
  • Google Sheets
  • OData
  • Okta
  • WordPress
  • Zoho People

Payment Processing:

  • Chargify
  • Square
  • Stripe

Product Management:

  • Aha!
  • Onfleet

Project Management:

  • Asana
  • Jira
  • Jira Service Management
  • Podio
  • Wrike

Scheduling & Booking:

  • Acuity Scheduling
  • Float

Task Management:

  • Todoist

Time Tracking:

  • Harvest
  • QuickBooks Time
  • Timely
© Skyvia, 2014—2022. All rights reserved.
  • Terms of Service
  • Security
  • Privacy Policy
[email protected]