Let’s have a look on some specific common differences that are mostly used on day to day work in Salesforce.
1. Data Loader Vs Data Import Wizard
Data Loader |
Data Import Wizard |
Data Loader can handle upto 5lacs of records |
Data Import Wizard handles upto 50 thousand number of records. |
It does not able to catch duplicates |
It catches duplicates |
It also allows to export data. |
There is no option available to export data. |
We can import opportunities through data loader |
We can’t import opportunities here. |
It’s a tool that require to setup in locale |
It exists within the Salesforce org. |
The option of hard delete is available in data loader |
There is no option of hard delete available. |
There is no option to turn off workflows here, so we need to turn off workflow through setup |
Yes,there is no option to turn off workflows here |
2. Managed Vs Unmanaged Package
Managed Package |
Unmanaged Package |
Managed packages are used by Salesforce partners for distributing and selling applications to their customers. |
Unmanaged packages are used for distributing an open-source projects or application templates to provide developers with the basic building blocks for an application. |
For managed package, the components installed can not be edited in the organization they are installed in. |
For an unmanaged package, the components installed can be edited in the organization they are installed in. |
Using the AppExchange and the License Management Application (LMA), developers can sell and manage user-based licenses to the app. Managed packages are also fully upgradeable. |
The developer who created and uploaded the unmanaged package has no control over the installed components, and can’t change or upgrade them. |
3. Workflow Vs Process Builder
Workflow |
Process Builder |
You can only achieve four actions through workflow |
Here we have an option to choose 9 actions to perform through process builder. |
Actions are as follows : Create Task Update Field Email Alert Outbound Message |
Actions are as follows : Call apex methods Create a record Send an email Launch a flow Post to Chatter Call An Invocable Process Quick action to create a record, update a record, or log a call Submit for approval Update related record |
4. Standard Report Types Vs Custom Report Types
Standard Report Types |
Custom Report Types |
Build report based on common standard object relationship. |
Build report based on different combination of related objects |
Build with reports |
Build with or without report |
Includes all standard and custom fields for each object in report builder. |
Limit, reorganize and rename the fields available in report builder. |
5. Workflows Vs Triggers
Workflow |
Trigger |
It’s an automated process that fired an action based upon an evaluation criteria and rule criteria. |
It’s a piece of code that executes before or after a record is inserted or updated. |
We can access a workflow across the object. |
We can access the trigger across the object and related to that objects |
We cannot perform DML operation on workflow |
We can use 20 DML operations in one trigger. |
We cannot query from database |
We can use 20 SOQL’s from data base in one trigger. |
6. SOQL Vs SOSL
SOQL |
SOSL |
Salesforce Object Query Language |
Salesforce Object Search Language |
SOQL can only query one object and related objects at a time |
SOSL enables you to search text, email, and phone fields for multiple objects simultaneously. |
SOQL queries used in triggers |
SOSL queries can not used in triggers |
Use SOQL when you want to retrieve data from number, date, or checkbox fields. |
Use SOSL when you want to retrieve data for a particular division in an organization using the divisions feature, and you want to find it in the most efficient way possible. |
Data can be retrieved by using ‘SELECT’ keyword |
Data can be retrieved by using ‘FIND’ keyword |
SOQL Limits : Total number of SOQL queries issued in synchronous mode is 100 Total number of SOQL queries issued in asynchronous mode is 200 Records retrieved by SOQL queries is 50,000 |
SOSL Limits : Total number of SOSL queries issued is 20 Records retrieved by SOSL queries is 2000. |
For example : SELECT Id,Name,(SELECT Id FROM Contacts WHERE Active__c = true) FROM Account |
For Example : [FIND ‘Dinesh*’ IN ALL FIELDS RETURNING Account (Id, Name), Contact (Id, Name), Opportunity (Id, Name)] |
Thanks For Reading!!
Happy Salesforce!!