Part 4: The Connect XE Drivers : The Salesforce Driver : Database Configuration File

Database Configuration File
You can configure an embedded database and data mapping using a database configuration file in XML format. Some of these values you can set in the file are the same as those you can set using the Config Options connection option (see Connection Option Descriptions). Some database configuration values can be set only using a configuration file.
The name of the database configuration file has the format:

databasename.config
where:
databasename
is the name of the database to be configured. For example, if your environment has a database named mydb or a database configuration file named mydb.config, when the driver establishes a connection, it performs the following tasks:
Checks to see if an embedded database named mydb exists (or a database using the default databasename if one is not specified). If mydb exists, the driver connects to the remote data source using the mydb database.
Example Database Configuration File
The following is an example database configuration file:
<?xml version='1.0' encoding='UTF-8'?>
<Database xmlns="http//datadirect.com/cloud/config/1.0">
  <User name="CONNECT2" defaultSchema="SFORCE">
    <UseSchema name="SFORCE"/>
    <UseSchema name="PUBLIC"/>
  </User>
  <Schema name="SFORCE" type="Salesforce">
    <ConfigOptions>uppercaseidentifiers=true;localtables=0;auditcolumns=none;
     customsuffix=strip;KeywordConflictSuffix=;</ConfigOptions>
<SessionOptions>loginhost=test.salesforce.com;userid=
     connect2@progress.com</SessionOptions>
  </Schema>
  <Schema name="PUBLIC" type="local">
  </Schema>
</Database>
The following are descriptions of the elements of the database configuration file.
Database
User
UseSchema
Schema
ConfigOptions
SessionOptions

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.