Legal Services Provider Finds Sesame Software Essential for Reporting/Analytics That Yield Actionable Business Intelligence

Santa Clara, CA, March 20, 2018 – Esquire Deposition Solutions, a nationwide leader in court reporting and other legal support services, relies on a company data warehouse for virtually every part of its business, from financials and sales, to customer retention and business planning.  

While it uses one of the leading cloud-based CRM platforms for most of these business functions, Esquire found it needed more from its database and turned to Silicon Valley-based Sesame Software and its Relational Junction suite of replication, reporting and ETL tools for the solution.

“Our biggest issue is reporting,” says Esquire CIO Jim Ballowe: “With the full volume of data available through Sesame Software’s Relational Junction, we’re able to build cubes and use analytical services and deliver business intelligence and reports that are far richer.”

Using a local server and Relational Junction for data analytics also helped Esquire when it later added a second major CRM provider, enabling the company to correlate data between the two platforms. “Every aspect of the business relies on the business intelligence that comes out of the data warehouse,” Ballowe says.

Sesame Software also features a world-class support team that Ballowe says has helped quickly pinpoint any potential issues so Esquire, Sesame Software and their cloud-based CRM platform partners can work together on specific remedies.

For a look at how Relational Junction enables Esquire Deposition Solutions to get more robust reporting and generate actionable business intelligence out of their cloud-based CRM platforms, visit Sesame Software online and download the case study at

Or call Sesame Software at +1 (408) 550-7999 to set up a demonstration of Relational Junction and learn how to get the most out of your data warehouse.   


About Sesame Software

Headquartered in Santa Clara, CA, Sesame Software is an Enterprise Application Integration/Data company whose Relational Junction products offer superior solutions for data integration, complete data recovery and data warehousing.

Media Contact:
Crystal Duarte
Chief Marketing Officer
Sesame Software
Tel:  408-838-8972   


How does your traditional .CSV business continuity solution compare to a near-real time self-replicating database backup of your data? It is always best to do this analysis in advance before you have an interruption in service.

With Relational Junction for Salesforce, you are protected from unforeseen risk. It is is the only solution that enables you to keep a near-real time self-replicating database backup of your data on-premise, which can always be used for reporting, analytics, and data recovery.

Don’t skip a beat! Relational Junction for Salesforce keeps you in sync and ready for your sales and executive meetings by integrating with your existing business reporting, data analytics and iPaaS integration tools.

Learn more about how hundreds of Relational Junction for Salesforce customers have peace of mind knowing their data is backed up, fully recoverable, and easily accessible in the event of an outage or any other data loss crisis.

Don't wait until you NEED your data to discover the limitations of your current solution!

Sesame Software hosts a booth at the Dreamforce 2017 show in San Francisco, CA. Showcasing our product line, and presenting a live demonstration by our CRO, Howard Vogel. 

Automated Data Warehouse Capabilities for over 90 Data Sources

SANTA CLARA, Calif.Sept. 18, 2017 /PRNewswire/ — Santa Clara, CA-based Sesame Software today announced its Beta Program for its new Relational Junction Data Warehouse Builder, featuring automated data warehouse design and data replication of all data, including SaaS data, regardless of whether it’s stored in the Cloud or on local servers.

Relational Junction Data Warehouse Builder has its roots in Relational Junction for Salesforce, which builds a data warehouse of your data in an on-premise relational database. Bi-directional replication provides the capabilities of loading data to Salesforce and recovering data from historical versioned backups to any point in time. Sesame is extending the data warehouse capabilities to nearly ninety new data sources, including traditional relational databases, many cloud application vendor products, and non-relational data sources. The first release will add warehouse builder capabilities to relational databases. Future releases will include Big Data warehouses as the target. Relational Junction Data Warehouse Builder will automate the creation of the target data warehouse schema and auto-discovery of new fields and tables or objects in the source system.

Prospective customers can sign up for the beta program at

About Sesame Software
Headquartered in Santa Clara, CA, Sesame Software is an Enterprise Application Integration/Data company whose Relational Junction products offer superior solutions for data integration, complete data recovery and data warehousing.

Media Contact:
Crystal Duarte
Chief Marketing Officer
Sesame Software
Tel:  408-838-8972                                                                                                        


SOURCE Sesame Software, Inc.

Related Links

Relational Junction will work on any web application server, including WebLogic, if the app server supports Java 1.8. Nearly all of our customers use Tomcat, since it provides all the services required for the web administration without any licensing costs. Relational Junction is primarily a batch system. You can fire off jobs in the web user interface, but stopping Tomcat does not kill the jobs. It is far better to have  a dedicated server for Relational Junction, because of the batch orientation, than use a web application server with many other transactional applications running.

Yes, but it would be naive to think that it doesn’t require carefully though out decisions and preparations to make so the new records fit into the target org, such as

  • Is the target org empty or does it contain existing users, products, and other slowly changing data? On professional service engagements, our team has used mapping tables to marry up the business keys in the source or with the target records by their Salesforce ID in the target org. Unique business keys are required to make this work smoothly.
  • How do you want to detect and handle duplicates? If you are merging business units, how do you determine if you have a common customer and which record “wins” in that event?

Yes. There is a button you can press in the user interface that will gracefully cancel any job with full two-phase of all transactions in Salesforce and status flags in the database. This makes restores fully restartable without creating duplicates in Salesforce.

We do not create foreign key constraints because it would prevent copying records if they were done out of order, as you would get constraint violations if the child was copied before the parent. Also, some of the relationships (such as the ParentID of Attachment) point to multiple objects.

Yes. The relationship fields are stored in the database. When records are restored, the relationship fields are updated for all the child records as the parent records get new Salesforce ID’s. This is a patented process that allows one-pass restore of related data, including recursive relationships.

Contact.AccountID –> Account.ID

Contact.ReportsToID — Contact.ID

Even multi-level relationships are supported (Account1 has Contact1 as its child, which has Account2 as its child in a custom relationship).

There is no limit. We have customers with terabytes of data.

Relational Junction uses patented and patent-pending technology to limit queries to manageable sizes, preventing fatal timeouts and staying within limits of the Salesforce API. Performance of the product is an order of magnitude faster than the Salesforce Bulk API and does not require intermediate landing files.