Qlik Function Module authorization
You can restrict which Qlik Function Modules can be used. There is an authorization object where the allowed Qlik Function Modules can be listed: /QTQVC/CAL.
You can list the allowed Function Modules under /QTQVC/FM:
A ‘*’ in /QTQVC/FM means that all Qlik Function Modules can be used.
Use a role where the authorization object /QTQVC/CAL is present, for example QTQVCACCESS. When the authorization object in the role has been updated, assign the role to the SAP connector user. If users should have different assignments, it is possible to create different copies of a role and assign the appropriate role to a specific user.
Function Modules used for SAP connectors that can be used in all SAP systems
| Function Module | Function Module description | Function group |
|---|---|---|
| /QTQVC/ANALYZE_SQL | Analyze SQL-Statement | /QTQVC/QSQL |
| /QTQVC/DELETE_MEMORY | Deletes Shared Buffer memory after usage | /QTQVC/CONNECTOR |
| /QTQVC/EXPAND_STATEMENT | Expands SQL statement if Row Based Security is used | /QTQVC/QSQL |
| /QTQVC/FETCH_STREAM | Fetch data produced by READ_DATA job | /QTQVC/CONNECTOR |
| /QTQVC/GET_BUSINESSGROUP | Get Business Groups | /QTQVC/BUSGROUP |
| /QTQVC/GET_BUSINESSGROUP_TBLS | Get Business Group Definition | /QTQVC/BUSGROUP |
| /QTQVC/GET_CDS_INFO | Get information about CDS view | /QTQVC/CONNECTOR |
| /QTQVC/GET_LANGUAGE | Get available language codes | /QTQVC/CONNECTOR |
| /QTQVC/GET_TABLES | Get table information | /QTQVC/CONNECTOR |
| /QTQVC/OPEN_STREAM | Opens the Stream for Downloading Data | /QTQVC/CONNECTOR |
| /QTQVC/PROCESS_STATUS | Check or update process chain status | /QTQVC/QSQL |
| /QTQVC/READ_FIELDS | Get tables and fields and check SQL statement structure | /QTQVC/QSQL |
| /QTQVC/READ_MEMORY | Read Shared Buffer memory filled by READ_DATA | /QTQVC/CONNECTOR |
| /QTQVC/SCHEDULE_JOB | Schedules the READ_DATA Background Job | /QTQVC/CONNECTOR |
| /QTQVC/SELECT_WIDE_FIELD | Select a wide field | /QTQVC/CONNECTOR |
| /QTQVC/TIMESTAMP_ADD_TIME | Add seconds to timestamp | /QTQVC/CONNECTOR |
| /QTQVC/WRITE_TRACE | Write record in Trace table | /QTQVC/CONNECTOR |
| Function Module | Function Module description | Function group |
|---|---|---|
| /QTQVC/ADMIN | Qlik administration module | /QTQVC/CONNECTOR |
| /QTQVC/CHECK_RELEASE | SAP Connectors release information | /QTQVC/CONNECTOR |
| /QTQVC/UPDATE_CONTROL | Update database table /QTQVC/CONTROL | /QTQVC/CONNECTOR |
| /QTQVC/UPDATE_STATUS | Update database table /QTQVC/STATUS | /QTQVC/CONNECTOR |
Function Modules used for SAP connectors for SAP BW
These Function Modules can only be used in SAP BW systems.
| Function Module | Function Module description | Function group |
|---|---|---|
| /QTQVC/ADDITIONAL_METADATA | Get additional metadata | /QTQVC/MULTIPROVIDER |
| /QTQVC/CALL_BEXQUERY | Execute a BEx Query | /QTQVC/BEX_QUERY |
| /QTQVC/CHECK_CHAR_VALUE | Check characteristic value | /QTQVC/BEX_QUERY |
| /QTQVC/CHECK_RELEASE_BW | SAP BW Connectors release information | /QTQVC/BEX_QUERY |
| /QTQVC/DELETE_MEMORY | Deletes Shared Buffer memory after usage | /QTQVC/CONNECTOR |
| /QTQVC/FETCH_MPSTREAM | Fetch data produced by READ_DATA job | /QTQVC/MULTIPROVIDER |
| /QTQVC/GET_BEXQUERIES | Get available BEx Queries | /QTQVC/BEX_QUERY |
| /QTQVC/GET_BWOBJECTS | Get BW objects | /QTQVC/MULTIPROVIDER |
| /QTQVC/GET_INFOPROVIDERS | Get InfoProviders | /QTQVC/MULTIPROVIDER |
| /QTQVC/GET_METADATA | Get Metadata for InfoProvider | /QTQVC/MULTIPROVIDER |
| /QTQVC/GET_MPROWCOUNT | Get number of expected rows from an InfoProvider execution | /QTQVC/MULTIPROVIDER |
| /QTQVC/GET_VARNAMES | Get Variable names for a BEx Query | /QTQVC/BEX_QUERY |
| /QTQVC/IOBJ_GETDETAIL | Get Details About an InfoObject | /QTQVC/BEX_QUERY |
| /QTQVC/MDPROV_GET_VARIABLES | Delivers a List of VARIABLES | /QTQVC/RSOB |
| /QTQVC/MDPROVIDER_GET_HIER | Delivers a list of HIERARCHIES | /QTQVC/BEX_QUERY |
| /QTQVC/MDPROVIDER_GET_MEMBERS | Delivers a List of MEMBERS | /QTQVC/BEX_QUERY |
| /QTQVC/OPEN_MPSTREAM | Opens the Stream for Downloading Data | /QTQVC/MULTIPROVIDER |
| /QTQVC/READ_MEMORY | Read Shared Buffer memory filled by READ_DATA | /QTQVC/CONNECTOR |
| /QTQVC/RRT_GET_DIM_CARDINALITY | Number of members in the dimension | /QTQVC/CARDINALITIES |
| /QTQVC/SCHEDULE_MPJOB | Schedules the READ_MPDATA Background Job | /QTQVC/MULTIPROVIDER |
| /QTQVC/UPDATE_CONTROL | Update database table /QTQVC/CONTROL | /QTQVC/CONNECTOR |
| /QTQVC/UPDATE_STATUS | Update database table /QTQVC/STATUS | /QTQVC/CONNECTOR |
| /QTQVC/WRITE_TRACE | Write record in Trace table | /QTQVC/CONNECTOR |