User Tools
salesforce_sql_agent
Differences
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> | ||
salesforce_sql_agent.1464212851.txt.gz · Last modified: 2016/05/25 14:47 by joe
Page Tools
