Connecting an input table to multiple types of data sources can be done by using connection strings. Uploading a file automatically creates a connection string table.
Follow these steps to view the connection string.
|1||Go to the Data tab of your developer environment.|
|2||Double click on the table for which you want to view the connection string.|
The Edit Connection String Table dialog is opened showing the connection string.
See illustration below.
This string denotes that a file is loaded, where it is located, and how this file is parsed. This string is automatically generated when using the Upload a file… option.
Below is a description of the parameters of the connection string.
|driver||Defines what type of data connection is created. In this case, |
|mv-enable||Enables you to disable a connection string. By default, this setting is set to |
|filename||Denotes the relative path to the location of the file. The root of this path is defined by the table scope of this table.|
The type of file is taken from the extension of the file.
Note: instead of a relative path you can use a url, which enables you to load a file from a webserver via HTTPS. Since the
|hasheader||If True, the values in the first line of the file will be used as the names of the attributes.|
If False, all lines of the file will be parsed as values of the attributes, and the attributes will be automatically named (A1, A2, …).
|delim||Contains the character that separates the fields in a line. This can either be the character itself, or the ASCII code of this character.|
To avoid confusion with characters also used in a connection string itself, the ASCII code (59) is used.
|quote||Contains the character that encloses fields within the file. Usually, this is not necessary, and none can be used.|
Note: When fields can contain the
|encoding||The encoding of the file defines how characters are parsed. Usually, this is UTF-8.|
Follow these steps to create a new table using a connection string.
|1||Right click in the Data tab and select New able -> Connection string....|
A connection string table
|2||Double-click on |
|3||Enter the connection string in the Connection String field.|
Updated 4 days ago