Column | Description |
---|---|
DB Type | Describes what kind of data can be read with this adapter. |
Trusted |
|
Provider Group | Displays all the included Data Provider. These information are predefined and can't be changed. If you need an additional data adapter, please contact us. |
Connect String | The connect string contains the information that the provider need to know to establish a connection to the database or the data file. Assembly:
The connect string may contains placeholders like myServer, myDataBase and myUserName, myPassword and myPort. Click here for more information about connect strings (external link). |
Remark | Enter your comments or parameter description here. |
Special Settings
The adapters "Avaloq (Oracle)" and "Avaloq (TNS Oracle)" contain the variable @SessionUnlock which has to be filled in field "Data Source" on screen Environment as example shown below with the specific command to open the session security for Avaloq systems.
Text Files
Options for text files with OLEDB Adapter: Extended Properties="text;HDR=yes;IMEX=1;FMT=Delimited";
Notice that only the directory for the text file is specified in the connection string. The filename of the text file is specified in the T-SQL commands that access data in the text file, similar to a table name in a database.
Keyword | Remark | ||||||||
---|---|---|---|---|---|---|---|---|---|
HDR=No | First row does not contain field description. | ||||||||
HDR=Yes | First row contains field description. | ||||||||
FMT=Delimited | Delimited fields with default delimiter. You can access files that use nonstandard text delimiters and fixed-width text files by creating a schema.ini file in the same directory as the text file. A text file, vehicle_semi.txt. A possible schema.ini file for the vehicle_semi.txt file is: | ||||||||
The connect string contains the information that the provider need to know to establish a connection to the database or the data file. Assembly:
The connect string may contains placeholders like myServer, myDataBase and myUserName, myPassword and myPort. Click https://www.connectionstrings.com/ for more information about connect strings (external link). | |||||||||
Enter your comments or parameter description here. | |||||||||
You can specify the fields in the text file in two ways:
The MaxScanRows option indicates how many rows should be scanned to automatically determine column type. A value of 0 indicates that all rows should be scanned.
The ColN entries specify the name, width, and data type for each column. This entry is required for fixed-length formats and optional for character-delimited formats. The syntax of the ColN entry is: ColN=columnName dataType [Width n]
The parameters in the entry are: columnName
dataType
Width n
The Character option specifies the character set; you can set it to either ANSI or OEM. |