Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

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

    Posted 20 days ago

    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 17 days ago

    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 16 days ago

    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 8 days ago
    Edited by Jesper Poulsen 8 days ago

    Hi Stuart

    I suppose you mean Satellite Connector and not Secure Gateway



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

    Original Message


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

    Posted 7 days ago

    Hi Jesper,

    You are correct, good catch.



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

    Original Message


Related Content