Integrating : Integrating with IBM Cognos : The ODS database : Retrieving encyclopedia data : Obtaining the encyclopedia workspace ID
  
Obtaining the encyclopedia workspace ID
To retrieve data from more than one workspace you need to provide workspace IDs. To get the workspace ID, use a REST URI in a web browser. The URI has this format:
protocol://server:portnumber/SARest/database/database_instance/ency
protocol: http or https
server: Local or remote server where the SA REST Service runs.
database: SQL
database_instance: Database instance name. If the database instance is on a different computer from the SA REST, use:
computer_name + database_instance
ency: Encyclopedia name.
To get the encyclopedia workspace ID
1 Start your web browser.
2 In the Address field, enter your data. For example, for the Samples encyclopedia:
http://localhost:8889/SARest/SQL/ibm/Samples/1
The above URI returns the information you need. As shown below, the Samples encyclopedia contains three workspaces: Root, WS_1, and WS_2. Each workspace also has an ID of 1, 2, and 3, respectively. The ID number for encyclopedias without workspaces is 1, which is always the ID of the Root workspace.
3 Include the workspace ID for the encyclopedia in the command line, 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