On-Premise Data Integration Software Resources

Relational Junction has patented scalability features that let it copy terabytes of cloud or on-premise data without exceeding API limits, and do it more quickly than any other method using multi-threaded readers and writers. The only real limitation is in the amount of storage you have available.

Relational Junction for Salesforce is an easily configurable replication utility that requires no coding or design. All you need to know is your connection user information and which objects you wish to replicate – or select all objects, which is the default. New objects and fields are automatically discovered and added to the database. Relational Junction ETL Manager uses native SQL to select, insert, and update records in over 80 database and API-based platforms. The learning curve for a reasonably skilled SQL developer is less than one hour, since the there is no proprietary transformation language to learn and the user interface for any integration is done entirely on a single web page. Using SQL provides total transparency to the integration developer rather than going to a proprietary GUI that takes weeks to learn.

Relational Junction works on-premise, in a private cloud such as Amazon EC2, and on Sesame Software’s cloud. Sesame’s cloud is strictly for managed backup and recovery of Salesforce data, and there is no customer access to the database. Customers have complete access to the database in on-premise or private cloud deployments, enabling data warehouse access for reporting and integration. A Relational Junction server must be on the same local network or data center as a traditional database. There is no such proximity restriction for API-based data.