Our Top 5 Preferred Tools for Salesforce Data Migration

Every day, the work of any entity generates an enormous amount of information that is recorded in its database. Over time, the need to move that data from one site to another may arise. Some diverse causes that can provoke such migrations are: parallel work in two systems whose data needs to be integrated; the adoption of a new CRM; the redesign of an organization’s data model towards a more scalable one; maintenance or update actions; among many others. It is a procedure inherent to the development of companies, and for this reason it is very important to be prepared to undertake it effectively and in a timely manner. Doing it manually is unthinkable in the 21st century!

Recommendations to take into account before doing a data migration

Before implementing a data migration, we must take into account some important notes. Although some of them may seem quite intuitive, their application within the process can mean the successful completion of the operation, or to commit a grave error. Here are some recommendations to keep in mind during data migration:

  • Preparation of the migration process: those in charge of this process must carefully design all the steps that, from a technical point of view, will be necessary to carry out the data migration. A correct mapping process; proper relationship and order between the records, data format,compatibility checking and assurance; just to cite a few examples.
  • Optimization of the data model: the migration process is the ideal time to review the data structure the organization has and optimize it, either integrating elements or eliminating unnecessary ones.
  • Backup: If the data migration process is prepared and executed efficiently, it should not cause any problems. But in case things go wrong, having a backup copy is vital to ensure the integrity of the data.
  • Timely information: Keeping all stakeholders informed about the data migration process and the stages it will go through is critical. In this way, disagreements are avoided and the benefits of the process are better used.
  • Selection of a data migration tool: once we have defined our goal with the migration process, we must choose the appropriate tool to carry it out. It must be taken into account to what extent the benefits of each tool correspond to the needs and possibilities of the entity.

Salesforce Data Migration Tools

The tools that perform data migration are of the ETL type (extract, transform and load) and there are a wide variety available. Some are suitable for beginners or non-programmers, while others may be preferred by developers. They all have similarities in terms of their functionalities, although each one has their strengths and weaknesses. Making the choice between them should be based not only on the objectives of each company, but also on what the tool can do. To continue, we present our top 5 favorites tools for Salesforce data migration, with their respective general properties.

Salesforce Data Loader

It is a Salesforce client application that stands out from the rest for its high security and efficiency in handling large volumes of data. It provides a friendly and easy-to-use wizard interface and has two main ways in which it can be used: through the user interface (for macOS and Windows) and through the command line interface (CLI) (for Windows only). The latter allows you to perform complex and repetitive operations.

The Data Loader includes the basic options of insert, update, upsert, delete, export, export all and hard delete. In addition, it offers the possibility of mass deletion, and the option of auto-mapping. It permits checking the effectiveness of the operations thanks to the generation of CSV files (comma-separated values) with the record of successes and errors. Supports all Salesforce objects, including custom ones.

Salesforce Data Import Wizard

Data Import Wizard is a tool accessible from Salesforce, without the need to download or install any software. It has a unified interface that allows you to import data from many of the standard Salesforce objects, such as leads, accounts, or contacts; as well as custom objects.

To perform its function, it is only necessary to organize the data at the point of origin. Next, the necessary fields are assigned and edited to carry out the import, which can be up to 50,000 records at a time. It also includes the option to execute processes and workflows. Another great feature it has is field mapping, but unfortunately, the mapping can’t be saved for later use.

JitterBit Data Loader

It is an open-source tool from Jitterbit. Combine the power of APIs, integration and AI. Very useful for importing information related to potential customers or leads, and suitable for quick ad-hoc tasks due to its simple interface and multiple functionalities. Its intuitive API creation technology allows you to reuse applications and data.

It is designed for administrators which relieves the burden on IT resources. It uses Salesforce login credentials that are retained for later use.

This Data Loader offers the basic options of insert, update and upsert, it also has the options of query, delete and bulk load. It enables the selection of fields and objects by means of point and click. It offers the option to configure CSV files and other databases and allows data to be uploaded from local disks, FTP and databases such as MySQL, Oracle and SQL Server. Its user interface is useful for mapping object fields.

Dataloader.io

Dataloader.io is a cloud-based web tool developed by MuleSoft, which can be accessed using Salesforce credentials. It is capable of importing, exporting, deleting data and scheduling tasks with a simple user interface. Through it, administrators can access the audit history to monitor the tasks performed, as well as search based on text, not record IDs, this makes it easy to create and operate Vlookups.

Additionally, it has auto-mapping and is capable of exporting rules to objects. It ensures the confidentiality of the information through encryption. It has three versions: two paid and one free. It is frequently used in social programs that require continuous updating, such as Health and Education. Its main disadvantage is that it does not limit the volume that can be downloaded by profiles, which overloads the work of the administrators.

Salesforce Inspector

It is a tool accessible from Salesforce through the corresponding extensions in Chrome and Firefox browsers. It is capable of importing and exporting, as well as showing all the data and metadata, which can also be downloaded. It allows you to flexible and adjust the size of each batch to be imported, it also shows the details resulting from the import and facilitates debugging.

In the case of formula fields, it can show the applied formula. It also shows, on the details page, the External ID and auto-number of a field.

How to use Salesforce Inspector?

Discover in this video how to export and import data with Salesforce Inspector, a very useful alternative to the traditional Data Loader.

VIEW FULL VIDEO ➜

Here are some complementary elements as a summary for each tool:

Tool Salesforce Data Loader Salesforce Data Import Wizard JitterBit Data Loader Data Loader.io Salesforce Inspector
Preferential Use Between Salesforce instances for large volumes of data (between 50K and 5M records). If you need to schedule regular data uploads (such as nightly imports) or backup. Operable by all roles. Between Salesforce instances, when the data volume does not exceed 50K records and you want to avoid duplicates. Operable by all roles. Quick ad-hoc tasks. Designed for Salesforce administrators. Massive and recurring large-scale data migrations. Wide spectrum. Usable by virtually anyone.
Main Features Import and export. Operations: insert, update, upsert, delete. Automatic mapping. Efficient mass removal. Import. Operations: insert, update and upsert. Clean up duplicates. Import and export. Operations: query, insert, update, upsert, delete, bulk loads. It allows you to automate and program these operations. Create backups automatically. Import and export. Operations: insert, upsert, update and delete. Automatic mapping. Automation of programmable tasks. Import and export. Operations: query, insert, upsert, update and delete.
Imported/Exported Data Import CSV files and from database connections. Export CSV files. Import CSV files. Import and export flat files (with any delimiter, eg CSV), Excel and connections to ODBC or JDBC databases. Import and export CSV files. Import CSV or Excel files. Export Excel, CSV and JSON files.
Maximum number of records 5 M 50 K Unlimited -Free: 10 K/mo
-Professional: 100 K/mo
-Enterprise: unlimited
10 K
Cost Free Free Free Freemium Free
Type of solution Local Cloud-based (Salesforce) Cloud-based or local. Cloud-based Extension in Chrome and Firefox

Would you like some help choosing the most suitable Salesforce tool for data migration in your company? The SkyPlanner team can provide you with the guidance you need and advise you, based on their vast experience during the data migration process. You can write to us at hello@theskyplanner.com.

Trusted by great companies.

From start-ups to Fortune 500s, we help businesses of all sizes get the most out of their Salesforce experience.

sp-client-Sony
sp-client-GBI
sp-client-Sabadell
sp-client-Boats
sp-client-DHL
sp-client-Norwegian
sp-client-Larkin
sp-client-Bupa
sp-client-Discovery
sp-client-Bacardi

What people are saying

Five Start

Five stars on customer satisfaction and Salesforce appexchange ratings.

"Excellent Consultants. During the training I received by the SkyPlanner team, I was lucky to better understand the powerful capabilities of Salesforce.com. They were very effective, straight-to-the-point, and with a solid knowledge of the CRM and the Force.com platform. Definitively they showed us how to streamline the business process within our company. Great group of people spreading valuable knowledge to make businesses grow. I highly recommend them."

Ramiro Allen — Chief Software Engineer @ TurboPay Limited

"Excellent partner! We have been working with SkyPlanner for almost one year now. It has been a pleasure working with their team. If it wasn't for them we would have not been able to go-live with our platform when we did. They understood our needs and were not only able to execute but guide us in our decisions. We continue using them for our on-going projects. They have a deep understanding of the overall platform. Their team is always ready, willing and able to help."

Ivan de Moya — VP Innovation Technology @ SunStreet

"SkyPlanner was professional, creative, reliable and extremely accommodating. From the onset of the project, it was clear that we had found the right partner. Our project was complex and every time we hit a roadblock, SkyPlanner was helpful in identifying and implementing a solution. Jorge Fernandez [SkyPlanner's Co-Founder & Managing Director] was our primary contact and we cannot say enough about what an asset he was in bringing our project to resolution."

Ryan Borcherds — Marketing @ Deliver Lean

"On time, on budget, great quality on every project. Whenever I get asked to recommend a Salesforce.com partner, I do not hesitate on my reply: Go with SkyPlanner. I had the privilege to have worked with many teams over the years, none have brought to the table the enthusiasm the SkyPlanner team has. This combined with their professionalism and expertise are the reasons I ONLY recommend one partner: SkyPlanner. In every project (and we have done many) they have consistently delivered on time and on budget with significantly superior quality."

Juan Meza — Strategic Business Development Director @ Sony Electronics Inc.

"Outstanding Service! Happy to have them as our partner! SkyPlanner is by far the most experienced and reliable Salesforce partner. We almost gave up on Salesforce thanks to our previous partner, fortunately we found SkyPlanner and they came to the rescue! They took their time to understand our needs and complexity of our organization. Highly talented, professional and dedicated team. I cannot stress enough how happy we are to have them as our partner and we look forward to continue building our relationship."

Nolan Pereira — Project Manager @ BLU Products

Go to top