SQL Server Database Data Source

You can create a table from an SQL Server Database query.

Properties of the SQL Server Database data source:

WPC

The Data Enrichment Application from which to take the parameters (only SQL DECs)

This field is compulsory if the BY DEC radio button is checked

Server Name / Port / Database

SQL Server Database access

These fields are compulsory if the By Properties radio button is checked

User / Password

The user with permission to run the query

This field is compulsory if the By Properties radio button is checked

Timeout (min)

The query timeout (default is 0)

This field is compulsory if the By Properties radio button is checked

Query

The SQL query that defines the data to retrieve