Developing Data Migrations and Integrations with Salesforce : Patterns and Best Practices /: Patterns and Best Practices. ([2019])
- Record Type:
- Book
- Title:
- Developing Data Migrations and Integrations with Salesforce : Patterns and Best Practices /: Patterns and Best Practices. ([2019])
- Main Title:
- Developing Data Migrations and Integrations with Salesforce : Patterns and Best Practices
- Further Information:
- Note: David Masri.
- Authors:
- Masri, Daṿid
- Contents:
- Intro; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Chapter 1: Relational Databases and Normalization; What Is a Relational Database?; Entity Relationship Diagrams; Trading Write Speed for Read Speed; Summary Tables; Structured Query Language; Relational Database Management Systems; The Binary Search Algorithm; Summary; Chapter 2: Understanding Salesforce's Data Architecture; Salesforce Database Access; SQL vs. SOQL and the Data APIs; DDL vs. Metadata API; Data Types for Type Enforcement and UI Rendering; Picklists vs. Reference Tables Lookups and Master DetailStorage Costs; Rollups, Formula Fields, and Views; CRUD Fields; Triggers, Validation Rules, Workflows, and Process Builders; Record Locking; Indexes; Salesforce Data Types; Lookups/Master Detail; Lookup Relationship; Master-Detail Relationship; Record Types; Fifteen- and 18-Character Ids; AutoNumber; Check Box; Currency; Date; Date/Time; Time (Beta); E-mail; Geolocation; Name; Number; Percentage; Phone; Picklist; Multiselect Picklist; Text; Text Area; Text Area (Long); Text Area (Rich); Text Encrypted; URL; Formula Fields; Rollups; Owner Id; Address Revisiting our Superhero Data ModelSummary; Chapter 3: Working the Salesforce Data APIs; API Limits; Third-Party ETL Tools and Middleware; Apex Data Loader; Informatica; SQL Server Integration Services (SSIS); Azure Data Factory; MuleSoft; DBAmp; Relational Junction; Dell's Boomi; Jitterbit; dataloader.io; Scribe; OpenIntro; Table of Contents; About the Author; About the Technical Reviewer; Acknowledgments; Introduction; Chapter 1: Relational Databases and Normalization; What Is a Relational Database?; Entity Relationship Diagrams; Trading Write Speed for Read Speed; Summary Tables; Structured Query Language; Relational Database Management Systems; The Binary Search Algorithm; Summary; Chapter 2: Understanding Salesforce's Data Architecture; Salesforce Database Access; SQL vs. SOQL and the Data APIs; DDL vs. Metadata API; Data Types for Type Enforcement and UI Rendering; Picklists vs. Reference Tables Lookups and Master DetailStorage Costs; Rollups, Formula Fields, and Views; CRUD Fields; Triggers, Validation Rules, Workflows, and Process Builders; Record Locking; Indexes; Salesforce Data Types; Lookups/Master Detail; Lookup Relationship; Master-Detail Relationship; Record Types; Fifteen- and 18-Character Ids; AutoNumber; Check Box; Currency; Date; Date/Time; Time (Beta); E-mail; Geolocation; Name; Number; Percentage; Phone; Picklist; Multiselect Picklist; Text; Text Area; Text Area (Long); Text Area (Rich); Text Encrypted; URL; Formula Fields; Rollups; Owner Id; Address Revisiting our Superhero Data ModelSummary; Chapter 3: Working the Salesforce Data APIs; API Limits; Third-Party ETL Tools and Middleware; Apex Data Loader; Informatica; SQL Server Integration Services (SSIS); Azure Data Factory; MuleSoft; DBAmp; Relational Junction; Dell's Boomi; Jitterbit; dataloader.io; Scribe; Open Database Connectivity Drivers; The Salesforce Recycle Bin and Data Archiving; The Salesforce Recycle Bin; Data Archiving; API Operations; Export; Export All; Insert; Update; Upsert; Delete; Hard Delete; Undelete; Merge; Let's Give It a Try!; Developer Accounts and Sandboxes Log in SalesforceGenerate a Token; Download and Install Apex Data Loader; Apex Data Loader Settings/API Options; Create an External Id; Upsert Accounts; Upset Opportunities; Export Data; Browse through Your data with Workbench and SOQL; Summary; Chapter 4: The Six Attributes of a Good Data Migration; Attribute 1: Well Planned; Attribute 2: Automated (Redoable); Attribute 3: Controlled; Attribute 4: Reversible; Attribute 5: Repairable; Attribute 6: Testable; QA: Testing to Specification; UAT: Testing for Intent; Summary: A Reminder; Chapter 5: Attributes of a Good Data Integration Self-repairingPlanning Differences; Deployment; Long-term Support; Summary; Chapter 6: Best Practices for Migrating and Integrating Your Data with Salesforce; Best Practice 1: Have a Plan; Best Practice 2: Review Your Charter and Understand Your Scope; Best Practice 3: Partner with Your PM; Best Practice 4: Start Early; Best Practice 5: Understand the Source Data, Ask Questions to Understand Intent, Analyze Data to Know the Reality; Best Practice 6: Understand the Salesforce Data Model and the Hierarchy; Best Practice 7: Document Your Transformations … (more)
- Publisher Details:
- Berkeley, CA : Apress L. P
- Publication Date:
- 2019
- Extent:
- 1 online resource
- Subjects:
- 005.74
Salesforce (Online service)
Database management
Electronic books - Languages:
- English
- ISBNs:
- 9781484242094
1484242092 - Related ISBNs:
- 9781484242087
1484242084 - Notes:
- Note: Description based on online resource; title from digital title page (viewed on January 29, 2019).
- Access Rights:
- Legal Deposit; Only available on premises controlled by the deposit library and to one user at any one time; The Legal Deposit Libraries (Non-Print Works) Regulations (UK).
- Access Usage:
- Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force.
- View Content:
- Available online (eLD content is only available in our Reading Rooms) ↗
- Physical Locations:
- British Library HMNTS - ELD.DS.381754
- Ingest File:
- 02_364.xml