ETL Tools Resources

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.

Yes. Data is backfilled (depending on the source) once you connect up a data source. For example, Google Ads data goes back to up to 2 years in the past when you connect it as a source.