Overview
What is Relational Junction?
Sesame Software in Santa Clara invites businesses to protect and integrate your valuable corporate data with their flagship Relational Junction suite of Enterprise Application Integration products. Sesame Software provides solutions for over 100 different SaaS applications including Salesforce and NetSuite.
Product Details
- About
- Integrations
- Competitors
- Tech Details
- Downloadables
What is Relational Junction?
Relational Junction from Sesame Software centralizes business data with maintenance-free automated data connectors, and combines data warehousing, replication, integration, and compliance capabilities, providing real-time connectivity across SaaS, on-premise, and cloud applications.
Relational Junction Reduces Customer’s Project Time
- Up and running in an hour with no coding, data mapping, or maintenance is required
- Can handle a large amount of enterprise data
- Can scale and utilize other data connector options in the future
- Unifies data into a data warehouse of choice to destroy data silos
Use and Move Data When and Where Desired
- Can replicate data into a data warehouse of choice
- Connects to any on-premise or cloud enterprise application or database
- Pipelines provide rapid delivery of data for reporting and analytics
- Ready-to-query schemas that provide needed data with no duplicates
Protects Data
- Backup data without the use of .CSV files
- Salesforce data backup and recovery to eliminate data loss, support regulatory compliance, and build business resiliency
- Compliant with industry mandates such as HIPAA, Sarbanes Oxley, SEC Rule 17A, GDPR, FINRA
Relational Junction Features
Data Source Connection Features
- Supported: Connect to traditional data sources
- Supported: Connecto to Big Data and NoSQL
Data Transformations Features
- Supported: Simple transformations
- Supported: Complex transformations
Data Governance Features
- Supported: Integration with data quality tools
- Supported: Integration with MDM tools
Relational Junction Screenshots
Relational Junction Videos
Relational Junction Integrations
Relational Junction Competitors
Relational Junction Technical Details
Deployment Types | On-premise, Software as a Service (SaaS), Cloud, or Web-Based |
---|---|
Operating Systems | Windows, Linux, Mac |
Mobile Application | No |
Relational Junction Downloadables
Relational Junction Customer Size Distribution
Consumers | 0% |
---|---|
Small Businesses (1-50 employees) | 20% |
Mid-Size Companies (51-500 employees) | 40% |
Enterprises (more than 500 employees) | 40% |
Comparisons
Compare with
Reviews
Community Insights
- Business Problems Solved
- Pros
- Cons
- Recommendations
Relational Junction has proven to be a valuable tool for users, allowing them to seamlessly keep their data in sync with Salesforce, ensuring that their Salesforce data is always up-to-date. Users have found the installation and setup process to be generally good, although ongoing support response can sometimes be challenging. Despite being considered an expensive tool, customers who have been using Relational Junction for several years appreciate its stability and ability to meet their needs. They also value the excellent customer support provided by the knowledgeable support team of Relational Junction.
Relational Junction offers a range of key use cases that have helped users streamline their data integration processes. These use cases include metadata and data backup, data synchronization between in-house databases and Salesforce, SFDC data replication and updates, integration between cloud and database environments without requiring programming, data integration between databases and Salesforce, as well as syncing SQL tables with Salesforce.com.
Users rely on Relational Junction for various purposes such as integrating data between a data warehouse and Salesforce, enabling quick and easy access to combined data for reporting purposes. The software is also used to process feeds from multiple sources, allowing timely reporting on Salesforce data combined with other internal system data. Moreover, users appreciate that Relational Junction provides a local backup of all Salesforce data, which not only improves reporting speed but also facilitates easier search and recovery compared to the native Salesforce export feature.
Additionally, Relational Junction facilitates seamless ETL transitions, making it easier for users to manage their data flows without needing to build their own SSIS environment. The software's ability to bridge the gap between Salesforce and general-purpose databases has made a significant difference for users by enhancing accessibility and manipulation of Salesforce data in relational databases.
Overall, customers have had a positive experience with Relational Junction over the years and continue to rely on it for various critical tasks such as custom reporting, ad hoc data mining, generating reports and analysis based on key performance indicators and financial performance across multiple record types, as well as simplifying and organizing data migration efforts.
Highly Configurable: Many users have praised the software for its high level of configurability, allowing them to have granular control over the synchronization process between Salesforce and their database. This customization includes selecting which fields are synced, the direction of synchronization, and the frequency of synchronization. The ability to manipulate data in the database and sync it back to Salesforce easily further enhances the extensive customization options offered by the software.
Efficient Data Access and Backup: Users appreciate that the software provides direct access to NetSuite data in raw form, which they find quicker and more flexible compared to using the NetSuite API. Additionally, the software's ability to back up all NetSuite objects and data into a relational database is highly valued as it aids in reporting and disaster recovery compliance. These features demonstrate that the software offers efficient data access capabilities and reliable backup solutions for NetSuite users.
Robust Synchronization Features: Reviewers have highlighted how well the software keeps their downstream database synchronized with their Salesforce environment. They also appreciate features such as history tracking, logs, and record deletion capabilities provided by the software. These robust synchronization features, coupled with comprehensive data management tools and auditing capabilities, ensure smooth data synchronization processes for users.
-
Error handling and technical difficulties: Numerous users have encountered errors and faced difficulties when dealing with complex data in the sesame software. The error handling capabilities of the software have been criticized for being inadequate, causing frustration among users.
-
Limited ETL capabilities: Some reviewers have expressed disappointment with the limited extract, transform, load - ETL capabilities of the software. Specifically, they mentioned that there is a lack of a user interface - UI for the Unix platform, making it challenging to perform certain tasks related to data integration.
-
Difficulty in setup and configuration: Several users have found the initial setup and configuration process for the sesame software to be time-consuming and requiring significant effort. Additionally, some setup instructions were unclear and not straightforward, leading to confusion among users during this stage of implementation.
Users have made the following recommendations based on their experiences with the tool:
Users recommend using the tool as soon as possible due to its ability to review and manage duplicated data between Salesforce and other systems. The tool is considered a great solution for Salesforce integration, with a great price point and ease of use. Users also highlight the power and flexibility of the tool, as well as the outstanding support provided by the company.