Skyvia is a powerful Salesforce integration and data loading solution that offers a number of advantages over other Salesforce data loaders. 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 export Salesforce data to CSV files.
Unlike Apex Data Loader, Skyvia is a 100% thin client platform which needs minimal configuration and only a web browser to be accessed from anywhere.
Skyvia allows you to configure your data loading operations in convenient and user-friendly GUI wizards, and also allows importing and exporting Salesforce data without typing a line of code.
After you have configured your integration 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.
You may schedule any data loading operation for automatic execution. Skyvia's powerful and easy to understand scheduling settings allow you to quickly specify almost any kind of schedule. Since Skyvia is a cloud solution, you don't need to leave your computer on or configure a server for this.
Skyvia logs all operation executions in a detailed run history automatically. You can always see the number of successfully imported rows and the number of errors, if there are any, for each run. The list of rows that caused errors, can be downloaded in the CSV format together with the error messages. This allows you to find out the reason of errors and get rid of them quickly.
Skyvia supports OAuth so you will not need to acquire a Salesforce security token or store you Salesforce credentials 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 sign in with your Salesforce or Google Drive account. Sign in with your Salesforce account and start data loading quickly!
Skyvia supports loading data from CSV files, both manually uploaded and placed to different file storages. Skyvia offers the following features for import:
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, Skyvia 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 External ID mapping.
Skyvia Expression mapping allows performing various transformations on data, including combining two source columns to a single target field or vice versa, performing mathematical calculations, etc.
When importing several CSV files with related data together, for example, such as Accounts and Contacts, with Skyvia you can easily build the 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, and 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.
Skyvia supports all the Salesforce DML operations: INSERT, UPDATE, DELETE, and UPSERT.
Skyvia can bulk upload data from one CSV file to several related Salesforce objects at once.
Skyvia can load data from several CSV files to Salesforce as one operation.
Skyvia can export Salesforce data to CSV files to use them in Excel or other tools. These CSV files can be either downloaded immediately, or saved to Dropbox, Box, Google Drive, or an FTP server.
Skyvia can load data from several Salesforce objects to CSV files as one operation.
Skyvia offers powerful filtering settings that allow you to export only the data you need.
You can export data from a Salesforce object and add fields from its related objects to export.
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.
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.
Skyvia can perform bi-directional synchronization of cloud and relational data.
Skyvia can create a copy of cloud data in a relational database and keep this copy up-to-date.