Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

  • 1.  SAAS - Import and Export Data from SQL-Server

    Posted Fri April 25, 2025 11:57 AM

    Hello to all!

    We want to exchange data from planning analytics to SQL-Server (import from and export to).

    Any best practice examples available or resources for learning how to do it in a fast way?

    How is this working when using planning analytics SAAS in the cloud (planning analytics and sql-server eg. hosted in azure cloud).

    Thanks for hints,

    Andreas



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


  • 2.  RE: SAAS - Import and Export Data from SQL-Server

    Posted Mon April 28, 2025 07:05 AM

    Hi Andreas,

    A bit more detail might help.  Can you confirm if you are using Planning Analytics on Cloud (IBM Cloud) or Planning Analytics SaaS (AWS or Azure)?  If you are using Planning Analytics on Cloud then you would likely want to create a TI process that uses an ODBC data source.  This requires an ODBC data source to be configured in the Secure Gateway feature in the administration area of Planning Analytics Workspace.  Some cloud based data sources may require you to open a support ticket to have the data source configured.  Our TI processes can also write to SQL databases using the ODBCOpen, ODBCOutput, and ODBCCloud functions.  If you are using Planning Analytics SaaS you might want to determine if you can leverage the new ExecuteHTTPRequest TI function to issue SQL statements (both select and insert) to the REST API for the SQL data source.  ODBC is still possible in Planning Analytics SaaS, but required our ODBC Data Connector.



    ------------------------------
    Stuart King
    Product Manager
    IBM Planning Analytics
    ------------------------------

    Original Message


  • 3.  RE: SAAS - Import and Export Data from SQL-Server

    Posted Tue April 29, 2025 04:05 AM

    Hello Stuart!

    That's already a great help. We are planning the future architecture of our solution and PA SAAS could be part of it. Still investigation and what our options are.

    Thanks a lot.

    Andreas



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

    Original Message


  • 4.  RE: SAAS - Import and Export Data from SQL-Server

    Posted 2 days ago

    Hi @Andreas Schuster,

    Curious if you have decided on an approach on exporting data from Planning Analytics to SQL Server?  If yes, how is it working for you?

    Thanks,



    ------------------------------
    Quin Kan
    ------------------------------

    Original Message


  • 5.  RE: SAAS - Import and Export Data from SQL-Server

    Posted Wed May 07, 2025 03:35 PM
    Edited by Jesper Poulsen Wed May 07, 2025 03:35 PM

    Hi Stuart

    I suppose you mean Satellite Connector and not Secure Gateway



    ------------------------------
    Kind regards,
    Jesper Poulsen
    ------------------------------

    Original Message


  • 6.  RE: SAAS - Import and Export Data from SQL-Server

    Posted Thu May 08, 2025 09:22 AM

    Hi Jesper,

    You are correct, good catch.



    ------------------------------
    Stuart King
    Product Manager
    IBM Planning Analytics
    ------------------------------

    Original Message


  • 7.  RE: SAAS - Import and Export Data from SQL-Server

    Posted 2 days ago

    Hi @STUART KING or fellow community members,

    We are also looking into transferring the data from TM1 to SQL Server, and I came across Andreas' post. 

    Wonder in terms of speed, would ODBC have decent speed?  I do not have the amount of data we are transferring for you to assess

    In comparing between ODBC and ExecuteHTTPRequest, is one faster than the other?

    The team who manages the TM1 server is suggesting to export the data into files, and we can use the files for loading into the SQL database.  I read somewhere that using ODBC is slower than using flat files.  Wonder if it is always the case.

    Thanks






    ------------------------------
    Quin Kan
    ------------------------------

    Original Message


Related Content