Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

  • 1.  Help with integration between TM1 and Databricks

    Posted 12/05/25 02:22 PM

    Hello IBM Community members,

    Greetings!

    Am looking for best options for a seamless yet efficient data transfer between TM1 and Databricks.

    I heard ODBC is an option but goes slow, REST API could be another option, there are few 3rd party tools too.

    Can you pls. suggest what's the best approach for a voluminous data transfer between these two systems?

    Also, do we have any client case study where it done and found to be flawlessly working?

    Would definitely appreciate your help in this regards.

    Thank you!

    Regards,

    Mandar



  • 2.  RE: Help with integration between TM1 and Databricks

    Posted 12/08/25 02:26 AM

    Hi Mandar,

    There are different connection options and it depends how and where you run TM1. Are you on-prem, PAoC or PAaaS?

    We have configured the REST API with on-prem, PAoC and PAaaS to cloud DBs, with different degrees of complexity, so it all can be done and has been proven. There is no seamless connectors yet, but it also does not take that long to setup and test these connections. If you are on PAaaS, you can use the ExecuteHttpRequest function to connect to the view, export the Json and import via TI.

    You can look at this GET function, https://community.ibm.com/community/user/blogs/edward-stuart/2023/10/13/executehttp. 

    Francois



    ------------------------------
    Francois Kritzinger
    Venn Cubed (Pty) Ltd
    Cape Town
    ------------------------------



  • 3.  RE: Help with integration between TM1 and Databricks

    Posted 12/08/25 05:31 AM

    Hi Mandar,

    Cubewise have developed an Atmosphere connector for seamless integration between TM1 & Databricks:

    https://code.cubewise.com/software/products/atmosphere/atmosphere-features/

    If you would like to discuss in more detail, feel free to reach out to me at cyate@cubewise.com

    Thanks

    Chris



    ------------------------------
    Chris Yate
    Business Development Manager
    Cubewise
    ------------------------------



  • 4.  RE: Help with integration between TM1 and Databricks

    Posted 12/08/25 11:12 PM

    Hi Mandar,

    You can also take a look at SPACE https://succeedium.com/space/
    It extends Planning Analytics with automation, Python integration, and workflow capabilities, and many teams use it to orchestrate TM1 data extractions, transformations, and cloud integrations without relying on ODBC.

    Feel free to reach out and I'd be happy to show you a few examples.



    ------------------------------
    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/
    ------------------------------



Related Content