User Tools

Site Tools


salesforce_sql_agent

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
salesforce_sql_agent [2016/05/25 14:47]
joe
salesforce_sql_agent [2016/09/14 16:02] (current)
joe
Line 1: Line 1:
 ====== SQL Subscriber Agent Configuration for Salesforce ====== ====== SQL Subscriber Agent Configuration for Salesforce ======
-To install and configure a SQL Subscriber agent to consume replicated Salesforce records+The SQL Subscriber agent can be configured ​to consume replicated Salesforce records ​and write them to a database table. ​ The agent.xml file shown below is an example of the necessary configuration. 
 + 
 +<WRAP round info> 
 +Note:  The <​schema_connection> ​ password attribute is your salesforce password with your security token appended to it. 
 +</​WRAP>​ 
 + 
 <code xml> <code xml>
 <?xml version="​1.0"​ encoding="​ISO-8859-1"​ standalone="​no"?>​ <?xml version="​1.0"​ encoding="​ISO-8859-1"​ standalone="​no"?>​
Line 28: Line 33:
                 <​primary_key>​Id</​primary_key>​                 <​primary_key>​Id</​primary_key>​
                 <​skip_database_creation/>​                 <​skip_database_creation/>​
 +                <​date_time_format>​yyyy-MM-dd'​T'​HH:​mm:​ss.SSS'​Z'</​date_time_format>​
             </​task>​             </​task>​
       </​subscribe>​       </​subscribe>​
salesforce_sql_agent.1464212851.txt.gz · Last modified: 2016/05/25 14:47 by joe