Update IBM Cognos 8 BI PowerCube DataSources Utility

Downloadable files


Abstract

To update IBM Cognos 8 BI PowerCube data sources whose source cubes have changed locations.

Download Description

This utility will provide the ability to update the connection string of IBM Cognos PowerCube data sources.

For example, You may be importing a deployment into production from a staging area. The network location of your mdc files in your production environment may differ from your staging area. You can use this utility to perform bulk updates of the data source connection strings to reflect the production location.

Prerequisites

  • Sun Microsystems Java Runtime Environment (JRE)
    • JRE version 1.4.x or higher must be installed
    • Sun Microsystems Java (java) must be in the system path
    • JAVA_HOME environmental variable must be set
  • IBM Cognos 8 BI Version 8.4 RTM or higher
  • Not intended to work with Secure Sockets Layer (SSL)
  • Must have IBM Cognos PowerCube datasources in IBM Cognos Content Store
  • We highly recommend that your IBM Cognos Content Store be backed up prior to using this utility.

Installation Instructions

  • How to install Uncompress the file updatedatasource.zip under the IBM Cognos 8 BI install directory.
    • How to run
    a) from a Microsoft Windows DOS command prompt, cd to the directory containing the utility and enter the command updatedatasources.bat with the parameters required.
    b) from a UNIX command prompt, cd to the directory containing the utility and enter the command ./updatedatasources.sh with the parameters required.

    • Usage:

    -oldwinpath windowspath | -oldunixpath unixpath
    -newwinpath windowspath | -newunixpath unixpath
    -dispatcherurl dispatcherURL[-servergroup serverGroup][-user userName -password userPassword -namespace userNamespace]
    [-oldwinpathseparator windowspathseparator][-oldunixpathseparator unixpathseparator][-newwinpathseparator windowspathsep
    arator][-newunixpathseperator unixpathseparator][-preview]
    • Example:

    updatedatasources.bat -oldwinpath "C:\Program Files\cognos\c8\webcontent\samples\datasources\cubes\PowerCubes\old" -newwinpath "E:\Program Files\cognos\c8\webcontent\samples\datasources\cubes\PowerCubes\new" -dispatcherurl http://server_name:9300/p2pd/servlet/dispatch -user administrator -password admin1234 -namespace Default

    Mandatory Parameters:
    -oldwinpath windowspath|-oldunixpath unixpath
    Fully qualified path to old windows/unix cube hierarchy. If the path contains spaces and is enclosed in quotes, do not end the path with backslash.
    Default: none
    -newwinpath windowspath|-newunixpath unixpath
    Fully qualified path to new windows/unix cube hierarchy. If the path contains spaces and is enclosed in quotes, do not end the path with backslash.
    Default: none
    -dispatcherurl dispatcherURL
    URL for the IBM Cognos 8 BI dispatcher.
    Default: none
    • Optional Parameters:
    -servergroup serverGroup
    Name of the server group containing dispatchers with access to data sources.
    Default: "" <empty string>
    -user userName
    User to log on as. Must exist in 'userNamespace'.
    Default: none
    -password userPassword
    Password for 'userName' in 'userNamespace'.
    Default: none
    -namespace userNamespace
    Security namespace to log on to.
    Default: none
    -oldwinpathseparator
    Windows file path separator character for old winpath
    Default: '\'.
    -newwinpathseparator
    Windows file path separator character for new winpath
    Default: '\'.
    -oldunixpathseparator
    Unix file path separator character for old unixpath
    Default: '/'.
    -newunixpathseparator
    Unix file path separator character for new unixpath
    Default: '/'.
    -preview
    Flag to specify preview mode (does not update content store)
    -help
    Display this usage message
  • Download package


    Download RELEASE DATE LANGUAGE SIZE(Bytes) Download Options
    UpdateDataSources Utility 28/01/2009 English 17834 FTP
    UpdateDataSources Utility (UNIX) 06/01/2009 English 16844 FTP

    Technical support

    If you are unable to download this product, please log a PMR or Email: diagtool@ca.ibm.com

    Disclaimer(s)

    http://www.ibm.com

    Cross Reference information
    Segment Product Component Platform Version Edition
    Business Analytics Cognos Business Intelligence PowerPlay Server AIX, HP-UX, Solaris, Windows 8.4

    Rate this page:

    (0 users)Average rating

    Document information


    More support for:

    Cognos 8 Business Intelligence
    PowerPlay Server

    Software version:

    8.4

    Operating system(s):

    AIX, HP-UX, Solaris, Windows

    Reference #:

    4021276

    Modified date:

    2010-03-20

    Translate my page

    Machine Translation

    Content navigation