Understanding the Customization File

Each section header in the customization file consists of square brackets ([]) containing a type and operand. The four section types are indicated by the literal strings connect, sql, userlist, or logs. The operand is the literal string, default, a user-specified identifier, or nothing.

Therefore, each section is marked with one of the following section headers:

[ connect   default      ]
[ connect   identifier   ]
[ sql         default      ]
[ sql         identifier   ]
[ userlist   identifier   ]
[ logs                  ]

The section headers have the following parts:

Part	Description
connect	Literal string—This section modifies a connect string.
sql	Literal string—This section modifies a command string.
userlist	Literal string—This section modifies the access rights of a specific user.
logs	Literal string—This section specifies a log file that records operational errors.
default	Literal string—This section is used if no identifier is specified or found.
identifier	A string that matches a string in the connect or command string. Use this section if the section header contains connect and the identifier string is found in the connect string. Use this section if the section header contains sql and the identifier string is found in the command string. Use this section if the section header contains userlist and the identifier string matches a connect section identifier.

The DataFactory calls the Handler, passing client parameters. The Handler searches for whole strings in the client parameters that match identifiers in the appropriate section headers. If a match is found, the contents of that section are applied to the client parameter.

A particular section is used under the following circumstances:

A connect section is used if the value part of the client connect string keyword, "Data Source=value", matches a connect section identifier.
A sql section is used if the client command string contains a string that matches a sql section identifier.
A connect or sql section with a default operand will be used if there is no matching identifier.
A userlist section is used if the userlist section identifier matches a connect section identifier. If there is a match, the contents of the userlist section are applied to the connection governed by the connect section.
If the string in a connect or command string does not match the identifier in any connect or sql section header, and there is no connect or sql section header with a default operand, then the client string is used without modification.
The logs section will be used whenever the DataFactory is in operation.