3 Replies Latest reply: Jan 5, 2011 2:01 AM by s j RSS

    Extracting SAP data using QV SAP Report Connector - How?

    Karthik G

      Hi all,

       

      We are trying to extract SAP data using QV SAP Report Connector.

      Based on our working, we installed the connector, configured it ( there was a port needed to be open : 33xx).

      After which, we, using the report connector, connected to the required report by mentioning the program name and variant in the fields provided and the report was shown in the connector window.

      We then performed some ETL, skipping records not required. When we finally extracted, the script started running as usual, displaying the script log mentioning the status of Executing script. However, no log entry was made in the text area below.

      However, the server's performance got hit, as if it is fetching records. But the variant is for just a years' data.

      The script executed overnight with no lines extracted, and we had to abort the script execution manually.

       

      Kindly suggest us the correct procedure to extract SAP reports.

       

      Thanks and Regards,

      -Karthik.

        • Extracting SAP data using QV SAP Report Connector - How?
          s j

          whatever data dislayed in qlikview by SAP Report connector is displayed from spool. But When you format data from spool definitely it will takes lots of time.

          alredy some member post this issue. it not new for sap report connector.

           

            • Extracting SAP data using QV SAP Report Connector - How?
              Karthik G

              Thanks for the instant reply Sunil!

              Ok, so what data we see in that connector window is from spool. However, is the understanding that's just the sample of all types of records correct?

              Or, if it spools the entire data for that variant, when it can display in the connector window in some time, it must extract in the +/- the same time into QlikView.

              Else, cant we ask the SAP connector or the SAP system not to spool but directly fetch the data into QlikView?

               

               


              Sunil Jain wrote:
              whatever data dislayed in qlikview by SAP Report connector is displayed from spool. But When you format data from spool definitely it will takes lots of time.
              alredy some member post this issue. it not new for sap report connector.
              <div></div>


               

               

               

               

                • Extracting SAP data using QV SAP Report Connector - How?
                  s j

                  cant we ask the SAP connector or the SAP system not to spool but directly fetch the data into QlikView?

                   

                  you can directly extract data from sap table whether it is standard or customize. SAP Report is recently lanunched features . so may be next version they will remove the bugs of data formatting methodology of report connector.