Setting up the Database for SalesForce

salesforce_database.xml

<spring:bean id="jdbcDataSource" class="org.enhydra.jdbc.standard.StandardDataSource" destroy-method="shutdown">
    <spring:property name="driverName" value="com.mysql.jdbc.Driver"/>
    <spring:property name="url" value="jdbc:mysql://localhost/salesforce?user=root"/>
</spring:bean>

<jdbc:connector name="jdbcConnector" dataSource-ref="jdbcDataSource">
    <jdbc:query key="insertAccount"
                value="INSERT INTO accounts (id, name, phone)
                    VALUES(#[map-payload:Id], #[map-payload:Name], #[map-payload:Phone])
                    ON DUPLICATE KEY UPDATE name = VALUES(name), phone = VALUES(phone)"/>
</jdbc:connector>

<salesforce:config name="sfdc" username="<Your Username>" password="<Your Password>"
                   securityToken="<Your SecurityToken>"/>