Last Tuesday we held our first ever Informatica Cloud #TechTuesdays session, "Better Business Intelligence: Blazing Fast Data Replication for Cloud Apps".


We focused on how cloud applications such as Salesforce were built from the ground up to allow rapid customization, and as a result, contain numerous custom objects and custom fields. As a consequence, when extracting data from Salesforce into a staging database, it is important to ensure that all the changed fields have propagated their way into the relevant mappings for the business intelligence process.


The demo focused on four critical elements of a data replication process:


  • Replicating Deleted & Archived Rows
  • Auto-creation of Database Tables
  • “Full Load” vs. “Incremental Load”
  • Using the Salesforce Bulk API


Here are the slides from the session, and the entire recording featuring Ron Lunasin who heads our Cloud Platform Adoption team.


Session 2 takes place tomorrow, Tuesday, July 30th at 830am PDT and will focus on Big Data, specifically how to perform data warehousing through the cloud with Amazon RedShift.