Cognos Analytics

 View Only
  • 1.  Real time update of Excel file on Cognos Analytics possible?

    IBM Champion
    Posted Sat March 25, 2023 08:32 AM
    Edited by Rajeev Bagra Sat March 25, 2023 08:45 AM

    Just started with Cognos Analytics. 

    While I could upload the Excel file (.xlsx), is there a way so that any change made in the Google Sheets (from where .xlsx file downloaded) file updated here on Cognos Analytics as well?



    ------------------------------
    Rajeev Bagra
    ------------------------------



  • 2.  RE: Real time update of Excel file on Cognos Analytics possible?

    IBM Champion
    Posted Sat March 25, 2023 09:09 PM
    You may want look at finding an ODBC driver for Cognos to connect to Google Sheets as a data source.

    Logan Whitaker

    PMO, HEB Supply Chain Planning & Operations

    o: 210.938.6043 m: 210.429.3181

    e: whitaker.logan@heb.com







  • 3.  RE: Real time update of Excel file on Cognos Analytics possible?

    IBM Champion
    Posted Sun March 26, 2023 02:32 AM

    Any marketplace to search for?



    ------------------------------
    Rajeev Bagra
    ------------------------------



  • 4.  RE: Real time update of Excel file on Cognos Analytics possible?

    IBM Champion
    Posted Sun March 26, 2023 01:41 PM
    Google "ODBC Driver Google Sheets". It'll be made by Goggle.

    Logan Whitaker

    PMO, HEB Supply Chain Planning & Operations

    o: 210.938.6043 m: 210.429.3181

    e: whitaker.logan@heb.com