InfoSet Parameters

InfoSet parameters are placeholders that you include within the data source. Smart Notification replaces parameters with actual values when it retrieves data from a data source.

The format you use to enter parameters is [parameter]. You can also specify optional default values.

Note: SQL Server uses [ ] for names that include spaces. For example,

SELECT
        column1 AS [My Column] FROM table1

. In this example, you do not need to provide a parameter value if [My Column] is the desired name. When prompted for parameters in these cases you can leave the parameter blank.

Using the Delimited Document data source

Use the Delimited Document data source type to set up separate .CSV files as data sources.

Example

Set the file name in the InfoSet at C:\MyPath\[vendor-ID].csv. Where [vendor-ID].csv is the name of the file. When you update the InfoSet, you need to provide a vendor ID, for example, Vendor 1, so that the system updates the InfoSet from C:\MyPath\vendor1.csv.

Using separate databases

Use separate databases, Test and Production, to extract data.

You can enter parameters through the Smart Notification application or from the command line. The parameters that you provide are passed to the update servlet using parameters, which allows the updates to be scripted.

Example

The URL is databasename=[dbname default = Production]&port=1234. When you update the InfoSet, you specify either Test or Production. If you do not specify a database name, the system uses the production database.

In the example for the Delimited Document data source, a set of updates is being performed that do a separate update and process for each vendor. Only a single InfoSet needs to be created and the specific vendor ID can be passed in on the command line.