Properties tab
On the Properties tab, you can specify details of what the link does.
The properties that you set for the output link define how incoming data is read and from what table. Some of the properties are required, although many have default settings. Properties without default settings appear as red in this tab and turn black when you supply a value for them.
The following table lists the properties and their attributes. A more detailed description of each property follows.
Category and Property | Values | Default | Required? | Dependent of |
---|---|---|---|---|
Source | ||||
Read Method |
|
Table | Yes | N/A |
Table | Table name | Yes | Yes if Read Method = Table or Auto-generated SQL | N/A |
Select List | List | N/A | No | Table |
Where Clause | Filter | N/A | No | Table |
Partition Table | Table | N/A | No | Table |
Query | SQL query | N/A | Yes if Read Method = User-defined SQL or Auto-generated SQL | N/A |
Connection | ||||
Connection method |
|
XPS Fast | Yes | N/A |
Remote server |
|
False | Yes if Connection Method = Native | N/A |
User | User ID | N/A | Yes if Connection Method = Native and Remote Server = True | N/A |
Password | Password | N/A | Yes if Connection Method = Native and Remote Server = True) | N/A |
Database | Database name | N/A | No | N/A |
Server | Server name | N/A | No | N/A |