In this article, we are looking at all the concepts related to Data Loader as well as tackle top company interview questions during recruitment. Taking into account the ease of learning, we have segregated the article into two parts for I and II Data Management in Salesforce.
What is Data Loader in Salesforce?
Data Loader is a widely used tool provided by Salesforce by which we can process a large number of records at ease, at a minimum of 200 records batch, rather than processing every single record manually.
This tool is widely used in the migration process of legacy (old/previous) systems when the client wants to move to a Salesforce platform from .net / Java / SAP etc.
There are basically 3 real-time requirements at the time of migration.
- Reading the environment to have a data entry page/platform
- Enlightening the end-users on how to feed in the data from now on, i.e start using the new platform rather the old system,
- Moving the already existing data from old to the new system. Here the data loader in Salesforce comes into the picture.
Data Loader in Salesforce is free. There are other paid applications available for the deed as in, Jitterbit, Dataloader.io, Pentaho, Informatica, etc. Another free tool is the Data Import Wizard.
These tools help move data from sources like excel or CSV to SFDC in bulk. In the case of Data Loader in Salesforce, the fed source file is of CSV type.
How to install the required version of Data loader in Salesforce:
Setup >> data management >> data loader ( This will be in ZIP format.)
Extract dataloader.zip and wait.
Install Zulu — MSI (not ZIP) — 11 version (if the installation was not done properly, then it will show repair option, else not)
Now in the Data Loader folder extracted from the zip, double-click the install.bat file
Note: If you get an unknown publisher error message, you can ignore it and run the file.
You will find Data Loader installed in your system if all steps are done properly. For more Help on Installation on other platforms than Windows, Refer here.
Important Settings options in Data Loader in Salesforce
What is the server host in Data Loader in Salesforce?
It tells whether the Data Loader is going to connect/work on the Sandbox (Developer environment) or Production environment.
https://login.salesforce.com = (Live) Production environment
https://test.salesforce.com = (Development) Sandbox
What is the Sandbox / Development environment?
This is the environment, where we will be working on any project building process. This will be not connected to the client environment, so any mistakes here will not be a matter of concern.
What is the Production / LIVE environment?
This is the LIVE environment of the client, where the actual business will be running. Mistakes here can affect the 100s/1000s of end-user/client as this is the ‘real-time’ environment.
What is the Batch size in Data Loader Settings?
The number of records that will be processed by Data Loader in Salesforce at a time is called a Batch, i.e. the number of records it should take from the source file on laptop and load into the Salesforce cloud.
The default value is 200. Max allowed batch size is 10,000.
When the data is loaded in batches, there can be n number of codes and rules running on the data being inserted which might create a load on CPU. Run-time Error signifies the same and thereby demands to lower the batch size.
In case of a firewall restriction, we need proxy settings to be done as well. For that we have proxy port, number, username and password to be fed in Settings option as well. This is optional for the case you get a restricted access. You can contact the network engineer for that access.
Exporting Data from Salesforce Using Data Loader
Often, clients require you to take back up of data for any n number of reasons. Data Loader thereby has an export button, with the following processes after being opted.
1. Logging In to your salesforce platform to export data from.
We have two ways to login: oAuth and Security Token.
oAuth: Using one website login to authorize another.
Select the environment and click on Login.
Login using the pop-up window.
For Security Token method: Paste Password followed by your security token without any spaces. If you don’t know your security token, you can get it mailed to you by logging in to your Salesforce environment from the browser.
Go to your profile and click on Settings > Reset Security Token.
2. Select the Object for data export, and browse the folder to save the data into. Ensure the filename to be .csv
3. Edit your query: Select the data fields and/or impose conditions for data export. The query is auto-generated based on your selection. Click on Finish!
Data is loaded successfully. It consists of data from custom, standard as well as system fields.
Let us look at some Interview worthy questions asked in Companies like Samsung, Amazon, Vodafone.
Why authenticate login? Data Loader is a Dotnet app. And Salesforce always asks for authentication when we connect from outside.
The same is the case for “integration” when any platform like Java, PHP, etc will try to connect to Salesforce, then they must have a user name, password, and security token.
What are the benefits of Export in Data Loader in Salesforce?
It has many benefits in terms of data security :
A. We can take the backup of the data present in Salesforce into the CSV file.
B. We can shift data from 1 location/system to another system via the mode of the file.
C. We can pull data from Salesforce and work on them as per need, avoiding any unwanted data.
D. We can work on data in offline mode.
What kind of files does Data Loader in Salesforce support?
ONLY .csv (csv = comma separated value). It looks like an Excel file.
What types of fields do we get when we export any object’s records?
– Standard fields: CreatedBy, Owner, Name, Last Modified By
– Custom fields: Example Price__c
– System fields: SYSTEMMODSTAMP, LASTACTIVITYDATE, LASTREFERENCEDDATE, etc.
What is the difference between Export n Export All?
– ‘Export’ will pull only the “Non deleted” records from SF.
– ‘Export All’ will pull “Non deleted” + “Deleted” records.
In ‘export all’ files, we identify between the records that are deleted one with ones that are not based on ‘IsDeleted’ Column (True/False Value).
Export all is particularly beneficial in banking and financial projects where audit requires both deleted and undeleted data.
Pre-requisites for importing data to Salesforce Platform from old Platform
We get in touch with the Team handling the old platform and gain complete knowledge about all columns of data Table. Remove old platform-specific columns data and focus on business data.
Get hold of data in .csv file or excel (rename it to .csv). Rename column names to match the name of respective Salesforce object fields (API name) and save the file.
Importing Data to Salesforce Using Data Loader
Step 1. Open Data Loader, click on INSERT,
Step 2. Select the object and browse the file to upload.
Step 3. Map the file field to that in Salesforce objects.
Click on Edit Map. Drag and drop Object fields to the file fields in the pop-up window. If you already changed the names to match the API name as above, you can just click on Auto-match and move forward.
Step 4. Specify a folder for success (having an additional ID and Status Column) and error files and finish.
Here we end the first in detail part of Data Management in Salesforce.
In part 2 we are discussing as Data Import Wizard, Data Export, as well as understand other important concepts of Data Loader in Salesforce.