RELATIONAL JUNCTION FOR SALESFORCE

Token Distribution

High Performance Bi-Directional Replication
for Data Warehouse, Data Integration, Backup & Recovery

Relational Junction for Salesforce is a scalable, reliable, high performance AppExchange-certified solution that has been supporting mission critical businesses needs in Fortune 500 companies since 2004. Relational Junction for Salesforce simplifies Salesforce data integration, offline reporting, and backup and recovery by creating and continuously synchronizing a local data warehouse that is a perfect mirror of your Salesforce.com site. All Salesforce.com objects are automatically created as tables, and all Salesforce.com fields created as database columns. Data model changes in Salesforce are automatically made in the database.

On-Premise & Cloud Deployment Options

Sesame Software offers on-premise and cloud-based backup solutions for Salesforce.com. Relational Junction for Salesforce supports not only backup and recovery, but also reporting from a relational database warehouse and SQL-based integration. Discover which deployment option best suits your business needs.

ON-PREMISE DEPLOYMENT FEATURES

  • Salesforce.com backup and recovery
  • Data warehouse for reporting
  • Data integration to cloud and on-premise data sources
  • Installation, initial configuration, and training included

CLOUD DEPLOYMENT FEATURES

  • Salesforce.com backup and recovery
  • Turnkey solution with no customer admin required
  • Sesame professional services for data recovery included
  • Daily email reports of backup activity

Relational Junction for Salesforce Features

  • Easily integrate with other applications by first bringing the data to a warehouse
  • Provides both integration and reporting capability
  • Enables offline reporting with any Business Intelligence or Analytics product
  • Improves reliability and performance of integration
  • Provides rapid development of integration with any ETL product,
    scripting, or SQL programming
  • No API programming
  • Enables legacy data migration
  • Bi-directional synchronization supports data imports and data recovery
  • Fully recover lost or corrupted data to any point-in-time
  • Supports custom objects and fields, including long text and attachments
  • Supports Oracle, SQL Server, Azure, MySQL, PostgreSQL, DB2, Informix, Sybase databases
  • Keeps your database schema in sync with your Salesforce site.
  • Replicate all new and modified data to the schema as often as five minutes, or use Real Time mode for selected objects.

SATISFY FEDERAL COMPLIANCE REGULATIONS

Relational Junction for Salesforce meets regulations for FINRA financial institutions, SEC Rule 17a for securities broker-dealers, and HIPAA / FDA regulations for healthcare organizations. Relational Junction for Salesforce requires full incremental backup of all sensitive data, all versions of all sensitive data are kept, and has the ability to recover deleted records, including parent-child relationships. Once-a-day backups DO NOT satisfy these requirements.

COMPLIANCE SOLUTION

Backup and recover your Salesforce data for any object. All records can be kept in the database allowing recovery to any point in time, and all database records are archived instead of being physically deleted. Bi-directional ability allows reloading of archived data to Salesforce with parent-child relationships intact. Relational Junction has the option to change history for all fields in all Salesforce objects, while native Salesforce.com history tracking can only capture 20 fields per object.

BUSINESS INTELLIGENCE & REPORTING

Improves reliability and performance of reporting. Sophisticated analysis of customer data can be done with reporting tools that go beyond native Salesforce.com reporting, including complex statistical and trending analysis, giving you the freedom to use any reporting or BI Products.

INTEGRATE TO OTHER DATABASES

Relational Junction allows you to integrate other back-office databases. Examples of this include maintaining customer and product data, integrating case management with bug tracking, as well as providing a customer portal.

LEGACY DATA MIGRATION

Migrate legacy data to your Salesforce org– Accounts, Contacts, Leads, Opportunities, Products, Documents, and Attachments – not limited to standard Salesforce uploads.

APPLICATION ENABLEMENT

Integrate customer & product data, as well as customer-facing or internal issue tracking. Real-time option enables immediate replication of all changes between Salesforce.com and the database.

Cross Platform Support for all Major Operating Systems and Databases

JAVA

Java provides complete cross-platform support for all UNIX 64-bit (Linux, Solaris, HP-UX, IBM, etc.) and Windows 64-bit platforms. Java is compiled once and will work on virtually all hardware platforms without the need for platform-specific modifications, meaning that all of our customers have the exact same distribution.

JAVA DATABASE CONNECTIVITY (JDBC)

Java Database Connectivity (JDBC) is an application programming interface (API) for Java, that defines how a client may access a database. Relational Junction‘s JDBC interface with drivers from database and third party vendors is what gives it the ability to access on-premise relational databases, cloud databases, unstructured data, and API-driven applications.

Relational Junction for Salesforce Features

Installation and creation of your warehouse takes minutes, and accepts all data types, custom objects, and custom fields. Our product offers bi-directional replication of all Salesforce data to a local database, with full automation of all Salesforce data model changes. RJ4SF uses structured single-pass loading of data to Salesforce with parent-child relationships, and timestamp-based incremental replication for lowest footprint. Replication can be both to and from your local database as often as every five minutes, and only copies the changes.
Relational Junction for Salesforce uses extensive failover – restart logic, and doesn’t require reloading entire table on failures. The replication process is automatically restartable at point of failure, and captures and logs rejected records. It reports extensive load statistics, allowing for immediate termination at point of failure or bypass error with error logging.
Relational Junction for Salesforce is a unique solution that does not have the scalability limitations of other replication products. Our patented technology segments data by time range to allow you to load unlimited amounts of data, both from and to Salesforce. Multi-threaded read-write processes give throughput of 3,000 to 6,000 records per second on large volumes of data. In use at Fortune 500 companies since 2004, Relation Junction for Salesforce is the most scalable and reliable solution available.

Find out how Relational Junction for Salesforce can help your business

Token Distribution
Token Distribution

High Performance Bi-Directional Replication
for Data Warehouse, Data Integration, Backup & Recovery

Relational Junction for Salesforce is a scalable, reliable, high performance AppExchange-certified solution that has been supporting mission critical businesses needs in Fortune 500 companies since 2004. Relational Junction for Salesforce simplifies Salesforce data integration, offline reporting, and backup and recovery by creating and continuously synchronizing a local data warehouse that is a perfect mirror of your Salesforce.com site. All Salesforce.com objects are automatically created as tables, and all Salesforce.com fields created as database columns. Data model changes in Salesforce are automatically made in the database.

On-Premise & Cloud Deployment Options

Sesame Software offers on-premise and cloud-based backup solutions for Salesforce.com. Relational Junction for Salesforce supports not only backup and recovery, but also reporting from a relational database warehouse and SQL-based integration. Discover which deployment option best suits your business needs.

ON-PREMISE DEPLOYMENT FEATURES

  • Salesforce.com backup and recovery
  • Data warehouse for reporting
  • Data integration to cloud and on-premise data sources
  • Installation, initial configuration, and training included

CLOUD DEPLOYMENT FEATURES

  • Salesforce.com backup and recovery
  • Turnkey solution with no customer admin required
  • Sesame professional services for data recovery included
  • Daily email reports of backup activity

Relational Junction for Salesforce Features

  • Easily integrate with other applications by first bringing the data to a warehouse
  • Provides both integration and reporting capability
  • Enables offline reporting with any Business Intelligence or Analytics product
  • Improves reliability and performance of integration
  • Provides rapid development of integration with any ETL product,
    scripting, or SQL programming
  • No API programming
  • Enables legacy data migration
  • Bi-directional synchronization supports data imports and data recovery
  • Fully recover lost or corrupted data to any point-in-time
  • Supports custom objects and fields, including long text and attachments
  • Supports Oracle, SQL Server, Azure, MySQL, PostgreSQL, DB2, Informix, Sybase databases
  • Keeps your database schema in sync with your Salesforce site.
  • Replicate all new and modified data to the schema as often as five minutes, or use Real Time mode for selected objects.

SATISFY FEDERAL COMPLIANCE REGULATIONS

Relational Junction for Salesforce meets regulations for FINRA financial institutions, SEC Rule 17a for securities broker-dealers, and HIPAA / FDA regulations for healthcare organizations. Relational Junction for Salesforce requires full incremental backup of all sensitive data, all versions of all sensitive data are kept, and has the ability to recover deleted records, including parent-child relationships. Once-a-day backups DO NOT satisfy these requirements.

COMPLIANCE SOLUTION

Backup and recover your Salesforce data for any object. All records can be kept in the database allowing recovery to any point in time, and all database records are archived instead of being physically deleted. Bi-directional ability allows reloading of archived data to Salesforce with parent-child relationships intact. Relational Junction has the option to change history for all fields in all Salesforce objects, while native Salesforce.com history tracking can only capture 20 fields per object.

BUSINESS INTELLIGENCE & REPORTING

Improves reliability and performance of reporting. Sophisticated analysis of customer data can be done with reporting tools that go beyond native Salesforce.com reporting, including complex statistical and trending analysis, giving you the freedom to use any reporting or BI Products.

INTEGRATE TO OTHER DATABASES

Relational Junction allows you to integrate other back-office databases. Examples of this include maintaining customer and product data, integrating case management with bug tracking, as well as providing a customer portal.

LEGACY DATA MIGRATION

Migrate legacy data to your Salesforce org– Accounts, Contacts, Leads, Opportunities, Products, Documents, and Attachments – not limited to standard Salesforce uploads.

APPLICATION ENABLEMENT

Integrate customer & product data, as well as customer-facing or internal issue tracking. Real-time option enables immediate replication of all changes between Salesforce.com and the database.

Cross Platform Support for all Major Operating Systems and Databases

JAVA

Java provides complete cross-platform support for all UNIX 64-bit (Linux, Solaris, HP-UX, IBM, etc.) and Windows 64-bit platforms. Java is compiled once and will work on virtually all hardware platforms without the need for platform-specific modifications, meaning that all of our customers have the exact same distribution.

JAVA DATABASE CONNECTIVITY (JDBC)

Java Database Connectivity (JDBC) is an application programming interface (API) for Java, that defines how a client may access a database. Relational Junction‘s JDBC interface with drivers from database and third party vendors is what gives it the ability to access on-premise relational databases, cloud databases, unstructured data, and API-driven applications.

Relational Junction for Salesforce Features

Installation and creation of your warehouse takes minutes, and accepts all data types, custom objects, and custom fields. Our product offers bi-directional replication of all Salesforce data to a local database, with full automation of all Salesforce data model changes. RJ4SF uses structured single-pass loading of data to Salesforce with parent-child relationships, and timestamp-based incremental replication for lowest footprint. Replication can be both to and from your local database as often as every five minutes, and only copies the changes.
Relational Junction for Salesforce uses extensive failover – restart logic, and doesn’t require reloading entire table on failures. The replication process is automatically restartable at point of failure, and captures and logs rejected records. It reports extensive load statistics, allowing for immediate termination at point of failure or bypass error with error logging.
Relational Junction for Salesforce is a unique solution that does not have the scalability limitations of other replication products. Our patented technology segments data by time range to allow you to load unlimited amounts of data, both from and to Salesforce. Multi-threaded read-write processes give throughput of 3,000 to 6,000 records per second on large volumes of data. In use at Fortune 500 companies since 2004, Relation Junction for Salesforce is the most scalable and reliable solution available.

Find out how Relational Junction for Salesforce can help your business

Token Distribution