Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only
  • 1.  PAW - ODBC

    Posted 06/24/19 10:34 AM
    Helo 

    is there a way how to create an ODBC connection in PAW? TI processes already created in PM are running but when I want to create a new TI in PAW using ODBC it doesnt even offer odbc connections.
    I am using PAW v2.0.30.

    Thanks for any help.

    ------------------------------
    Peter
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: PAW - ODBC

    Posted 06/24/19 02:32 PM
    Hi Peter,

    For PA Local, it would be the same as what you have done. Create an ODBC in Windows where you have data tier (TM1 database) installed.

    ------------------------------
    Tom Kim
    ------------------------------



  • 3.  RE: PAW - ODBC

    Posted 06/24/19 04:42 PM
    Hi Tom

    so PAW offers odbc in menu for TI only for cloud version? In PAW local the only way to import data is import a file? 
    Thanks in advance

    ------------------------------
    peter kolesar
    ------------------------------



  • 4.  RE: PAW - ODBC

    Posted 06/24/19 06:34 PM
    Hi Peter,

    Using PAW in PA Local setup
    - Create an ODBC connection in Windows where you have data tier (TM1 database) installed.
    - Log into PAW and create a new process.
    - Click on 'DB Connection', then the ODBC connection you created should be available to select.
    Now this is tested with PAW version 41 and after, so if this is not available version 30 that you have, then it must have been introduced some version in between. You should upgrade PAW or use Architect to create a new TI process instead.

    Regarding 'ODBC menu for cloud version' you mentioned above, I believe you're referring to Secure Gateway. It's only available in cloud because you don't need it in PA Local. Secure Gateway is provided with PA Cloud because customers don't have a direct access to data tier to create ODBC connections.

    ------------------------------
    Tom Kim
    ------------------------------