Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only
  • 1.  Driver for MS Fabric and how to setup

    Posted Mon January 27, 2025 03:33 AM

    Hello!

    We have a PA onPremis 2.0.9.19 Solution running (without workspace) and have to connect to a new MS Fabric Cloud solution.

    Is there any driver v available and to you have experience in setting up such a driver. Or how to connect to MS Fabric via PA Local.

    Thanks a lot,



    ------------------------------
    Andreas Schuster
    ------------------------------


  • 2.  RE: Driver for MS Fabric and how to setup

    Posted Tue January 28, 2025 03:54 AM

    Hi Andreas,

    When you say 'connect to a new MS Fabric Cloud solution' would it be fair to assume that what you want to do is load data using TI from one of the tables in MS Fabric?

    Since you are using TM1 v11 the only real options you have is flat files and ODBC. AFAIK a recent ODBC driver for SQL Server can be used to connect to MS Fabric, have you explored that option? 



    ------------------------------
    Hubert Heijkers
    STSM, Program Director TM1 Functional Database Technology and OData Evangelist
    ------------------------------



  • 3.  RE: Driver for MS Fabric and how to setup

    Posted Tue January 28, 2025 06:42 AM

    Thanks for you help.

    Yes, I meant connect via ODBC for importing data.

    I will check your hint with the driver and come back to you.

    Many thanks,

    Andreas



    ------------------------------
    Andreas Schuster
    ------------------------------