User Tools

Site Tools


salesforce_sql_agent

Differences

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

Link to this comparison view

Next revision
Previous revision
salesforce_sql_agent [2016/05/25 14:40]
joe created
salesforce_sql_agent [2016/09/14 16:02] (current)
joe
Line 1: Line 1:
 +====== SQL Subscriber Agent Configuration for Salesforce ======
 +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 code>+<​WRAP ​round info> 
 +Note:  The <​schema_connection> ​ password attribute is your salesforce password with your security token appended to it. 
 +</​WRAP>​ 
 +  
 +<code xml>
 <?xml version="​1.0"​ encoding="​ISO-8859-1"​ standalone="​no"?>​ <?xml version="​1.0"​ encoding="​ISO-8859-1"​ standalone="​no"?>​
 <​config>​ <​config>​
Line 21: Line 27:
                 <​database>​solutions</​database>​                 <​database>​solutions</​database>​
  
-                <​schema_connection user="atilioandres@gmail.com" password="​salesforce1NxOwgnOlIH11JIfXC9Ob57Dc"​+                <​schema_connection user="your_sfuser@yourcompany.com" password="​salesforce1NxOwgnOlIH11JIfXC9Ob57Dc"​
                     client_id="​3MVG9uudbyLbNPZO0CYuZCvodrGD7QFWe6aPZY54i2cn4BqjhcuaSCYM2hgWI297gwSCr.5XEfy3WlyB4zXcI"​                     client_id="​3MVG9uudbyLbNPZO0CYuZCvodrGD7QFWe6aPZY54i2cn4BqjhcuaSCYM2hgWI297gwSCr.5XEfy3WlyB4zXcI"​
                     client_secret="​8290250609080749993">​https://​login.salesforce.com/​services/​oauth2/​token</​schema_connection>​                     client_secret="​8290250609080749993">​https://​login.salesforce.com/​services/​oauth2/​token</​schema_connection>​
Line 27: 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>​
    </​agent>​    </​agent>​
 </​config>​ </​config>​
-</WRAP>+</code>
  
salesforce_sql_agent.1464212419.txt.gz · Last modified: 2016/05/25 14:40 by joe