First-Class Salesforce Data Loader

Export and import Salesforce data with Skyvia — the best in class Salesforce data loader!

Skyvia is a powerful Salesforce Data Loader solution that offers a number of advantages over Salesforce Import Wizard and other Salesforce data loader tools. With Skyvia you will be able to import CSV files either manually uploaded to Skyvia or stored on FTP or cloud file storage services such as Dropbox, Google Drive, or Box and automate Salesforce data export.

Load Files to Salesforce Effortlessly through Cloud

Unlike Apex Data Loader for Salesforce, Skyvia is a 100% thin-client Salesforce data loader, with no requirements other than a web browser to be accessed from anywhere.

Learn more about Integration

Configuring Easily

Skyvia allows you to configure Salesforce data loading automation in convenient and user-friendly GUI wizards. It also allows importing and exporting Salesforce data without typing a line of code.

Preserving Configured Operations

After you have configured your data loader operation (package) once, it is saved and available to you until you delete it. You can always rerun or edit it, or create a new package based on an old one.

Effortless Automation

You may schedule export and import to Salesforce for automatic execution. Skyvia's powerful and easy-to-understand scheduling settings allow you to quickly specify almost any kind of schedule to automate processes. Since Skyvia is a cloud solution, you don't need to leave your computer on or configure a server for this.

Monitoring

Skyvia logs all operation executions in a detailed log automatically. You can always see the number of successfully loaded records and the number of errors, if any, for each run, and download detailed per-record CSV error logs.

OAuth Support

Skyvia supports OAuth standard for secure delegated access to Salesforce, which means you do not need to acquire a Salesforce security token or store you Salesforce login and password in Skyvia.

Moreover, OAuth is supported for signing in to Skyvia itself, and you are not required even to register on Skyvia. Instead you may log in with your Salesforce or Google account. Log in with your Salesforce account and start data loading quickly!

Salesforce Data Import

Our Salesforce data import tool supports loading data from CSV files both manually uploaded and placed to different file storages. Skyvia offers the following features for import:

Mapping Features

Mapping Features

Skyvia allows not only column-to-column mapping but also lookups, constants, and mathematical and string expressions that can save your time when preparing your data to import.

Unlike Apex Data Loader, our online data loader for Salesforce does not require you to provide IDs for parent objects or owners. You can use their names or any other identifying field instead with Skyvia’s lookup mapping function. If a target object has an External Id field, you can use this field too with Skyvia's external ID mapping.

Skyvia's expression mapping allows performing various transformations on data: combining two source columns to a single target field or vice versa, performing mathematical calculations, etc.

Data Relations

Data Relations

When importing several CSV files with related data together, for example, such as Accounts and Contacts, Opportunities and OpportunityLineItems, Skyvia allows you to easily build corresponding relations in target data. For this Skyvia offers the relation mapping that allows you to specify a foreign key relation between the source files. The corresponding target relation is built automatically. You don’t need to import accounts first, then get and add their IDs to the contacts file — Skyvia does all this for you.

You can also use other kinds of mapping to specify the parent IDs — external ID mapping or Lookup. In this case you need to make sure that parent objects are imported before child ones.

Support for All DML Operations

Support for All DML Operations

Skyvia supports all the Salesforce DML operations: INSERT, UPDATE, DELETE, and UPSERT.

Data Splitting

Data Splitting

Skyvia can bulk upload data from one CSV file to several related Salesforce objects at once.

Multiple Import Tasks

Multiple Import Tasks

Skyvia can upload data to Salesforce from several CSV files to Salesforce as one operation.

Salesforce Export to CSV

Our Salesforce data export tool can extract data from Salesforce to CSV files to use them in Excel or other tools. These CSV files can be downloaded manually, or Skyvia can upload files to Dropbox, Box, Google Drive, Amazon S3, Azure File Storage or an FTP server.

Multiple Export Tasks

Multiple Export Tasks

Skyvia can load data from several Salesforce objects to CSV files as one operation.

Filtering Data to Export

Filtering Data to Export

Skyvia offers powerful filtering settings that allow you to export only the data you need.

Exporting Related Object Data

Exporting Related Object Data

You can export data from a Salesforce object and add fields from its related objects to export.

More than Mere Salesforce Data Loader Alternative

Direct Support for Other Sources

Direct Support for Other Sources

In addition to CSV files import, Skyvia can import data from other cloud applications and relational databases directly. Skyvia can also use Salesforce as a source for import, and load Salesforce data to other sources. With Skyvia, you can get Salesforce integration with no limits

Cloud Data Migration

Cloud Data Migration

Skyvia allows fast data migration between cloud sources. It provides predefined templates for cloud-to-cloud data loading that allow you to configure migration in just a few clicks. All you need is to specify connections to the cloud sources and select which data to migrate.

Data Replication

Data Replication

Skyvia can create a copy of cloud data in a relational database and keep this copy up-to-date.

About Skyvia Replication
Backup

Backup

Skyvia offers automatic daily and ad-hoc manual backups for cloud data. This feature comes complete with data preview, search, and one-click restore.

About Skyvia Backup
Query

Query

Skyvia allows executing SQL statements online against cloud apps and databases. It supports DML statements, allowing you to mass update and delete records.

About Skyvia Query

Configure your cloud data import operations with minimal effort and in only a few clicks!