Cognos Analytics

 View Only
  • 1.  CA 11.1; RRD-file as data source

    Posted Fri March 29, 2019 04:24 AM

    Hello all,
    how can I include the data of a RRD-file (Round Robin Database) into Cognos Analytics 11.1?

    Querying a RRD-file is usually done on CLI or in a script (shell,perl, ...) with a special command, like: "rrdtool fetch <myFile.rrd> AVERAGE"
    and the output is like (example):

     Timestamp    Value1                           Value2
    1553679900 7.0000000000e+01 1.1200000000e+01
    1553680800 7.0000000000e+01 1.1200000000e+01
    1553681700 7.0000000000e+01 1.1900000000e+01

    Question now is, how can I include the RRD-file or the command or a script into CA to create some reports from it?

    Many thanks in advance!!
    Regards, Juergen



    ------------------------------
    Juergen Blecker
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: CA 11.1; RRD-file as data source

    Posted Tue April 02, 2019 09:01 AM
    Edited by System Fri January 20, 2023 04:17 PM

    Hello @Juergen Blecker
    It's currently not possible to connect Cognos Analytics to a Round Robin Database.

    I would suggest using a supported database vendor.  You can view the supported environments page here

    Or you can export as a flat file and import the flat file into Cognos.



    ------------------------------
    DENNY NAREZNY
    ------------------------------