Skip to main content

SAP DSO/ODS Connector user configuration

Use the same user defined for the SAP OLAP Connector.

SAP OLAP Connector user configuration

Authorizations are required to use the DSO Connector. Qlik provides a role that contains the necessary authorizations.

The QTQVCBWACCESS role is to be used by OLAP, DSO/ODS, BEx, and InfoProvider connectors back-end users for doing extraction jobs on an SAP BI/BW system.

If you are creating the role manually, you need to add the following items:

  • Two additional function groups, RSAB and RSODSO_BAPI

Change Role Authorizations dialog

  • Authorization object S_RS_ODSO with DATA and DEFINITION

Authorization objects list

Authorization object tree

Use the same download user as the SAP OLAP Connector.

After the transports have been installed in the system, create one or more users as needed. You can also assign the roles to existing users.

Do the following:

  1. In the SAP system, go to transaction SU01.
  2. Click Create (F8).
  3. Give the new user a user a name and a password.
  4. For an existing user, enter the User ID and click Change (Shift + F6).
  5. On the Logon data tab, assign new users to User Type: Service.
  6. On the Roles tab, add the desired roles.
  7. Click Save.

If the installation is an upgrade from a previous version and the role QTQVCBWACCESS has been updated, update all users assigned to the role.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!