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 22:53] joe |
salesforce_sql_agent [2016/09/14 16:02] (current) joe |
||
---|---|---|---|
Line 2: | Line 2: | ||
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. | 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> | + | <WRAP round info> |
Note: The <schema_connection> password attribute is your salesforce password with your security token appended to it. | Note: The <schema_connection> password attribute is your salesforce password with your security token appended to it. | ||
- | </wrap> | + | </WRAP> |
<code xml> | <code xml> | ||
Line 33: | 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> |