Replicate Your Salesforce Data For Better Business Intelligence

Replicate Your Salesforce Data For Better Business Intelligence

CloudReplicate is now available! Cool name, but what does it do? CloudReplicate is a turnkey solution that provides real-time synchronization of cloud application data to Amazon EC2 for The Big Three R’s: Retrieval, Retention, and advanced Reporting.

CloudReplicate is the umbrella name for a planned suite of solutions aimed at the most popular cloud applications. The first one on tap, and available as of this morning, is CloudReplicate for Salesforce.

Salesforce is with good reason the most popular SaaS/cloud application/platform out there, so it seemed a good place to start. On the Sales Cloud 2 side of things, salesforce.com offers great tools for organizing and managing your most important asset – your customer data. The tools are easy to use because Salesforce abstracts a lot of the complexity of the data through their presentation layers and custom Salesforce Object Query Language (SOQL).

The flipside of this simplicity is in some cases a dearth of desired complexity when it comes to reporting. Salesforce provides great basic reports, but what do you do when you want to go deeper and apply multi-dimensional analysis to your customer data? What if you want to mix and match your customer data with organizational data stored in other databases and systems? What if you want to use your own on-premise or cloud business intelligence tools on your data inside Salesforce? None of this is an option natively within your Salesforce org.

This is where CloudReplicate comes in. The flavor announced today is housed on Amazon’s Elastic Compute Cloud (EC2) and can, in a matter of hours, mirror all of your Salesforce data into the relational database of your choice – all running in the cloud. Right now you can choose between mySQL, SQL Server or Oracle, but the real key is that your data will now reside in a relational database that can be accessed with standard SQL. This is a big deal because this data can then be accessed with your BI tool of choice, from Excel to Business Objects to PivotLink. And because it’s stored relationally, you can run all matter of multi-dimensional analysis on the data.

Beyond dramatically improved reporting, CloudReplicate also provides more obvious benefits such as retrieval and retention. Whether its concerns about reliability or security, or the more real issue of storage costs, replicating your data gives you full control of your customer data. You have a back up that you can access at any time and you can store historical data that would otherwise cost you a bundle to archive.

The killer app for CloudReplicate is the fact that it will automatically update and mirror any changes you make to your Salesforce org (including new custom objects) inside of your Amazon data warehouse. Another benefit of this feature is that you can choose to have CloudReplicate retain all data on your Amazon data warehouse even if you delete the data or object within Salesforce. In this way you can keep your org efficient and streamlined while ensuring that you’ve retained all data for historical purposes.

This is just the tip of the iceberg. As you can imagine, with your data available in such an easily accessible manner, there’s no limit to what you can do with it to improve the efficiency of your business.

If you want to learn more about CloudReplicate or get some more in-depth case studies on how some of our customers are currently taking advantage of this solution, drop us a line. You can also check out our newCloudReplicate webpage. If you happen to be attending Dreamforce next week (Dec 6-9, 2010), drop by booth #1106 to see a demo.