When will a SAP IQ Cockpit replacement be available

[former_member725545]

Hi,

Obviously Flash EOL has seriously compromised Cockpit for SAP IQ. I've seen the document around how to use the Command Line and that is ok to a point -but it's really not the answer as such. Also, various posts that an alternative is being looked at (going back as far as 2018). Can anyone shed any light as to when we might expect to see a replacement written and made available? Seems really odd that it's just been left like this?

[RolandKramer]

Hello eduardo.marques2

the invest in on-premise tools is already stopped years ago and the engineers of IQ missed the opportunity in 2016 to develop a HTML5-based tool.

Furthermore, the IQ development thinks the SQL based monitoring is sufficient - SAP IQ Cockpit Non-GUI Administration and Monitoring and the DBACOCKPIT is unfortunately only usable for SAP NetWeaver Customers
DBA Guide for SAP on SAP IQ that is the correct assumption.

best regards Roland

[RolandKramer]

Hello timdba

By now, you can you the new DBACOCKPIT for IQ, if you are using on of the SAP standard scenarios NLS/DTO or ILM.

See the Blog - enable SAP IQ for DBACOCKPIT

best regards Roland

[eduardo_marques2]

Not quite the same unfortunately. Not a BASIS guy, but as far as I know, DBACOCKPIT requires Netweaver or SolMan. Many customers, perhaps most, are pre-SAP installations running IQ as a RDBMS. I know quite a few. Customers running only ASE and/or IQ, and no other SAP product. For those customers the costs associated with installing, configuring, running and maintaining a Netweaver/SolMan installation would most likely be higher than buying a tool do it. But the point is why not replace COCKPIT with a HTML5-based tool ?

[former_member725545]

Hi Steve,

Sorry for the delay. I'm afraid I didn't really get anywhere with DBArtisan in the end. I did give it a go and I do recall struggling with it. I can't remember exactly what the issue was now but I did hit a wall pretty quickly and couldn't muster up the tenacity to go any further with it. We are 16.1, so suspect it'll have been a similar issue to what you are encountering. In the end I resorted to scripting my own basic monitoring that sends REST API calls to generate notifications. Not holding my breath for SAP to release anything but you never know.

[former_member725545]

Thanks Raymond. I had a look at Ruffle too and yeah as you say not quite there. I think I can get a few more months out of the Cockpit GUI by editing the Flash mms.cfg file and using IE 11 in a sandbox environment. it's not a sustainable fix though. That and other possibly useful pointers here by the way: https://blogs.sap.com/2020/12/10/how-to-keep-enterprise-flash-applications-accessible-in-2021/

None of that is a really sustainable fix though. Thanks for the tip regrading DBArtisan

[former_member722984]

Hi Tim / Raymond,

how did you go getting DBArtisan to connect to IQ 16.1. I note the current version is certified for IQ 16.0 only and I have not been able to successfully connect to my IQ 16.1 databases

Steve J

[former_member725545]

Thanks Robert,

I guess to more precise question then is if there is intended to be a GUI replacement for the flash based Cockpit elements? I'll revisit the document in question because I need a monitoring solution. The web based cockpit was very convenient. Either that or script something separate to Cockpit. There will be a way.

Thanks

[raymond_lackey]

I asked the same question some time ago, same answer. IMO running sql scripts is a step backwards and not acceptable from a company such as SAP. It was also mentioned that using DBA Cockpit along with SAP Solution Manager is an option one can buy and implement as it has agents for IQ, ASE and Rep.

There is also an open source product Ruffle, which emulates Flash and will read swf files, I have tested it on Windows, but it's not quite there yet, I have not tried to test against our Red Hat Enterprise apps.

We are also evaluating DBArtisan which supports SAP IQ 16, ASE and a myriad of other databases. It offers some monitoring and alerting capability.

[linda_westerhold]

I am also looking for a GUI for Sybase Cockpit with Flash no longer supported and I agree, stepping backwards to command line is not an acceptable option. If they are not going to support a technology has anyone jumped to Oracle as an NLS replacement for BW on Hana?

[RobertWaywell]

As per SAP Note 2905488 - Adobe Flash Player End of Life (December 2020): Impacts to SAP IQ Cockpit, SAP has mitigated the impact of the Adobe Flash EOL by releasing an SAP IQ Cockpit non-GUI administration document with SAP IQ 16.1 SP04 PL07. This document shows you how to use SQL commands for the SAP IQ Cockpit tasks you used to perform graphically.