Using 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 specify parameters is [parameter]. You can also specify optional default values.
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 via 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.