Hi All,
We are about to start the TM1 upgradation to Planning Analytics IBM Cloud environment and currently the On-premise Tm1 is using the external scheduling utility Autosys to run the TI jobs. But we would like to know if the Autosys jobs can be configurable with the IBM Cloud server details to run the TI process of PA in cloud?? Does anyone have come across this kind of requirement? If yes, could anyone please give some information and what parameters needs to be configured in an AutoSys job.
Planning Analytics Upgrade with Autosys Utility
-
- Posts: 44
- Joined: Thu May 01, 2014 12:46 pm
- OLAP Product: Cognos TM1
- Version: 10.2
- Excel Version: 2010
-
- MVP
- Posts: 2836
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: Planning Analytics Upgrade with Autosys Utility
If you are about to go to the cloud then you should ask your implementation coordinator at IBM this question. I've never used this tool before but if it requires you to install something on the TM1 server then you are not going to be able to do this on the IBM cloud machine. For automation IBM offers the Cognos Command Center tool as part of your cloud implementation.krithika331 wrote: ↑Wed Dec 30, 2020 9:53 am Hi All,
We are about to start the TM1 upgradation to Planning Analytics IBM Cloud environment and currently the On-premise Tm1 is using the external scheduling utility Autosys to run the TI jobs. But we would like to know if the Autosys jobs can be configurable with the IBM Cloud server details to run the TI process of PA in cloud?? Does anyone have come across this kind of requirement? If yes, could anyone please give some information and what parameters needs to be configured in an AutoSys job.
-
- Regular Participant
- Posts: 227
- Joined: Wed May 06, 2020 2:58 pm
- OLAP Product: Planning Analytics
- Version: 2.0.9
- Excel Version: 2016
Re: Planning Analytics Upgrade with Autosys Utility
Hi, I've not used autosys before but I would certainly ask IBM this as I'd expect it to be achievable. If it's a client based tool you could try installing it onto the rdp machine, transferring the installation files across using ftps tool like filezilla. Not sure if you'll have admin privileges to install but could try.
Alternatively if you're just looking to run ti's on a schedule outside of chores you could trigger the process via tm1runti using Powershell/command line, and schedule them using Windows scheduler.
Alternatively you could trigger the process via rest api from outside of the cloud server/rdp sessions
Hope this gives you some ideas
Alternatively if you're just looking to run ti's on a schedule outside of chores you could trigger the process via tm1runti using Powershell/command line, and schedule them using Windows scheduler.
Alternatively you could trigger the process via rest api from outside of the cloud server/rdp sessions
Hope this gives you some ideas
-
- Regular Participant
- Posts: 227
- Joined: Wed May 06, 2020 2:58 pm
- OLAP Product: Planning Analytics
- Version: 2.0.9
- Excel Version: 2016
Re: Planning Analytics Upgrade with Autosys Utility
OK did a bit of research on autosys, if IBM won't let you install autosys on the cloud server, you can replace the jobs on autosys to make rest api calls to trigger the request/process
The below link will show you how to set up api calls from autosys. When you move to the cloud you'll be given connection details for the api in the welcome pack.
Once you have that I suggest installing a tool called postman (client tool) this will allow you to test the rest api calls to your cloud environment. The tricky part is passing credentials across but IBM should be able to assist you with this. If you need examples of api just search tm1 rest api, you should find what you need on IBMs website.
https://www.google.com/search?q=autosys ... =647&dpr=3#
The below link will show you how to set up api calls from autosys. When you move to the cloud you'll be given connection details for the api in the welcome pack.
Once you have that I suggest installing a tool called postman (client tool) this will allow you to test the rest api calls to your cloud environment. The tricky part is passing credentials across but IBM should be able to assist you with this. If you need examples of api just search tm1 rest api, you should find what you need on IBMs website.
https://www.google.com/search?q=autosys ... =647&dpr=3#