3 Replies Latest reply: Feb 28, 2017 4:34 AM by Hakan Ronningberg RSS

    Transfer Data using SAP .net connector to Qlik-View

    Tejas Patil

       

      We are in a process to send data from SAP to Qlik view. we are getting version mismatch issue in PRD system. After searching, we get below link

       

      http://help.qlik.com/en-US/connectors/Subsystems/SAP_Connectors_Help/Content/6.1/Installation/Installing-the-transports.htm

       


      Our SAP Basis version is 7.4 and SAP APPL version 6.1

       

      So some transport version we need to installed. So where can I get those Transport version. Some patch we need to install or Raise query to SAP or Qlik view will provide.

       

        • Re: Transfer Data using SAP .net connector to Qlik-View
          Hakan Ronningberg

          Hi,

           

          The transport information in the Online help seems to be wrong for the moment. Below is the correct information for the latest release 6.3.2.

           

          Regards,

          Hakan

           

          SQL , Report, SAP Query, BAPI and Extractor Connectors

          SAP BASIS system 6.40 – 7.1x

          For these systems, the following transports must be installed in the SAP system:

          Type

          Connector v. 6.3.2

          Data extraction

          E6DK900804

          User profile

          E6DK900774

          • SAP BASIS system 7.20 – 7.5x

          For these systems, the following transports must be installed in the SAP system:

          Type

          Connector v. 6.3.2

          Data extraction

          E66K900072

          User profile

          E66K900066

          The transports must be installed in the above order. The first is cross-client (imported into the base client), whereas the second is client-specific and has to be imported into all clients where it is to be used.

          OLAP and DSO/ODS Connectors

          Although a data extraction transport is not needed, a user profile transport must be installed in the Business Warehouse SAP system. The role QTQVCBWACCESS in this transport contains the authorizations needed to use the connectors.

          • SAP BASIS 6.40 - 7.1x (E6DK900594)
          • SAP BASIS 7.20 - 7.5x (E66K900029)

            BEx connector

          To use the BEx connector, the data transport for the SQL, Report, SAP Query, BAPI, and Extractor Connectors must also be imported. That transport must be imported before the BEx Connector transport is imported.

          SAP BASIS system 7.00 – 7.2x

          For these systems, the following transports must be installed in the SAP system:

          Type

          Connector v. 6.3.2

          Data extraction

          B7TK900064

          User profile

          E6DK900774 or E66K900066

          User profile BW

          E6DK900594 or E66K900029

          • user profile may already be imported, see SQL, Report, SAP Query, BAPI, and Extractor Connectors.
          • user profile BW may already be imported, see OLAP and DSO/ODS.

            SAP BASIS system 7.30 – 7.3x

          For these systems, the following transports must be installed in the SAP system:

          Type

          Connector v. 6.3.2

          Data extraction

          B7DK900120

          User profile

          E66K900066

          User profile BW

          E66K900029

          • user profile may already be imported, see SQL, Report, SAP Query, BAPI, and Extractor Connectors.
          • user profile BW may already be imported, see OLAP and DSO/ODS.

            SAP BASIS system 7.40 – 7.5x

          For these systems, the following transports must be installed in the SAP system:

          Type

          Connector v. 6.3.2

          Data extraction

          H7TK900047

          User profile

          E66K900066

          User profile BW

          E66K900029

          • user profile may already be imported, see SQL, Report, SAP Query, BAPI, and Extractor Connectors.
          • user profile BW may already be imported, see OLAP and DSO/ODS.

          Import the appropriate data extraction transport into the base client (client independent).

          Import the appropriate user profile transports (if necessary) into every client where they will be used (client dependent).

          Assign the roles QTQVCACCESS, QTQVCADMIN and QTQVCBWACCESS to the Qlik SAP user.