Cognos Analytics

 View Only
Expand all | Collapse all

Importing Excel into Data Module via Schedule

  • 1.  Importing Excel into Data Module via Schedule

    Posted Wed November 04, 2020 11:15 AM
    I'm currently on Cognos Analytics 11.0 and was wondering is there a way to automatically load an Excel document into a data module so that we can maintain this daily to pull into a report.  I've done this manually, but finding a more automated way to have this run daily.  I have a way to drop a file into a Cognos folder, but not sure how to pick it up to import.

    Cesar Garcia

    ------------------------------
    Cesar Garcia
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Importing Excel into Data Module via Schedule

    Posted Wed November 04, 2020 03:17 PM
    As per my understanding, It can be done with help of Jupyter Notebook or REST API in CA 11.1.7.

    ------------------------------
    Buddhi Gupta
    ------------------------------



  • 3.  RE: Importing Excel into Data Module via Schedule

    Posted Wed November 04, 2020 06:13 PM
    I think if you replace the excel file in the Cognos folder, the data module using it will read from the new one.

    ------------------------------
    Mauro Santos Otero
    ------------------------------



  • 4.  RE: Importing Excel into Data Module via Schedule

    Posted Thu November 05, 2020 11:50 AM
    I'll look into updating the file and see how it works.  Thanks for the recommendation.

    ------------------------------
    Cesar Garcia
    ------------------------------



  • 5.  RE: Importing Excel into Data Module via Schedule

    Posted Thu November 05, 2020 04:04 PM
    Do you know of a way to add a new file on a schedule?

    ------------------------------
    Cesar Garcia
    ------------------------------



  • 6.  RE: Importing Excel into Data Module via Schedule

    Posted Thu November 05, 2020 07:08 PM
    I think to add a new file then you need to consider the new REST API or Notebooks as mentioned above.  While I enjoy automation this kind of stuff, I think manually dropping the new excel file in Cognos would be a more efficient solution.

    ------------------------------
    Mauro Santos Otero
    ------------------------------



  • 7.  RE: Importing Excel into Data Module via Schedule

    Posted Sat November 07, 2020 09:39 AM
    I just double checked the available APIs with the new REST interface in 11.1.7 and I don't see a file update API. Just ones for GET and DELETE. Maybe in an upcoming release IBM will add it. I think implementing a Jupyter notebook to update the data set is the only currently supported method. You can double check the available APIs with: https://<cognos_analytics_server>:<port>/api/api-docs

    ------------------------------
    Robert Hofstetter
    ------------------------------



  • 8.  RE: Importing Excel into Data Module via Schedule

    Posted Mon November 23, 2020 11:09 AM
    you can use Apparo for CA for that, it has an Excel data interface for that, importing Excel data of files automatically into a database table,

    https://apparo.solutions/index.php/en/product/excel-interfaces

    ------------------------------
    Markus Körber
    ------------------------------



  • 9.  RE: Importing Excel into Data Module via Schedule

    Posted Mon November 23, 2020 05:48 PM
    What's the difference between using apparo and uploading the excel file into cognos ?

    ------------------------------
    Mauro Santos Otero
    ------------------------------