Yes. This is the preferred implementation. You can use any job scheduler, including Windows Scheduler, UNIX cron, or a commercial job scheduler.
Yes. This is the typical implementation.
Yes, there is a Real Time Option which uses OutBound Messages to drive the process. The procedure to set this up is to
- Define OutBound Messages for each object desired in Salesforce, sending the ID and SystemModStamp fields to your Relational Junction server for new or changed records.
- Open a port to *.salesforce.com in your firewall to allow the OutBound Messages in.
- Install the WAR file for the Real Time Option application.
- Run a -getObjectIdMap command for each object you wish to get in real time. This maps the Salesforce ID’s to objects using their 4-character prefix, using the existing data in your database for pattern matching.
- Run the following command to start pulling data as the record ID’s are captured, using a job scheduled every 5 minutes to ensure continuous operation in the event of failure:
RJ4SalesforceRTO -config [config name] -repeat [delay seconds] -getRealTime
- To send changed data to Salesforce, add a -setGlobal command before or after the -getRealTime, with the objects desired in the upload.config file.
Yes. Relational Junction for Salesforce allows you to create separate configurations to subset the objects and to point to different databases. You specific which configuration you want to use for each job, giving you total flexibility to mix and match.
Yes, you can subset the Salesforce objects to include any specific objects. You can also limit replication to Standard, Custom, History, Chatter, Share, or Tag objects.
Yes, both full or incremental replication are supported, but you will typically run incremental. This is much faster, since only changed and new records are copied.
Yes, there are logs that show progress. There is no “thermometer” widget, but the logs are much more informative.
Jobs can be scheduled with Windows Scheduler, UNIX cron, Control-M or any other job scheduler. Some customers trigger jobs from other ETL products. All it requires is a process that can invoke Relational Junction‘s command-line interface.
A user can initiate a job by entering a command such as “RJ4Salesforce -config production -getGlobal”.
A user can initiate a job through the web user interface.
There is a Real-Time mode that captures OutBound Messages that you configure in Salesforce to trigger replication of the entire record.
Yes. The client is just a compatible web browser. The server component does need to be installed, and requires Java and Tomcat.
Yes, all browsers that support CSS3 and HTML5 are supported. It can be configured for SSL (port 443) if you have an SSL cert, but typically customers who implement on-premise use port 8080.