Relational Junction for Salesforce

Salesforce Integration & Data Replication

Salesforce.com provides a convenient hosted application service.

  • No recovery for lost or corrupted data.
  • No ability to give you a restore to what your data was yesterday.
  • No back-end reporting.
  • Integration with in-house applications is not possible without sophisticated AppExchange API programming.
Solution

Relational Junction for Salesforce simplifies Salesforce data integration, offline reporting, backup and recovery by creating and synchronizing a local data warehouse that is a perfect mirror of your Salesforce.com site.

  • Oracle, SQL Server, MySQL, PostgreSQL, DB2, Informix, Sybase Database includes all custom objects and fields, including long text and attachments.
  • No programming is required.
  • The database schema is always in sync with your Salesforce site.

Salesforce Integration Tasks Made Easy

Relational Junction for Salesforce

Big Data No Problem

Netsute-Graphics.2 (1)

Relational Junction for Salesforce is a unique solution that does not have the scalability limitations of other replication products.

  • Replication can be both to and from your local database as often as every five minutes, and only copies the changes.
  • Installation and creation of your warehouse take minutes, and replication speed is typically 500,000 records per hour.
  • In use at Fortune 500 companies since 2004, this is the most scalable and reliable solution available.

Data Integration

Relational Junction for Salesforce has patented technology which segments data by time range to allow you to load tens of millions of records.

  • The replication process is fully restartable.
  • This capability gives Relational Junction for Salesforce a unique ability to handle unlimited amounts of Salesforce data.
sales-manager

Relational Junction for Salesforce Benefits

Reporting

  • Freedom to use any reporting or Business Intelligence products
  • Improves reliability and performance of reporting enables analytics and exception reporting

Integration

  • Rapid development using common SQL programming skills.
  • No API programming.
  • Legacy data migration
  • External application integration
  • Improves reliability and performance of integration

Compliance

  • Backup all data incrementally
  • Keeps and can recover deleted records, including parent-child
  • Optionally keeps all versions of all records

Application Enablement

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

Best of Breed

  • Bi-directional replication of all Salesforce data to a local database
  • All data types, custom objects, and custom fields
  • Full automation of all Salesforce data model changes
  • Timestamp-based incremental replication for lowest footprint
  • Fault tolerant – extensive failover / restart logic
  • Structured single-pass loading of SaaS data with parent-child relationships
  • Over nine years of enterprise customer experience

High Performance Parallel Bi-Directional Replication

  • Copies one million records in 10-20 minutes, either from or to Salesforce.com.
  • Performance & reliability better than Salesforce.com’s bulk API
  • Not subject to volume and size restrictions of the bulk API

Patented Scalability of Data Replication

  • Segmentation of replicated data by timestamps makes this the only data replication product that can effectively handle millions of records
  • Eliminates timeouts
  • Automatically restartable at point of failure
  • Doesn’t require reloading entire table on failures
  • Scales to largest Salesforce.com customers

Compliance Regulations for Customer Data

  • SEC Rule 17a for securities broker-dealers
  • HIPAA / FDA for healthcare organizations
  • Requires data retention, historical tracking, data recovery
  • Heavy fines for violation

Relational Junction

Compliance Solution

  • Database records are archived, never physically deleted
  • Captures who deleted records and when
  • Archived records fully recoverable, including entire account and related entities
  • Optional change history for all fields in all tables – native Salesforce.com history tracking can only capture 20 fields per object

Use Cases

Using Relational Junction for Salesforce, you can:

Mirrored Schema

Create a mirrored schema on your server – all Salesforce.com objects will be created as tables, and all Salesforce.com fields created as database columns — automatically

Replicate Data

Replicate all new and modified data to the schema as often as five minutes

Modify Schema

Create or modify data in the local schema, and replicate the changes to your Salesforce.com site

Migrate Data

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

Report Writing

Write reports using your preferred reporting tool

Integrate to Other Databases

Integrate other back-office databases. Examples of this include maintaining customer and product data, integrating case management with bug tracking, providing a customer portal

Business Intelligence

Sophisticated analysis of customer data can be done with conventional reporting tools that go beyond native Salesforce.com reporting, including complex statistical and trending analysis. Our customers use a complete range of BI Tools, including:

  • Business Objects
  • COGNOS
  • Microstrategy
  • Crystal Reports
  • Hyperion
  • Jaspersoft
  • Tableau
  • SQL Server Reporting Services
  • Native SQL Reporting
Salesforce Data Integration

Relational Junction for Salesforce – Features

Functionality

  • Uses simple SQL transforms instead of confusing proprietary scripting language
  • Allows any SQL construct, including table joins and unions
  • Offers smart insert / update using unique keys in target table
  • Intuitive web user interface
  • Does not constrain functionality with drag-and-drop interface limitations
  • Automatic timestamp filtering
  • Handles time zone changes between databases
  • Enables bolt-on business processing with database triggers and function

Ease of Use

  • Leverages existing in-house database skills
  • Short time-to-deploy with minimal training required
  • Developers are productive within minutes
  • Increases productivity — development time typically 2 tables per day, including data mapping, ETL setup, unit testing
  • Compatible with source control tools – all definitions stored as XML on the file system
  • Minimal training and support needed

Fault Tolerant

  • Captures and logs rejected records.
  • Restarts at point of failure.
  • Allows immediate termination at point of failure or bypass error and continue with error logging.
  • Reports extensive load statistics.

High Performance

  • Typical replications speeds are 2 million records per hour.
  • Transfers of long text and binary data are significantly slower due to inherent speed limitations in the respective DBMS platforms for streaming I/O.

Platform

  • Cross Platform – Java J2EE 1.7 / JDBC
  • Operating Systems: Windows and UNIX

Relational Junction Supports

  • Oracle
  • SQL Server
  • MySQL
  • PostgreSQL
  • Sybase, DB2
  • Informix
  • Greenplum
  • IBM DB2
  • Progress
  • Vertica
  • CSV files, and XML
  • All supporting software is free unless noted otherwise
  • Complete technical documentation, expert telephone and email customer support.
  • Installation and training included
  • Data migration, integration, and implementation assistance is available through Sesame Software Professional Services Group.
logo3

Same Day Support

Support (1)
  • Documented procedures
  • User training
  • Email customer support
  • Same day and after-hours telephone support
  • U.S. based support team
  • All included in standard product price

Professional Services

  • Salesforce.com legacy migration
  • Salesforce.com organization split / clone/ merge
  • Salesforce.com integration
man-sitting-at-desk1
LinkedInFacebookGoogle+TwitterShare

Leave a Reply

References

Integration Made Easy

Lava Trading
"We had planned a project to build a proper customer database repository in-house, to replace the poorly designed CRM database from our previous vendor. The Relational Junction for Salesforce product eliminated the need, saving us countless hours of work and ongoing maintenance for an inhouse database. Sesame Software's product has been running smoothly since June 2005. The level of support, and the level of understanding of how Salesforce.com works, has been a tremendous benefit to our own implementation. I strongly recommend this product and the vendor to anyone who needs to integrate internal applications to their Salesforce.com data, without requiring a knowledge of SOAP or the Salesforce.com API."