title: Transferring data from Salesforce using Apex Data Loader to Oracle
body: <p>While attempting to transfer data from Salesforce using Apex Data Loader to Oracle Keep getting the following error:</p>
  
  <pre><code>    26937 [databaseAccountExtract] FATAL com.salesforce.dataloader.dao.database.Data
  baseContext  - Error getting value for SQL parameter: nkey__c.  Please make sure
   that the value exists in the configuration file or is passed in.  Database conf
  iguration: insertAccount.
  </code></pre>
  
  <p>The database-conf.xml has the following beans:</p>
  
  <pre><code>&lt;bean id="insertAccount"
        class="com.salesforce.dataloader.dao.database.DatabaseConfig"
        singleton="true"&gt;
      &lt;property name="sqlConfig" ref="insertAccountSql"/&gt;
      &lt;property name="dataSource" ref="dbDataSource"/&gt;
  &lt;/bean&gt;
  &lt;bean id="insertAccountSql" class="com.salesforce.dataloader.dao.database.SqlConfig" singleton="true"&gt;
      &lt;property name="sqlString"&gt;
          &lt;value&gt;
              INSERT INTO VANTROPO.SF_ACCOUNTCHANNEL (nkey__c)
              VALUES (@nkey__c@)
          &lt;/value&gt;
      &lt;/property&gt;
      &lt;property name="sqlParams"&gt;
          &lt;map&gt;
     &lt;entry key="nkey__c" value="java.lang.String"/&gt;
          &lt;/map&gt;
      &lt;/property&gt;
  &lt;/bean&gt;
  </code></pre>
  
  <p>The SDL (mapping file) has the following values:</p>
  
  <pre><code># Account Insert Mapping values for query from Salesforce (left) and insert/update to Oracle (right)
  # SalesforceFieldName=OracleFieldName
  nkey__c=NKEY__C
  </code></pre>
  
  <p>Any help appreciated.</p>