• Sarbjeet Heera 5
  • NEWBIE
  • 0 Points
  • Member since 2015

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies

Does anyone understand how to connect Apex DataLoader with a Microsoft SQL Database to moved data in either direction?  Right now, I have my database-conf.xml set up like

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
<bean id="dbDataSource"
      class="org.apache.commons.dbcp.BasicDataSource"
      destroy-method="close">
    <property name="driverClassName" value="com.microsoft.sqlserver.jdbc.SQLServerDriver"/>
    <property name="url" value="jdbc:sqlserver://Localhost;databaseName=dltest;selectMethod=cursor;"/>
    <property name="username" value="test"/>
    <property name="password" value="test"/>
</bean>
<bean id="queryAccount"
      class="com.salesforce.dataloader.dao.database.SqlConfig"
      singleton="true">
    <property name="sqlConfig" ref="queryAccountSql"/>
    <property name="dataSource" ref="dbDataSource"/>
</bean>
</beans>

 The process-conf.xml file looks like this.

<!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd">
<beans>
    <bean id="upsertDLTest"
          class="com.salesforce.dataloader.process.ProcessRunner"
          singleton="false">
        <description>.</description>
        <property name="name" value="upsertDLTest"/>
        <property name="configOverrideMap">
            <map>
                <entry key="sfdc.debugMessages" value="true"/>
                <entry key="sfdc.debugMessagesFile" value="DEBUG LOG FILE"/>
                <entry key="sfdc.endpoint" value="ENDPOINT URL"/>
                <entry key="sfdc.username" value="MY USERNAME"/>
                <!-- password below has been encrypted using key file, therefore it will not work without the key setting: process.encryptionKeyFile
                the password is not a valid encrypted value, please generate the real value using encrypt.bat utility -->
                <entry key="sfdc.password" value="ENCRYPTED VALUE"/>
                <entry key="process.encryptionKeyFile" value="ENCRYPTION KEY FILE LOCATION"/>
                <entry key="sfdc.timeoutSecs" value="600"/>
                <entry key="sfdc.loadBatchSize" value="200"/>
                <entry key="sfdc.entity" value="DLTest__c"/>
                <entry key="process.operation" value="upsert"/>
                <entry key="process.mappingFile" value="MAPPING FILE"/>
                <entry key="process.statusOutputDirectory" value="STATUS LOG FOLDER"/>
                <entry key="dataAccess.name" value="queryAccount"/>
                <entry key="dataAccess.type" value="databaseRead"/>
            </map>
        </property>
    </bean>

 I'd appreciate any help anyone can give me.  Thanks!