User Tools
salesforce_sql_agent
Differences
This shows you the differences between two versions of the page.
| 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
Page Tools
