Migrate your data to Salesforce and build low-maintenance and high-performing data integrations to get the most out of Salesforce and make it a "go-to" place for all your organization's customer information.

When companies choose to roll out Salesforce, users expect it to be the place to find any and all Information related to a customer―the coveted Client 360° view. On the day you go live, users expect to see all their accounts, contacts, and historical data in the system. They also expect that data entered in other systems will be exposed in Salesforce automatically and in a timely manner.

This book shows you how to migrate all your legacy data to Salesforce and then design integrations to your organization's mission-critical systems. As the Salesforce platform grows more powerful, it also grows in complexity. Whether you are migrating data to Salesforce, or integrating with Salesforce, it is important to understand how these complexities need to be reflected in your design.Developing Data Migrations and Integrations with Salesforce covers everything you need to know to migrate your data to Salesforce the right way, and how to design low-maintenance, high-performing data integrations with Salesforce. This book is written by a practicing Salesforce integration architect with dozens of Salesforce projects under his belt. The patterns and practices covered in this book are the results of the lessons learned during those projects.

What You’ll Learn

• Know how Salesforce’s data engine is architected and why
• Use the Salesforce Data APIs to load and extract data
• Plan and execute your data migration to Salesforce
• Design low-maintenance, high-performing data integrations with Salesforce
• Understand common data integration patterns and the pros and cons of each
• Know real-time integration options for Salesforce
• Be aware of common pitfalls
• Build reusable transformation code covering commonly needed Salesforce transformation patterns

Who This Book Is For

Those tasked with migrating data to Salesforce or building ongoing data integrations with Salesforce, regardless of the ETL tool or middleware chosen; project sponsors or managers nervous about data tracks putting their projects at risk; aspiring Salesforce integration and/or migration specialists; Salesforce developers or architects looking to expand their skills and take on new challenges

Table of Contents

Chapter 1: Relational Databases and Normalization

Chapter 2: Understanding Salesforce's Data Architecture

Chapter 3: Working the Salesforce Data APls

Chapter 4: The Six Attributes of a Good Data Migration

Chapter 5: Attributes of a Good Data Integration

Chapter 6: Best Practices for Migrating and Integrating Your Data with Salesforce

Chapter 7: Putting It All Together: A Sample Data Migration

Chapter 8: Error Handling and Performance Tuning

Chapter 9: Data Synchronization Patterns

Chapter 10: Other Integration Patterns

Chapter 11: Real-Time Data and UI Integrations

Chapter 12: A Library of Reusable Code

Chapter 13: FAQs (aka Frequently Asked Questions)

Appendix A: A Simple Duplicate Detection Algorithm

Appendix B: Reference Cards and Core Concepts

Appendix C: Further Reading and References

About the Author

David Masri is the Director of Professional Services at Plative a Salesforce Silver Partner. Before joining Plative he was the Technical Director of Data Strategy and Architecture for Capgemini Invent's Salesforce Practice. He has over 20 years of hands-on experience building integrated ERP, BI, e-commerce, and CRM systems, with the last five years working exclusively with the Salesforce platform. He holds over 10 professional certifications, including 9 Salesforce certifications, the PMP, and Google's Data Engineer certification. David has been involved in dozens of Salesforce migration and integration projects and has used that experience to run numerous training programs for aspiring Integration/Migration specialists.

David is a lifelong New Yorker, born and raised in Brooklyn NY, where he currently lives with his loving wife Nancy and their kids Joey, Adam, Ally and Lilly. When he is not fighting with his kids over homework, he takes what little time he has left to sleep.