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:41]
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 ======
 +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 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>​
salesforce_sql_agent.1464212518.txt.gz ยท Last modified: 2016/05/25 14:41 by joe