Technical Articles
enable SAP IQ for DBACOCKPIT
last changed: 26th of April 2022
by default the User (SAP<SID>USR) which is used to move the data from the primary Database to the SAP IQ Database doesn’t have the necessary permissions to execute the options in Transaction DBACOCKPIT in ABAP.
please note that with NetWeaver 7.56 the embedded support of IE11 is not supported anymore, and you have to call every SAP WebDynpro from an external Web Browser, e.g. Chrome or Edge.
In newer ABAP System adapt the SICF setting systemloginjs
Note 2900689 – SAPGUI for HTML. WebGUI logon not working on S/4 Hana 1909
activate service systemloginjs with tx. SICF
Blog – SapMachine and SAP HANA Studio
SAP Help – (NetWeaver) SAP HANA Smart Data Access (SDA) for Near-Line Storage in SAP IQ
SAP Help – (HANA) SAP Authorization Objects
SAP Help – (DBACOCKPIT) DBA Cockpit for IQ
Furthermore, it is more suitable to move the additional permissions to another user, like already with SAP HANA, called DBACOCKPIT to separate the permissions.
To change the necessary IQ Options mentioned in the following Note, these additional permissions are also mandantory.
Note 3094594 – Enable SAP IQ for DBACOCKPIT
Note 3017355 – SAP IQ 16.1 SP04 PLx – correct SAPIQDB.cfg settings
Note 3119008 – Configure SAP IQ and HANA for SDA/ODBC
Note 3196447 – troubleshooting an existing SAP IQ 16.x Implementation for NLS/DTO and ILM
More Details of the complete SAP IQ Setup can be found in the Document mentioned here:
Note 2780668 – SAP First Guidance – BW NLS Implementation with SAP IQ
- structured data from BW(/4) – (NLS/DTO/Cold Store)
- unstructured data from ERP, S/4 (ILM)
a extensive SQL- Editor is now available!
SAP IQ Backup Event can be directly created and triggered in the DBACOCKPIT!
Adding DBfile is possible and DBspace with the upcoming Support Packages
The Functionality is available without any restriction with the mentioned SAP Notes above …
no more SAP IQ Monitoring Drama …
Roland Kramer, SAP Platform Architect for Intelligent Data & Analytics, SAP SE
@SAPFirstGuidance
“I have no special talent, I am only passionately curious.”