Documentation
  • Overview
  • Concepts
  • User Interface Basics
  • Collaboration
  • Profile Management
  • 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
  • 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
    • 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
    • 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
      • 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
  • 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
    • 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 Asana
      • Connecting to BigCommerce
      • Connecting to Constant Contact
      • Connecting to DEAR Inventory
      • Connecting to Drip
      • Connecting to Dynamics 365
      • Connecting to EmailOctopus
      • Connecting to Facebook Ads
      • Connecting to FreshBooks
      • Connecting to Freshdesk
      • Connecting to Freshsales
      • Connecting to G Suite
      • Connecting to Google Analytics
      • Connecting to HubSpot
      • Connecting to Insightly CRM
      • Connecting to Jira
      • Connecting to Magento
      • Connecting to Mailchimp
      • Connecting to Marketo
      • Connecting to NetSuite
      • Connecting to OData Endpoint
      • Connecting to Podio
      • Connecting to Pipedrive
      • Connecting to QuickBooks
      • Connecting to Salesforce
      • Salesforce API and API Calls Usage
      • Connecting to Marketing Cloud
      • Connecting to SendPulse
      • Connecting to ShipStation
      • Connecting to Shopify
      • Connecting to Slack
      • Connecting to Streak
      • Connecting to Stripe
      • Connecting to SugarCRM
      • Connecting to SurveyMonkey
      • Connecting to Timely
      • Connecting to WordPress
      • Connecting to Zendesk
      • Connecting to Zoho Books
      • Connecting to Zoho CRM
      • Connecting to Zoho Desk
      • Connecting to Zoho Inventory
      • Connecting to Zoho Invoice
      • Connecting to Zoho People
    • Databases
      • Connecting to Google BigQuery
      • Connecting to MySQL
      • Connecting to Oracle
      • Connecting to PostgreSQL
      • Connecting to Amazon Redshift
      • Connecting to Azure Synapse Analytics
      • 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:

CRM:

  • Dynamics 365
  • Freshsales
  • HubSpot
  • Insightly CRM
  • NetSuite
  • Pipedrive
  • Salesforce
  • Streak
  • SugarCRM
  • Zoho CRM

Accounting:

  • FreshBooks
  • QuickBooks
  • Stripe
  • Zoho Books

Email Marketing:

  • ActiveCampaign
  • Constant Contact
  • Drip
  • Email Octopus
  • G Suite
  • Mailchimp
  • Marketing Cloud
  • Marketo
  • SendPulse
  • SurveyMonkey

E-commerce:

  • BigCommerce
  • DEAR Inventory
  • Magento
  • ShipStation
  • Shopify
  • Zoho Inventory
  • Zoho Invoice

Project Management:

  • Asana
  • Jira
  • Podio

Misc:

  • Acuity Scheduling
  • OData
  • Timely
  • WordPress
  • Zoho People

Help Desk:

  • Freshdesk
  • Zendesk
  • Zoho Desk

Communication

  • Slack

Ads & Conversion:

  • Google Analytics
  • Facebook Ads
© Skyvia, 2014—2021. All rights reserved.
  • Terms of Service
  • Security
  • Privacy Policy
support@skyvia.com