This shows you the differences between two versions of the page.
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> |