Customer Case Study: Cisco Systems

Challenge

  • Was using Salesforce.com DB Replicator tool for mission critical reporting warehouse. DB Rep does not support current API and was discontinued in Jan 2006. DBRep also will not handle tables with millions of rows, since it is subject to timeouts with large datasets on the initial load.
  • Internal development and integration teams needed multiple sand box environments with monthly refresh.

Solution

  • Relational Junction
  • Salesforce.com data replication to Oracle database for reporting and various integration projects.
  • Relational Junction used to build a second Salesforce.com org for integration team. Sesame developed new features in the product to support an org clone process that will copy 10 GB in 2 days.

 

Results

  • Consistent and current view of Salesforce data for reporting
  • Integration developers have their own Salesforce.com site
  • Stable, supported, scalable solution