Running the Data Retriever from the command line

Integrating > Integrating with IBM Cognos > The ODS database > Retrieving encyclopedia data > Running the Data Retriever from the command line

When you run the Data Retriever from the command line, use the C option, followed by the full path and name of the XML file that was generated by the Schema Generator.

Example command line

C:\Program Files\UNICOM Systems\System Architect Suite\SA-Cognos\SADataRetriever.exe /C "C:\Program Files\UNICOM Systems\System Architect Suite\SA-Cognos\Conf\MyServerName_MySQLServeInstanceName_Samples_ODS.xml"

This example retrieves data from workspace-enabled and non-workspace-enabled encyclopedias. For workspace-enabled encyclopedias, it retrieves the data from all workspaces by default.

Retrieving data for specific workspaces

Optionally, for workspace-enabled encyclopedias, you can retrieve data for a particular workspace by providing its ID after the /W command line switch, for example:

To get the workspace ID for an encyclopedia, see Obtaining the encyclopedia workspace ID.

Retrieving data for multiuple workspaces

Additionally, 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, for example: