Cloudera Docs

IBM Cognos Report Studio

Learn how to export, schedule, and manage IBM Cognos reports and packages.

  • Read the Permission for Cloudera Octopai Windows NT User to the Cognos ZIP files folder.

  1. Export and Schedule Export of IBM Cognos Reports and Packages
    1. Open IBM Cognos Administration and go to the Configuration tab.
    2. Click the New export button.
    3. Name the export.
    4. Select the deployment method by choosing the first option.
    5. Click Add.
    6. Add packages and reports you want by dragging them from left to right and then click OK.
    7. Select all the checkbox objects and then click Next.
    8. Click Next.
    9. Click Next.
    10. Click Next.
    11. Click Next.
    12. Choose the Save and run once or the Save and schedule checkbox and click Finish.
    13. If you chose Save and schedule, choose when to schedule and then click Run.
    14. Click OK.
      The file is saved under the deployment folder on the Cognos server. Usually the installation folder is at C:\Program Files\ibm\cognos\c10_64\deployment. The extracted file will appear in the destination defined folder.
  2. Zip the metadata result file and use it as the source for your Cloudera Octopai metadata Cognos connection in the Cloudera Octopai Client.
  3. Upload the zip file to the prospect folder in the portal.
  4. Share the password of the Cognos package or framework file that defined in the guideline.
  5. Share the prospect IBM Cognos version.
  6. Set up the IBM Cognos Metadata Source.


  7. Verify the extracted metadata file by accessing the Cloudera Octopai Target Folder (TGT).
    1. Go to the TGT Folder located on the server where the Cloudera Octopai Client is installed.
      The default location is C:\Program Files (x86)\Octopai\Service\TGT.
    2. Open the zip file with the connector name.
      Example
    3. Verify the file content by checking the quantity and quality of the included files.

If an error occurred during the extraction, perform the following troubleshooting steps:

  1. Check the permissions.
  2. Send the log with the connector number and name to Cloudera Support.
    You can find the log files at C:\Program Files (x86)\Octopai\Service\log.