In addition to a high-frequency replication rate, data security and control were also paramount. To start, the organization wanted full transparency into the entire data flow from the initial extract from Salesforce to the final replication to Tableau. Salesforce contained sensitive data that needed to be kept internal and not exposed beyond the company’s firewall. The organization also wanted sales and service teams to have visibility into the visualizations created in Tableau without leaving the Salesforce platform.
CapStorm’s CS:Enable product, powered by CapStorm’s CopyStorm application, provided a fully incremental replication of the Salesforce’s data and structure into the organization’s self-hosted SQLServer database. Correspondingly, changes to the underlying Salesforce structure, such as new objects and fields, would be automatically reflected in the database. Moreover, each data extract focused on primarily pulling new or modified records from Salesforce. As a result, CapStorm enabled the company to minimize the number of API call resources used and allowed the data extract to run frequently, resulting in data availability for analytics within minutes of data creation.
Salesforce data stays at rest behind the company’s firewall in the company’s databases. As a result, the organization gained complete control over who accessed the data and how they used it. Simple queries to SQLServer generated targeted data views that are then connected to Tableau, resulting in segmented data control. This approach, coupled with CopyStorm’s incremental schema replication, allowed the business to increase the data available for analytics on demand and in near real-time.
Tableau Viz Lightning Web Components embedded Tableau visualizations into the Salesforce environment, giving sales and support leaders a reason to stay on-platform and provided a single source of truth for data and analytics. This approach enabled citizen development with self-serve business intelligence, reducing the IT burden and increasing enterprise data sharing.