Sesame Software’s patented technology sets the industry standard for Enterprise Data Management. Sesame Software’s Relational Junction is a multifaceted solution stack that combines replication, ETL, data warehousing, SaaS integration, as well as complete backup and recovery capabilities to cover all of your data needs.
Sesame Software provides connectors 100+ different SaaS applications including Salesforce, Oracle, MS Dynamics, Snowflake, NetSuite, Marketo, Pardot, as well as any relational database. On-premise or in the Cloud.
DATA PIPELINES MADE EASY
Quickly and efficiently replicate data into the data warehouse of your choice.
ACCELERATED INSIGHTS
Get your pipeline in minutes, not months. Providing rapid delivery of your data for reporting and analytics.
HASSLE FREE DEPLOYMENT
Deploy maintenance-free data pipelines powered by intuitive and scalable computing. No coding needed. Leverages existing database skills. Learn the entire product in an hour.
EFFICIENT SCHEMAS
Ready-to-query schemas that give you all the data you need. No duplicates.
FAST & EASY INTEGRATION
Connect SaaS, on-premise and cloud applications using powerful SQL interface.
SEAMLESS CONNECTORS
Rapidly connect to 100+ data sources including Salesforce, Oracle, Snowflake, MS Dynamics, NetSuite, Pardot, and any relational database.
PATENTED TECHNOLOGY
Patented hyper-threaded technology scales to hundreds of millions of records for fastest possible data movement.
COMPLETE BACKUP & RECOVERY
Backup and recover your data without the use of CSV. files. Restore the lost data caused by human errors, malicious insiders or errors in automated scripts.
FULL COMPLIANCE
Fully compliant with industry mandates. HIPAA, Sarbanes Oxley, SEC Rule 17A, GDPR, FINRA.
Sesame Backup and Recovery for Salesforce
Sam F.
Advanced user of Sesame Backup and Recovery for Salesforce
★★★★★
RelationalJunction is the perfect tool for raw data backup and syncronization
What do you like best?
Very little configuration is needed to replicate all Salesforce data to a local SQL server. Custom objects added in Salesforce are automatically added as new tables in the replicated database. Custom fields added in Salesforce are automatically added as new columns in the replicated database.
Configuration files make it easy to configure replication, such as excluding certain objects, how often to replicate each object, etc.
Logs are very verbose. They can be very long, but when something isn't working right, they are very helpful in figuring out exactly what is causing the problem.
Records that are deleted in Salesforce stay in the replicated database forever.
Two way replication is easy. Records can be inserted or changed locally and uploaded to Salesforce simply by flagging the new or updated rows with an 'I' or 'U'. You can also delete records by flagging them with a 'D'.
Besides a browser based user interface, it also has a command line interface. Those familiar with the command line will appreciate the ability to run any task from the command line.
What do you dislike?
If a field type is changed in Salesforce (like from an integer to a text field), Relational Junction will not automatically change the column in the local database. Instead, the replication script will fail until the column is fixed. To do this, you have to delete the column, then run some commands to have Relational Junction add the column again with the correct data type.
Recommendations to others considering the product:
If you just want raw data, RelationalJunction is easy to use and fully functional. If you need ETL tools, and the ability to manage what data gets replicated where, this tool will not do it for you.
What problems are you solving with the product? What benefits have you realized?
Relational Junction provides is with a local backup of all of our Salesforce data. Reporting on Salesforce data is also faster and easier when the data is in a local database.
Review source: G2.com
