Devops in PA/TM1

Post Reply
prushbalaji
Posts: 2
Joined: Sun Nov 24, 2019 1:36 pm
OLAP Product: IBM Planning Analytics
Version: 2.8.6
Excel Version: Office 365

Devops in PA/TM1

Post by prushbalaji »

Any devops tool can be leveraged to do the operational activities such deployment/logfile movement / Data validation /Server monitoring in TM1/Planning analytics ??
Bakkone
Posts: 119
Joined: Mon Oct 27, 2014 10:50 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: Devops in PA/TM1

Post by Bakkone »

Notepad++ is great... I also write my TI-processes in Architect.
prushbalaji
Posts: 2
Joined: Sun Nov 24, 2019 1:36 pm
OLAP Product: IBM Planning Analytics
Version: 2.8.6
Excel Version: Office 365

Re: Devops in PA/TM1

Post by prushbalaji »

Hi thanks for your response . Can you please let me know what are all the activities you are performing through Notepad++
lotsaram
MVP
Posts: 3654
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Devops in PA/TM1

Post by lotsaram »

I rather think that Bakkone was pulling your leg. :roll:
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Bakkone
Posts: 119
Joined: Mon Oct 27, 2014 10:50 am
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2013

Re: Devops in PA/TM1

Post by Bakkone »

Devops is not about tools. Devops is about processes.

Part of my development process is looking in log files. I use notepad++ for that.
luizg2019
Posts: 41
Joined: Thu Sep 12, 2019 11:02 pm
OLAP Product: TM1 - PAX-PAW-Perspectiv-Arc
Version: PA 2.0.9 - PAW 2.0.73
Excel Version: office 2016

Re: Devops in PA/TM1

Post by luizg2019 »

prushbalaji wrote: Mon Nov 25, 2019 5:27 pm Any devops tool can be leveraged to do the operational activities such deployment/logfile movement / Data validation /Server monitoring in TM1/Planning analytics ??
Deployment: Managing TM1 database assets with Git

Server monitoring: If you're talking about RAM, CPU, etc, P.A.Workspace has a nice monitoring feature. Or if you want more detailed data you should use Performance Monitor
PlanningDev
Community Contributor
Posts: 349
Joined: Tue Aug 17, 2010 6:31 am
OLAP Product: Planning Analytics
Version: 2.0.5
Excel Version: 2016

Re: Devops in PA/TM1

Post by PlanningDev »

Searching log files - Notepad++ and FileSeek (FileSeek is amazing as you can search the transaction logs and filter for keywords, by modified dates, etc.

Dev Lifecycle - JIRA and for a lite version of code compare you can use BitBucket/Fisheye although I wouldn't reccommend using for direct deployment
(As posted above, the GIT integration is new but could be interesting)

Deployment - TM1 REST API, we have tools to search for text in TI processes, deploy objects live, etc. Take a look at Postman, Cubewise has a blog about it
EvgenyT
Community Contributor
Posts: 324
Joined: Mon Jul 02, 2012 9:39 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: 2016
Location: Sydney, Australia

Re: Devops in PA/TM1

Post by EvgenyT »

Although not free, Pulse (by Cubewise) has all monitoring, deployment and change control tools you need.
Also, their Arc product is good for writing code (snippets, auto-indent etc).

Likewise, I used Rest API for hot promotion, although not extensively. Furthermore, I have got a few PowerShell scrips I use for regular model maintenance. There are also some Python libraries that can be used.

P.s. Not paid advertisement :)

Thanks

Evgeny
MGrain
Posts: 16
Joined: Wed Nov 15, 2017 11:36 am
OLAP Product: TM1
Version: Various
Excel Version: Various

Re: Devops in PA/TM1

Post by MGrain »

I recently discovered BareTail https://www.baremetalsoft.com/baretail/

Very useful for looking at log files on a running TM1 instance.
kaazimraza
Posts: 95
Joined: Mon Jun 25, 2012 6:58 am
OLAP Product: TM1, SSAS, Power BI
Version: 10.2.2
Excel Version: 2016

Re: Devops in PA/TM1

Post by kaazimraza »

EvgenyT wrote: Wed Dec 04, 2019 9:55 am Although not free, Pulse (by Cubewise) has all monitoring, deployment and change control tools you need.
Also, their Arc product is good for writing code (snippets, auto-indent etc).

Likewise, I used Rest API for hot promotion, although not extensively. Furthermore, I have got a few PowerShell scrips I use for regular model maintenance. There are also some Python libraries that can be used.

P.s. Not paid advertisement :)

Thanks

Evgeny
Are you able to share the code for hot promotion? I have been trying to do it via REST API with no success. Appreicaite.

Thanks
Kaz
Thanks,

Kaz
Post Reply