Download Data Loader Salesforce For Mac

Posted on

Data Loader is a client application for the bulk import or export of data. Use it to insert, update, delete, or export Salesforce records. When importing data, Data Loader reads, extracts, and loads data from comma-separated values (CSV) files or from a database connection. – What is Salesforce Data Loader data loader? And why we use data loader? – Salesforce Data Loader is a tool provided by sales force to perform following opearation on data. – By using Salesforce data loader you can load up to 5,00,000 records. – Salesforce data loader good tool to load bulk amount of data into your Sobjects.

Contents
  1. Installing Salesforce Data Loader in macOS and Windows.
  2. How to Install Salesforce Data Loader.

Installing Salesforce Data Loader in macOS and Windows.

In this Salesforce Tutorial we are going to learn about What is Salesforce Data Loader, How to Install Apex Data Loader and How Apex loader is used to upload, delete, export and Import records.

What is Data Loader?

Salesforce Data Loader is a desktop client application used in Salesforce to import, export, delete, insert and update bulk records. Using Data Loader we can load upto 5,00,000 records.

Data Loader Features and operations.

  1. Using Data Loader we can load upto 5,00,000 records.
  2. Using Data Loader we can schedule the loads.
  3. We can import data from .csv (Comma Separated Values) files.
  4. Success and Error log files created in CSV format.
  5. Data Loader supports all objects(Custom objects and Standard objects).
  6. Drag and Drop field Mapping.

Data Loader Operations.

Using Data Loader we can perform the following operations.

  1. Insert – Insertion of new records.
  2. Update – Updating existing records.
  3. Upsert – Update and Insertion of records.
  4. Delete – Deleting existing records.
  5. Export – Extraction of all records.
  6. Export All – Export all extracts all records including recycle bin records from salesforce.

How to Install Salesforce Data Loader.

Installing Data Loader and setting up Data loader require small knowledge on generating security tokens. Before installing Data loader in Windows Operating system and MacOS we have to check system requirements.

System requirements for Windows.

  • Data loader is compatible with windows*7, windows*8 and windows*10.
  • Minimum 120 MB of disk space.
  • Minimum 256 MB RAM.
  • Must have Java JRE 1.8 installed.

System requirements for macOS.

Apex data loader salesforce
  • macOS EI Capitan or later.
  • Minimum 120 MB of disk space.
  • Minimum 256 MB RAM.
  • Must have Java JRE 1.8 installed.
  • Must have administrator privileges on the system.

Installing Salesforce Data Loader in Local system.

After checking all system requirement we have to install salesforce data loader in our local system. Follow the steps given below to install salesforce data loader.

  1. Download Data loader from Salesforce.
  2. Generate security Token.
  3. Installing Data Loader in macOS or Windows Operating system.
  4. Enter username and password.

Downloading Data Loader from Salesforce.

Data loader can be downloaded from data management. Go to Data Management Data Loader.

Salesforce
  • Click on Data Loader and select the Operating system to which you want to download.
  • Now Apex Data Loader will download in to our local system.
  • Install latest Java version in to your local system.
  • Now install Salesforce Data Loader.
  • Choose any operation as shown above.

Data Loader For Salesforce Download

When we try login into Salesforce.com using data loader we have to options.

  1. OAuth.
  2. Password Authentication.

Option 1 :- Salesforce login through OAuth.

Download Data Loader Salesforce For Mac Catalina

  • When we select OAuth option.
  • Now select the Environment. (Production or Sandbox).
  • Click on Login.
  • Now a new pop window will be opened where we have to login into Salesforce.com account using username and password.
  • Now a verification code will be sent to your account email.
  • Enter verification code and click on Login.
  • Click on Allow button to access as shown above.
For

Option 2 :- Login through Password Authentication.

Loader
  • Select password Authentication as shown above.
  • Enter username and Password.
  • Click on Login.

Where password is the combination of Salesforce account password and Security Token.

Salesforce
  • Now add Security Token after password.

Apex Data Loader Salesforce

Password = Password + Security Token.

Generating Security Token.

What is Security Token in Salesforce?

Security Token in Salesforce is a case sensitive alphanumeric key that is used with salesforce account password to access Salesforce via API.

How to generate Security Token?

Download Data Loader Salesforce For Mac Installer

To generate security token in salesforce go to My Settings Personal Rest my security Token.

Salesforce Data Loader Tool

When we click on Reset my security token an Email will be sent to the email address of our account. To log in to Salesforce via API we have to enter username and password.

Conclusion.

In this Salesforce Tutorial we have learned about What is Salesforce Data Loader, how to install data loader, what is Security token and how to generate new security token. In our next Salesforce admin tutorial we are going to learn about Salesforce Data loader operations.