Relational Junction for Salesforce
Achieve location based regulatory compliance and near real-time insights.
Key Features of Relational Junction
Relational Junction is a comprehensive Salesforce solution that eliminates data silos, minimizes data loss, meets retention and location based compliance regulations, and builds business resiliency.
All-In-One Solution for Salesforce
Relational Junction combines data warehousing, integration, replication, and compliance to cover all of your Salesforce data needs.
Data Warehouse
Fully automated data warehouse that is a mirror of your both your production and sandbox environments.
Data Replication
Deliver a full copy of your data in near real-time for accelerated reporting and analytics.
Data Backup & Restore
Continuous daily backups and complete restoration of your data at any scale and level of granularity.
Data Archive
Automatic data extraction for any managed packages or applications, one-time or trickle feed.
Bidirectional Integration
Data integration and synchronization that scales as your data grows – capturing information that is constantly changing.
Data Recovery
On-demand recovery of your content document, attachments, custom objects, related records, and more.
Eliminate Data Silos
Connect Salesforce Anytime, Anywhere
Connect and unify all of your Salesforce data to the destination of your choice for a complete view of your critical business data across your entire organization.
Keep Your Salesforce Data Fresh
Keep data fresh and simplify reporting by creating and continuously synchronizing a local data warehouse that mirrors your Salesforce instances, including sandboxes.
Near Real-Time Data, On Demand
Replicate all new and modified data to the schema as often as five minutes, or use near real-time option for selected objects.
Instant Data Warehouse
Low maintenance, fully automated data warehouse - no build projects, data modeling, or mapping.
Efficiently replicate Salesforce data into the warehouse of your choice – within minutes, not months.
Bi-directional data synchronization supports data imports and data recovery.
Scalable Data Integration
Easily access, discover, replicate, and integrate Salesforce data with adjacent enterprise systems — such as databases, ERP and CRM systems, and custom applications.
Hyperthreaded technology ensures the fastest possible data movement - complete integration, replication, and migration capabilities.
Backup, Recover, Restore
Easily backup and recover all of your data, including Salesforce contacts, leads, opportunities, attachments, accounts, custom objects, content document, etc.
Fast point-in-time recovery at any level of data at the org, record, and field levels - no matter when it was lost, changed, or corrupted.
All versions of all records are backed up historically, even deleted items.
Salesforce Specs
Supported Applications
Salesforce Sales Cloud
Salesforce Service Cloud
Salesforce Experience Cloud
Salesforce Commerce Cloud
Salesforce Financial Cloud
Salesforce Marketing Cloud
Salesforce App Exchange Managed Packages
Frequency
Near real-time bidirectional replication
Schedule jobs at user-defined intervals
On-demand deleted record recovery with relationships
Point-in-time data recovery
Deployment Model
Customer-owned and managed environment
Deploy on-premise or bring your own cloud infrastructure (AWS, Google, Azure, OCI, etc.)
Data Types
Standard objects & relationships
Custom objects & relationships
Files & attachments
Content documents & versions
Chatter feeds
Knowledge articles
Person accounts
History objects
Formula fields
Filtering
Object type
Hierarchy / Relationships
SOQL Query
Other
History tracking
Data versioning
Reporting and analytics database population for BI tools
Salesforce Specs
Supported Applications
Salesforce Sales Cloud
Salesforce Service Cloud
Salesforce Experience Cloud
Salesforce Commerce Cloud
Salesforce Financial Cloud
Salesforce Marketing Cloud
Salesforce App Exchange Managed Packages
Frequency
Near real-time bi-directional replication
Schedule jobs at user-defined intervals
On-demand deleted record recovery with relationships
Point-in-time data recovery
Deployment Model
Customer-owned and managed environment
Deploy on-premise or bring your own cloud infrastructure (AWS, Google, Azure, OCI, etc.)
Data Types
Standard objects & relationships
Custom objects & relationships
Metadata (backup only)
Files & attachments
Content documents and versions
Chatter feeds
Knowledge articles
Person accounts
History objects
Filtering
Object type
Hierarchy / Relationships
SOQL Query
Other
History tracking
Data versioning
Reporting and analytics database population for BI tools
SALESFORCE Backup & Recovery
Protect Your Data
Third-party backup is recommended by Salesforce as they state their recovery methods are to be used as a “last resort”. Learn more below.
Relying on Salesforce to Recover Your Data?
Salesforce’s native recovery can cost $10,000 USD per recovery
- The recovery process is manual and can take up to six to eight weeks to complete after you raise the support request
- Data deleted more than three months ago is not recoverable unless a third-party backup solution is used
- The recovered data is sent to you in CSV files, which requires you to manually re-upload (after resolving import errors) into Salesforce
- There’s no guarantee that 100% of your data will be recovered
Learn more about Backup, Recover, and Restore for Salesforce.
Why Use Relational Junction?
Turnkey Data Protection Solution for Salesforce to Recover From Any Data Loss
Recovery solutions typically provide you with text files of your data, making the actual recovery process your problem to solve. This method is time-consuming and does not ensure business continuity or the ability to perform a full recovery of all data.
With Relational Junction, your data is backed up throughout the day and is always available for fast point-in-time, granular restoration whenever needed. We will perform an incremental backup of your Salesforce data throughout the day – not just once a day – and keep every version of every record at the time of synchronization.
Backup Retention
- Complete compliance and audit trail for all updated records
- Data stored in a secure relational database, not flat files
- All versions of all records are backed up historically, even deleted items
- Incremental backup, not a snapshot-oriented full backup
Recovery Method
- Complete Salesforce data recovery including attachments, related records, etc. – subject to Salesforce rules
- Recover any level of data at the org, record, and field levels
- Recover deleted records and fields to any point in time, no matter when it was lost, changed, or corrupted
- Handles parent-child and recursive relationships
- Single or multi-record recovery
Stay Connected
Connect Salesforce to cloud and on-premises systems, including enterprise and middleware applications, data stores (e.g., databases, warehouses, big data stores), and analytics/BI tools.
RELATIONAL JUNCTION FOR SALESFORCE
Complete Solution for Salesforce
Signature Solution
Installation and creation of your warehouse take only minutes and accepts all data types, custom objects, and custom fields.
Our solution offers bidirectional replication of all Salesforce data to a database of your choice, with full automation of new objects, new fields, and field length increases. Relational Junction uses structured single-pass loading of data to Salesforce with parent-child relationships, and timestamp-based incremental replication. Replication can be both to and from your selected database as often as every five minutes and only copies the changes.
Performance
Relational Junction features extensive failover – restart logic, and doesn’t require reloading the entire table on failures. The replication process is automatically restartable at the point of failure and captures and logs rejected records.
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 on large volumes of data. In use at Fortune 500 companies since 2004, Relational Junction is the most scalable and reliable solution available.
- Capable of handling up to 2,000 records per API call
- Multi-threaded technology for fastest possible backup and recovery
- Rapid recovery of data, regardless of scale and granularity
- Backups restart automatically in the event of a failure
- Can handle unlimited record counts at no additional cost
- Extensive load statistics
- Allows immediate termination at point of failure, or to bypass error with error loading
Common Use Cases
Relational Junction meets regulations for FINRA financial institutions, SEC Rule 17a for securities broker-dealers, and HIPAA / FDA regulations for healthcare organizations.
- Full incremental backup of all data, or selectively filter sensitive data, for all regulatory needs.
- All database records are archived instead of being physically deleted.
- The bi-directional ability allows reloading of archived data to Salesforce with parent-child relationships intact.
Migrate legacy data to your Salesforce org– Accounts, Contacts, Leads, Opportunities, Products, Documents, and Attachments – not limited to standard Salesforce uploads.
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.
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.
Featured Resources
Do you have questions about how Relational Junction would work for you? Read below about data warehousing, integration, and more!
How to Protect Your Massive Amount of Marketing Cloud Data
It is essential to safeguard your valuable marketing data. Relational Junction helps you seamlessly manage and protect your Salesforce data.
BioMarin Case Study
Learn more about a Multinational Pharmaceutical firm that required bi-directional Salesforce integration to manage their customer data.
Data Backup with Relational Junction
Data backup with zero downtime! Secure storage and retention of your workloads with Relational Junction.
Maximize Your Salesforce Investment Today!