Implementation Guide › Implementation › Data Gathering (Data Source Expert) › How to Configure Adapters and Translations › SQL Adapters › SQL Adapter Connection String

SQL Adapter Connection String

The SQL Adapter connection string mechanism is designed to provide the following capabilities:

• Work with several connection strings in the same Adapter.
• Work with a connection string template, where the file name can be changed without changing the configuration file.
• Delete the file data source once the Adapter has finished reading it.
• Move the file data source to another location once the Adapter has finished reading it.

In addition to the simple definition of the connection string as a string in the ConnectionString element, the connection string can be defined by segments, where each segment holds the specific values that are concatenated to the connection string. This allows the Adapter to build the connection string dynamically.

There are two segment types. One is text and contains text that is concatenated to the connection string as is. The second is a file and contains a file name with or without wildcards. The file segment can appear only once. It contains other attributes that define what must be done with the read file.

The ConnectionString can be defined in the QueryCollection element and/or in the Query elements. The ConnectionString definition in the QueryCollection element is the default and is used only in a query without an explicit ConnectionString definition.