Planning Analytics

 View Only
  • 1.  Integration to Cloudera Data Science Workbench (CDSW)

    Posted 11 days ago

    Hello everyone,

    Is there any of you who are experienced with integration between IBM Planning Analytics and Cloudera Data Science Workbench?

    Any information/story is much appreciated.

    Thank you.

    Best regards,

    Def



    ------------------------------
    Def Marshal
    ------------------------------


  • 2.  RE: Integration to Cloudera Data Science Workbench (CDSW)

    IBM Champion
    Posted 10 days ago

    Hi Def, I don't have experience with the Cloudera Data Science Workbench, but you should be able to integrate both using the REST APIs.

    And curious, what is your use case for this integration?



    ------------------------------
    Vlad Didenko
    Founder at Succeedium
    TeamOne Google Sheets add-on for IBM Planning Analytics / TM1
    https://succeedium.com/teamone/
    Succeedium Planning Analytics Cloud Extension
    https://succeedium.com/space/
    ------------------------------



  • 3.  RE: Integration to Cloudera Data Science Workbench (CDSW)

    Posted 10 days ago

    Hi Vlad,

    The integration is intended to pull machine learning forecasted data into IBM PA. 

    Just to confirm, by using REST API did you mean TM1py?

    Best regards,

    Def



    ------------------------------
    Def Marshal
    ------------------------------



  • 4.  RE: Integration to Cloudera Data Science Workbench (CDSW)
    Best Answer

    IBM Champion
    Posted 10 days ago

    By "REST API," I am referring to the TM1 REST API (https://www.ibm.com/docs/en/planning-analytics/2.1.0?topic=analytics-tm1-rest-api) and the Cloudera Data Science Workbench API (https://docs.cloudera.com/cdsw/1.10.5/jobs-pipelines/topics/cdsw-rest-apis.html).

    TM1py is a Python package that makes working with the TM1 REST API in Python much simpler. However, you can also use the TM1 REST API with other programming languages.

    You should verify if the Cloudera Data Science Workbench API allows you to export the data to a text file. If it does, you can utilize the TM1 REST API to upload it to IBM Planning Analytics, here is an example of using TM1py: https://code.cubewise.com/blog/loading-data-into-a-tm1-cube-with-tm1py/

    You can use SPACE to create, run and schedule your Python scripts directly in PAW:



    ------------------------------
    Vlad Didenko
    Founder at Succeedium
    TeamOne Google Sheets add-on for IBM Planning Analytics / TM1
    https://succeedium.com/teamone/
    Succeedium Planning Analytics Cloud Extension
    https://succeedium.com/space/
    ------------------------------