Integrating : Integrating with IBM Cognos : The ODS database : Retrieving encyclopedia data : Running the SA Data Retriever from Windows Task Scheduler
  
Running the SA Data Retriever from Windows Task Scheduler
You can automate the SA Data Retriever with the Windows Task Scheduler. Consecutive runs of the SA Data Retriever, if scheduled, flush out the data from the ODS database (if it has already been created) and write fresh data to it from the encyclopedia.
Note The information below covers how to schedule a task to run the SA Data Retriever. For more information about the Windows Task Scheduler, see its documentation.
1 Click Start > Control Panel > Schedule Tasks.
2 Click Add Scheduled Task.
3 Click Next in the Scheduled Task Wizard.
4 Click Browse, and then navigate to the folder where the System Architect - Cognos Bridge is installed:
C:\Program Files\UNICOM Systems\System Architect Suite\SA-Cognos
5 Select SADataRetriever.exe, and then click OK.
The task wizard takes the name of the executable as the name of the task by default. You can change the name if you want.
6 In the Perform this task field, select the frequency to run the task.
7 Click Next, and then select the frequency to run the task.
8 Click Next.
9 Enter your domain and user name combination (in the format: DomainName\UserName), and your password.
10 Click Next.
The task wizard provides a summary of the schedule, for example:
Windows will perform this task: At 7:04 PM every Mon of every week, starting 1/20/2016
11 Click Open advanced properties for this task when I Click Finish, and then click Finish.
12 In the Run field, append the XML file name to the SA Data Retriever executable, as follows:
SADataRetriever.exe /C "C:\Program Files\UNICOM Systems\System Architect Suite\SA-Cognos\Conf\MyServerName_MySQLServeInstanceName_Samples_ODS.xml"
The above example gets data from workspace-enabled and non-workspace-enabled encyclopedias. For workspace-enabled encyclopedias, it gets the data from all workspaces by default.
Optionally, for workspace-enabled encyclopedias, you can retrieve data for a particular workspace by providing its ID after the /W command line switch, as in this example:
SADataRetriever.exe /C "C:\Program Files\UNICOM Systems\System Architect Suite\SA-Cognos\Conf\MyServerName_MySQLServeInstanceName_Samples_ODS.xml" /W 1
For workspace-enabled encyclopedias, you can retrieve data from more than one workspace by providing the workspace IDs, separated by commas, after the /W command line switch, as in this example:
SADataRetriever.exe /C "C:\Program Files\UNICOM Systems\System Architect Suite\SA-Cognos\Conf\MyServerName_MySQLServeInstanceName_Samples_ODS.xml" /W 1,3
13 Click OK.
14 In the Set account information dialog, enter your domain and user name combination (in the form DomainName\UserName), and your password.
15 Click Finish.
In the Scheduled Tasks window, the task you just created now appears as task, displaying the Schedule properties, such as Next Run Time, Last Run Time, and so on.