Perbedaan Antara SOQL dan SOSL di Salesforce

Muchammad Andre Prasetya — Wed, 23 Apr 2025 08:22:56 +0000

1. Apa itu SOQL?
SOQL (Salesforce Object Query Language) digunakan untuk men-query data dari satu objek atau beberapa objek yang memiliki hubungan langsung.
🧠 Mirip seperti SQL di database biasa, tapi dengan sintaks khusus Salesforce.
Contoh SOQL:
SELECT Id, Name FROM Account WHERE Industry = 'Technology'
📌 SOQL hanya bisa mencari pada satu objek dalam satu waktu, tapi bisa mengambil data dari objek related melalui relationship.

2. Apa itu SOSL?
SOSL (Salesforce Object Search Language) digunakan untuk mencari string teks di banyak objek sekaligus.
🧠 Biasanya digunakan ketika kita tidak yakin data berada di objek mana, mirip pencarian global di Salesforce.
Contoh SOSL:
FIND 'Andre*' IN Name Fields RETURNING Account(Id, Name), Contact(Id, FirstName, LastName)
📌 SOSL dapat mencari di banyak objek sekaligus, tapi tidak bisa mengambil data relasional (parent-child).

Understanding Salesforce License Service

Muchammad Andre Prasetya — Wed, 23 Oct 2024 05:53:24 +0000

Salesforce License Service is essential for managing user access to the platform’s features and functionalities. In Salesforce, a license determines what actions a user can take and what parts of the system they can access. Let’s explore what licenses are, how they work, and why they are important for your business.

What Is a License in Salesforce?

A license in Salesforce is a permission granted to a user to access and use the platform. It defines what a user can do within Salesforce, including access to certain objects, applications, or features. Every user needs a license to log in and operate in Salesforce.

Types of Licenses in Salesforce

There are several types of licenses in Salesforce, each serving different purposes:

User License

This license provides basic access to Salesforce. Each user needs a User License to use the platform. Some common types include:
- Salesforce: Full access to Sales and Service Cloud.
- Chatter Free: Limited access for collaboration using Chatter, without access to other Salesforce data.
- Platform: For users who need access to custom applications built on the Salesforce Platform but don’t require full CRM access.
Feature License

This allows access to specific features that are not included in the User License. For example:
- Knowledge User License: Allows users to create and manage articles in Salesforce Knowledge.
- Marketing User License: Enables users to manage marketing campaigns in Salesforce.
Permission Set License

This adds additional permissions to a user without changing their main User License. For instance, if a user has a Platform License but needs access to an extra feature, you can assign a Permission Set License for that feature.

Why Is License Service Important?

Access Control

Licenses help businesses control who can access which parts of Salesforce. This ensures that only authorized users can view sensitive data or perform certain tasks.
Cost Efficiency

Licenses come at different price points depending on the level of access they provide. Assigning the right license to each user helps businesses optimize their spending while ensuring everyone has the tools they need.
Compliance and Security

Proper license management ensures compliance with data access rules and helps protect the system by limiting access to only the right users.

Managing Licenses in Salesforce

Salesforce administrators manage user licenses through the Setup section. Here are some key tasks:

Assigning licenses: When adding a new user, the admin must choose the appropriate license type based on the user’s role and responsibilities.
Viewing available licenses: Administrators can check how many licenses are used or available by going to Company Information in Setup.
Using Permission Sets: Permission Sets allow admins to give users extra access without changing their main User License.

Conclusion

Salesforce License Service plays a critical role in managing user access and ensuring effective use of the platform. By understanding the different types of licenses and how to manage them, businesses can optimize their Salesforce usage, control costs, and enhance security. Choosing the right license for each user will help your team be more productive while keeping your system secure.

If you have any more questions about Salesforce licenses or need further clarification, feel free to ask!