User Tools

Site Tools


salesforce_agent_configuration

Example: 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.

NOTE: The <schema_connection> password attribute is your salesforce password with your security token appended to it. To encrypt the password you use to access your Salesforce org, add encrypt: in front of the value for the password attribute for the <schema_connection> directive.

<?xml version="1.0" encoding="ISO-8859-1" standalone="no"?>
<config>
    <agent>
      <max_reads_per_connect>4000</max_reads_per_connect>
      <polling_interval>30</polling_interval>
 
        <subscribe>
            <task>
                <task_name>salesForce</task_name>
                <message_connection queue="psp.out.replicator.mysalesforce" password="encrypted:iTOCp4deP7rJNgFkf2AEMA==" user="admin">amqp://perspectiumdemo1-amqp.perspectium.net</message_connection>
                <handler>com.perspectium.replicator.sql.SQLSubscriber</handler>
                <decryption_key>The cow jumped over the moon</decryption_key>
                <database_type>mysql</database_type>
                <database_server>localhost</database_server>
                <database_port>3306</database_port>
                <database_user>root</database_user>
                <database_password></database_password>
                <database_params>characterEncoding=UTF-8</database_params>
                <database>solutions</database>
 
                <schema_connection user="your_sfuser@yourcompany.com" password=encrypt:"salesforce1NxOwgnOlIH11JIfXC9Ob57Dc"
                    client_id="3MVG9uudbyLbNPZO0CYuZCvodrGD7QFWe6aPZY54i2cn4BqjhcuaSCYM2hgWI297gwSCr.5XEfy3WlyB4zXcI"
                    client_secret="8290250609080749993">https://login.salesforce.com/services/oauth2/token</schema_connection>
 
                <primary_key>Id</primary_key>
                <skip_database_creation/>
                <date_time_format>yyyy-MM-dd'T'HH:mm:ss.SSS'Z'</date_time_format>
            </task>
      </subscribe>
   </agent>
</config>
salesforce_agent_configuration.txt · Last modified: 2019/03/18 10:31 by timothy.pike