Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only
Expand all | Collapse all

Replacement for ExecuteCommand function in IBM PA Cloud

  • 1.  Replacement for ExecuteCommand function in IBM PA Cloud

    Posted Mon July 14, 2025 12:38 PM

    Hi,

    We have .bat scripts called from TI process to copy/move files to another directory, zip files, send email out and FTP in/out in our on-prem environment.

    can you pls suggest some alternate ways for us to achieve the same when we execute TI from IBM PA on cloud? 

    is there any way to do this without using IBM Command Center? 

    Thanks. 



    ------------------------------
    Jaganathan C P
    ------------------------------


  • 2.  RE: Replacement for ExecuteCommand function in IBM PA Cloud

    Posted Tue July 15, 2025 02:16 AM

    Hello,

    This still works in IMB PAoC. Just make sure to have the right executables on the S: drive of the remote IBM PC.



    ------------------------------
    Wim Gielis
    Senior Consultant
    Aexis International
    Sint-Stevens-Woluwe
    +32496225001
    ------------------------------



  • 3.  RE: Replacement for ExecuteCommand function in IBM PA Cloud

    Posted Tue July 15, 2025 09:43 AM

    Hi Wim,

    Thanks for your response. Does this mean we have to request IBM support to install FTP client like Winscp on IBM cloud? 



    ------------------------------
    Jaganathan C P
    ------------------------------



  • 4.  RE: Replacement for ExecuteCommand function in IBM PA Cloud

    Posted Tue July 15, 2025 10:03 AM

    I always use FileZilla and 7zip. Then I use FileZilla to have 7zip on that machine.

    Email can be done with PowerShell scripts or your existing scripts, provided the connections are fine.

    FTP to in premise, I never had a need for it.



    ------------------------------
    Wim Gielis
    Senior Consultant
    Aexis International
    Sint-Stevens-Woluwe
    +32496225001
    ------------------------------



  • 5.  RE: Replacement for ExecuteCommand function in IBM PA Cloud

    Posted Wed July 16, 2025 07:56 AM

    Q:
    "Does this mean we have to request IBM support to install FTP client like Winscp on IBM cloud?"

    A:
    No.
    Every PAoC environment includes a FTP server to enable file transfers to and from the environment's Shared Folder aka it's S:\ drive.
    For the credentials (user and password) see the environment's Welcome Kit.


    Links:

    1.1)
    https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=folder-copying-local-files-planning-analytics
    Copying local files to IBM Planning Analytics

    Your IBM Planning Analytics system includes a dedicated shared folder for storing and transferring data files. You can copy files between your local computer and the IBM Planning Analytics system shared folder with a File Transfer Protocol Secure (FTPS) application.

    1.2)
    https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=cloud-file-transfer-protocol-secure-ftps-connections
    File Transfer Protocol Secure (FTPS) connections

    FTPS is configured in passive mode, with Port 21 for the initial connection and the port range of 4460 to 4500 for the data connection.

    2)
    https://community.ibm.com/community/user/blogs/marianne-obichebendu/2025/01/17/planning-analytics-on-cloud
    posted Fri January 17, 2025 
    The New Centralized File Transfer Platform for Planning Analytics On Cloud

    3)
    https://community.ibm.com/community/user/blogs/paul-hart-prieto/2024/05/02/setup-pa-on-cloud-file-transfer
    posted Fri May 31, 2024
    Setup PA on Cloud file transfer

    4)
    https://community.ibm.com/community/user/blogs/yin-chu/2023/05/26/paoc-getting-started-checklist
    posted Fri May 26, 2023
    Planning Analytics on Cloud Getting Started Checklist

    FTPS test
    - Your welcome kit will initially provide credentials for login to the Planning Analytics shared folder by FTPS
    - Alternatively you can switch to SFTP with a support case at which time you can also provide a SSH public key for increased security



    ------------------------------
    Bernd Siebert
    ------------------------------



  • 6.  RE: Replacement for ExecuteCommand function in IBM PA Cloud

    Posted Thu July 17, 2025 10:01 AM

    Berndt, I think you didn't take in Jaganathan's query. He was asking about an FTP client  and you were responding about an FTP server. We have a client which needed to send files from TM1 to an external destination. I asked IBM about installing a client (in this case WinSCP portable) and they said it was up to us. Developing was 'interesting' but worked in the end.



    ------------------------------
    David Usherwood
    ------------------------------



  • 7.  RE: Replacement for ExecuteCommand function in IBM PA Cloud

    Posted Tue July 15, 2025 09:26 AM

    In case you're referring to PA SaaS on AWS, we can build those capabilities back in using native AWS services.  Take a look at this offering called PyxisPA: https://aws.amazon.com/marketplace/pp/prodview-jtrizsjhuklnw

    ... and drop me a note if you're interested in exploring this.  Happy to help.



    ------------------------------
    Brian Simpson
    Senior Director, Data & AI
    Converge Technology Solutions
    Toronto ON
    ------------------------------



  • 8.  RE: Replacement for ExecuteCommand function in IBM PA Cloud

    Posted Tue July 15, 2025 09:39 AM

    Hi Brian, we are on IBM Cloud. 



    ------------------------------
    Jaganathan C P
    ------------------------------



  • 9.  RE: Replacement for ExecuteCommand function in IBM PA Cloud

    Posted Wed July 16, 2025 07:40 AM

    On Planning Analytics on Cloud (PAoC) you can run batch-scripts using the TI fct ExecuteCommand as you did on your on premise environment.

    For instance see the IBM technote

        https://www.ibm.com/support/pages/planning-analytics-cloud-backup-process-using-powershell-script
        Planning Analytics on Cloud - Backup process using PowerShell script

        Summary
        A Planning Analytics administrator would like to perform their own backup of the Planning Analytics Data folder by using a Planning Analytics Turbo Integrator process.
        For security reasons, third-party utilities (for example 7-zip) cannot be installed on the Cloud.

    outlining how to run a PowerShell-script (to backup and compress the database directory) triggered by the TI fct ExecuteCommand.  The PowerShell-script itself is stored on the Shared Folder which is attached as the S:\ drive to the PAoC environment.


    The same task (to backup and compress the database directory) can also be achieved using the standalone version or runtime version or portable version 7za.exe of the 7-Zip tool

        https://7-zip.org/a/7z2500-extra.7z
        7-Zip Extra: standalone console version, 7z DLL, Plugin for Far Manager

    see the web page

        https://cogknowhow.tm1.dk/archives/249
        Script to backup TM1 data folder to a ZIP file


    As outlined by the previous IBM technote, you cannot install any software on your PAoC environment. But if there is a standalone version or runtime version or portable version of said software, which can be invoked by a command line command or executed by a batch-script, you can upload it to the Shared Folder aka the S:\ drive of your PAoC environment and trigger it using the TI fct ExecuteCommand.



    ------------------------------
    Bernd Siebert
    ------------------------------



  • 10.  RE: Replacement for ExecuteCommand function in IBM PA Cloud

    Posted Mon July 21, 2025 12:25 PM

    Thanks all. We are able to use PowerShell scripts to do the backup, housekeeping and emailing for IBM PA Cloud.

    For FTP of files for inbound and outbound via scripts, do we have any FTP client installed on IBM PA cloud already and available for cloud customers? If not, can we copy WinSCP exe/com to IBM PA cloud and build the FTP script?  If copying the exe is considered as security risk, is there any alternate way to automate FTP the files to and from cloud?  



    ------------------------------
    Jaganathan C P
    ------------------------------