Business Analyst Academy
Module 11: Configuration, Automation & Integrations Overview
Core · 90 minutes

Jump to section

Module 11 Core 90 minutes Salesforce Skills

Configuration, Automation & Integrations Overview

BA Academy — self-paced module

What you'll be able to do

By the end of this module, you will be able to:

Section 1

The BA's Stake in Configuration

You will probably never be the person who builds the org's most complex automation. You will constantly be the person who decides, with stakeholders, what the automation should do, and whether it is worth doing. That requires knowing what the platform can do declaratively (with clicks, not code), what requires code, and what requires connecting other systems. This module is your map of that terrain. It also completes the "basic configuration tasks" listed among BA activities in Module 1: many BAs do hands-on configuration at exactly the level covered here.

Section 2

Configuration Basics

Lightning Apps

A Lightning app is a way to control access to Salesforce functionality within an org: a named collection of tabs and components so that assigned users see only what they need. A college admissions team gets an "Admissions" app with admissions objects and tools; the registrar team gets a "Registrar" app with registrar-related objects. Apps can also be installed from the AppExchange, the marketplace where the ecosystem shares and sells solutions.

For the BA: apps are a persona concept. When your security matrix (Module 7) defines who needs what, apps define how each persona's workspace is packaged. "What should each team see when they log in?" is an app requirement.

Lightning Pages

Lightning pages are custom page layouts: they control what a record page (or home page, or app page) presents. Pages can be assigned as an org-wide default, or varied by app, by record type, and by profile: the account object's page differs from the contact page, and can differ again per audience.

Dynamic forms take this further: field and component visibility can respond to conditions, so different subgroups see different fields on the same page, or fields appear only when relevant (show "Reason Lost" only when an opportunity is lost). When stakeholders say "this screen is cluttered" or "intake needs these fields up top" (a complaint you will hear in every UAT), Lightning pages and dynamic forms are the remedy.

Fields and Picklists

A field stores data (Module 6 covered the data-model view). Configuration adds the practical craft: each field has a data type (text, number, date, and so on) chosen to match the information being collected, and each field belongs to exactly one object.

Picklists deserve special attention because they encode business rules. A picklist lets users select one or multiple values from a predefined set. Global picklist value sets define a value list once and reuse it across multiple fields, with per-field restriction of which values are available. When two teams need "the same statuses, mostly," a global value set with restrictions beats two drifting copies: and knowing that shapes how you write the requirement.

Validation Rules

Validation rules conditionally prevent a record from being saved: the platform's guardrails for data quality. Essentials worth knowing precisely:

  • They enforce data quality by rejecting saves that fail a condition ("Close Date cannot be in the past," "Amount required when Stage is Closed Won")
  • They are configured at the object level
  • They are case-sensitive in their logic, so requirements involving text matching need exact values
  • Critically: validation rules fire everywhere, all the time: through the user interface, the API, integrations, and even when the field involved is hidden from the current user

That last property makes validation rules a favorite BA tool: a rule enforced only on one screen is a suggestion; a validation rule is policy. When a stakeholder says "records must always have X before Y happens," you are hearing a validation-rule requirement. Capture the condition, the error message users should see (write it in plain, helpful language), and the exceptions, because there are always exceptions.

Section 3

Automation with Salesforce Flow

Salesforce Flow is the platform's point-and-click automation tool: it creates and automates complex business processes, automating repetitive tasks and guiding users through processes, without code.

The Four Types of Flows
  1. Screen flows require user interaction: they guide users through a series of screens and capture data. Example: a sales rep completing a multi-step form to create an opportunity, or a support agent walked through a structured case-update process.
  2. Auto-launched flows run without user interaction, triggered programmatically or from other automations: background processes needing no input.
  3. Record-triggered flows fire when a record is created, updated, or deleted. Example: automatically updating a record's status when an opportunity reaches a certain stage. This is the workhorse type, and the modern replacement for the retired tools below.
  4. Scheduled flows run on a schedule (daily, weekly). Example: automatically creating follow-up tasks for leads every 30 days.
Why Flow Won

Flow's benefits: no code required (drag-and-drop building), efficiency (repetitive tasks automated, human error reduced), flexibility (update records, send emails, create tasks, and much more), and improved user experience (screen flows turn complex processes into step-by-step guidance). Distinctive advantages over the platform's older tools: interactive UI screens, mass updates and deletes across unrelated records, record cloning, loops, and decision logic: real programming power in a visual builder, growing with every release.

The Retired Generation: Workflow Rules and Process Builder

Two older automation tools remain visible in existing orgs and in interview questions, and both are retired features: no longer the way new automation should be built.

  • Workflow Rules were the simplest automation: criteria-based rules triggering actions like sending emails, updating fields, or creating tasks ("email an alert when an opportunity reaches a stage").
  • Process Builder was the intermediate tool: more capable than workflow rules, less than Flow.

Treat them as historical context: you will encounter them in older orgs, and migrating their logic into Flow is a common project task (a nice example of the reverse-engineering elicitation from Module 3: the old automation is documentation of a business rule somebody once needed). Salesforce's direction is unambiguous: Flow is the preferred automation tool, and new features land there.

The Supporting Automation Cast

Several narrower automation features complete the picture, each a concept you should recognize in requirements:

  • Assignment rules automatically route new leads or cases to the right user or queue based on criteria: the "how does work find the right person?" answer you met in Module 2's Service Cloud.
  • Auto-response rules send immediate acknowledgment emails when records (typically cases or web leads) are created.
  • Email alerts are automated messages sent when triggers occur: a welcome email to a new contact, an alert to a manager when a case escalates. Email alerts are building blocks used by flows and approval processes.
  • Escalation rules raise the alarm on cases that sit too long, reassigning or notifying up the chain.
  • Scheduled actions trigger work at a specific time or on a recurring schedule: reminders, daily summary emails to a manager with all open opportunities.
Approval Processes

An approval process automates multi-step approvals: a user (or automation) submits a record, and designated approvers manually approve or reject it, determining whether it advances. The process specifies each step, whom to request approval from, and what happens at every point.

Approval processes attach to standard or custom objects. Classic use cases: a sales rep requests a 30 percent discount, routed to their sales manager; a large-quantity quote discount routed to the sales team; an employee's leave request routed to their manager.

The anatomy:

  • Approval steps define which records can advance to each step, who approves, and whether an approver's delegate may respond. The first step determines what happens to records that do not meet criteria; later steps specify what happens on rejection.
  • Approval actions define what happens at each juncture: the initial submission action (on submit: typically locking the record), final approval action (on approval: update fields, send notifications, unlock), final rejection action (on rejection), and recall action (if the request is withdrawn).

For the BA, approval requirements are a gift: they force stakeholders to articulate exactly who may authorize what, at which thresholds, with what consequences: governance made explicit. Diagram them as swim-lane processes (Module 5) before anyone configures anything.

Order of Execution

When a record is saved, the platform runs its many automations in a defined sequence, and knowing the outline explains otherwise-mysterious behavior ("why did the validation error appear before my assignment happened?"). The teaching mnemonic: Very Angry Admins Work Pretty Efficiently:

  • Validation rules
  • Assignment rules
  • Auto-response rules
  • Workflow (legacy)
  • Process (legacy)
  • Escalation rules

(The full technical order is longer and includes flows and triggers at several points; the mnemonic covers the classic sequence and is a fine interview answer at BA depth.) The BA takeaway: automations interact in sequence, which is why seemingly simple changes get tested carefully: Module 12's subject.

Automation Best Practices

Four practices worth repeating to every stakeholder who wants "just a quick automation":

  1. Start simple. Build easy flows first; add complexity as comfort grows.
  2. Consider performance. Too many automations degrade an org. Track what runs and optimize.
  3. Monitor and test. Always test automations in a sandbox before production. Always.
  4. Use versioning. Flows are versioned; keep working versions to revert to when something goes wrong.
Section 4

SOQL: Reading the Database's Language

SOQL (Salesforce Object Query Language) is the query language used to retrieve data from the platform: similar to SQL (Structured Query Language) but tailored to Salesforce's multi-tenant, object-oriented data model.

Key points:

Reading examples (from the source material's exercises):

SELECT Id, Name, Birthdate FROM Contact
SELECT Id, Name, Birthdate, Phone FROM Contact WHERE Phone != ''
SELECT Id, Name, Birthdate, Phone FROM Contact WHERE Phone != '' OR Email != ''

The first retrieves three fields for every contact; the second only for contacts with a phone number; the third for contacts with a phone or an email. That is genuinely most of the reading fluency a BA needs: SELECT (which fields) FROM (which object) WHERE (which conditions). Writing complex SOQL is developer and admin work (and per the career ladder in Module 18, a growth skill rather than a core BA skill), but reading a query in a design document, and confirming it matches the requirement, is squarely yours.

Section 5

Data Migration

Data migration is the process of transferring data from external systems (legacy systems, databases) into Salesforce: importing, exporting, and updating data across environments. It matters because system upgrades demand it (moving from an on-premise CRM to Salesforce), consolidation demands it (merging customer data from multiple sources into a unified view), and data quality demands it (clean, accurate data for better decisions: the Module 8 theme again).

Three types:

  1. Full data migration: everything moves at once: typical of initial implementations.
  2. Incremental migration: data moves in smaller batches over time: typical of consolidations and staged upgrades.
  3. Ongoing synchronization: continuous syncing between Salesforce and external systems to maintain consistency: which is really an integration (below) wearing a migration hat.

Tools, in ascending capability: the Data Import Wizard (user-friendly, standard and custom objects, small-to-medium volumes), Data Loader (large volumes, bulk insert/update/delete/export: both covered hands-on in Module 8), and a third-party tool category for complex migrations and real-time needs: cloud migration platforms and web-based loaders. Names in this category change; evaluate current options when a project needs one.

The BA's migration duties are larger than they look: deciding what data moves (all of it? seven years of dead leads?), mapping source fields to target fields (a document only someone who understands both businesses can write), defining quality rules for cleansing before load, and planning validation after load (row counts, spot checks, stakeholder sign-off). Migration mapping workshops are among the most BA-intensive sessions in any implementation, and they lean on every data-model concept from Module 6.

Section 6

Integrations: APIs and Middleware

Almost no organization runs Salesforce alone. Integration is how Salesforce exchanges data and triggers behavior with everything else: the ERP, the website, the payment processor, the data warehouse.

APIs

An API (Application Programming Interface) enables different software systems to communicate: the driver of automation, integration, and business efficiency. Two API styles dominate integration conversations:

REST (Representational State Transfer)

REST (Representational State Transfer): lightweight and flexible, ideal for modern web and mobile applications. Its benefits: ease of integration (quick to implement, reducing time-to-market), scalability (handles high request volumes), flexible data formats (typically JSON or XML), and cost-effectiveness (lower overhead and maintenance). Typical use cases: customer-facing applications, third-party service integration (social media, payment gateways), cloud systems and microservices.

SOAP (Simple Object Access Protocol)

SOAP (Simple Object Access Protocol): protocol-based, robust, and secure: common in enterprise environments where consistency, security, and reliability are critical. Its benefits: strong built-in security standards (essential for financial and healthcare transactions), reliable transaction management (supporting ACID properties: atomicity, consistency, isolation, durability), and strict standardization that eases integration with legacy systems. Typical use cases: ERP systems, banking and insurance, regulated sectors like healthcare and government.

The BA-level decision heuristic hiding in those lists: modern,…

The BA-level decision heuristic hiding in those lists: modern, fast-moving, customer-facing integration leans REST; legacy, regulated, transaction-critical integration leans SOAP. You will not choose the protocol (architects do), but requirements you gather (data sensitivity, volumes, real-time versus batch, systems involved) drive their choice, so gather them deliberately.

Middleware

Middleware is software acting as a bridge between applications, facilitating communication, integration, and data flow. In Salesforce contexts, middleware connects the org with external systems (ERP, databases, third-party applications) so data exchanges reliably without every system needing to know about every other.

Categories to recognize (with a currency note: the vendor landscape shifts, so treat named examples as illustrations, not endorsements):

Common middleware use cases: ERP integration (orders, inventory, and financials synchronized between Salesforce and systems like SAP or Oracle), e-commerce integration (order and customer data flowing from storefront platforms), legacy system integration (bridging older systems without replacing them), and data warehousing (feeding Salesforce data into a central warehouse for advanced analytics).

When integration appears in discovery, the BA's questions are: which systems? which direction does data flow? how fresh must it be (real-time or nightly batch)? which system is the source of truth for each field? what happens when the other system is down? Those five questions, answered, are most of an integration requirement.

Section 7

A Brief Note on Delivery Tooling

Work-tracking and DevOps platforms (Azure DevOps, Jira, and similar) also touch configuration work: teams track configuration stories, test cases, and deployments in them. As Module 10 established, this course deliberately teaches the concepts rather than any tool's mechanics: firms configure and use these platforms in their own ways, and you will learn the local dialect in your first week. No further tooling detail is needed here.

Section 8

Pulling It Together: The Declarative-First Principle

A final mental model that makes everything in this module cohere. Salesforce solution design follows a preference order:

  1. Configure first (fields, layouts, apps, validation rules): fastest, cheapest, most maintainable
  2. Automate declaratively second (flows, approval processes): powerful without code
  3. Code third (Apex, custom components): when declarative tools genuinely cannot meet the need
  4. Integrate when the capability belongs in another system

As a BA you sit at the top of that funnel. The requirements you write, and the questions you ask ("must this be real-time?" "who approves?" "what happens on failure?"), determine how far down the funnel a solution must reach. Every notch deeper costs more to build and maintain. Requirements precision is cost control: one more reason the craft in Modules 3 and 4 pays for itself.

Recap

Key Takeaways

📝

Knowledge Check

8 questions. Answer at your own pace, then check the explanation for each.

Question 1 of 8
A stakeholder requires that no opportunity can be saved as Closed Won without an amount. Which tool most directly enforces this?
Correct answer: B. Validation rules conditionally prevent saves: policy, not suggestion, and they fire via API too.
Question 2 of 8
Which flow type fits: "guide support agents through a structured, multi-screen intake process"?
Correct answer: C. User interaction across screens is the definition of a screen flow.
Question 3 of 8
What is the correct current status of Workflow Rules and Process Builder?
Correct answer: B. Both are retired; Flow is the present and future, and migrating legacy automation is common project work.
Question 4 of 8
In an approval process, the "final rejection action" defines:
Correct answer: C. Approval actions define behavior at each juncture: submission, approval, rejection, recall.
Question 5 of 8
In the order-of-execution mnemonic "Very Angry Admins Work Pretty Efficiently," what runs first when a record is saved?
Correct answer: C. Validation rules run first: bad data is rejected before any routing or automation.
Question 6 of 8
SELECT Id, Name FROM Contact WHERE Email != '' retrieves:
Correct answer: B. SELECT names the fields, FROM the object, WHERE filters to contacts with a non-empty email.
Question 7 of 8
A client needs Salesforce and their SAP ERP to exchange order and inventory data reliably in both directions. Which category of solution is the architect most likely to propose?
Correct answer: B. Bi-directional ERP synchronization is the signature middleware use case.
Question 8 of 8
True or False: Because validation rules only apply in the user interface, integrations can bypass them.
Correct answer: False. Validation rules trigger all the time: UI, API, integrations, even on hidden fields. That reliability is exactly why they are used to enforce policy.
🎉

Module 11 complete

Nice work. Review any question again using the menu (top right), or move on.

Continue to Module 12: Testing & UAT →

1 / 1