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!!
