Integrating > Integrating with IBM Cognos > The ODS database > Retrieving encyclopedia data > Running the Data Retriever from the command line
  
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:
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" /W 1
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:
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" /W 1,3
See also
Retrieving encyclopedia data