10 Replies Latest reply: Mar 31, 2011 11:20 PM by s j RSS

    SAP connector to BSEG

    Linda Monincx

      Hi, the sap connector is to slow to pull the BSEG table into qlikview, i am now using ole db connection as a workaround on this problem. But I want to download now the BSEG table ( using the script of the connector) but this table is not present through the OLE db connection.

      Does anyone experienced the same issue or knows how to pull down the BSEG data?

      Any help is welcome.

      Kind regards,

      Linda Monincx

        • SAP connector to BSEG

          hiLinda

          Did you put a clause where in your select ?

          regards

          serge

          • SAP connector to BSEG
            simplement

            Hi,

            The comments surrounding Cluster tables and the size of BSEG are correct. I will be upfront and commercial here-- our company makes a tool the Data Liberator that makes all SAP data including data in cluster and pool tables etc. continuously available in a SQL Server 2008 Database. The data is continuously updated in real time and we never call the SAP applicaiton server. It all occurs at the database level. In general we can output (depending on network speed etc.) about 1,000,000 rows of BSEG per minute (that is the full row -- if the number of fields is reduced then the speed increases accordingly.

            Bypassing the entire SAP application stack for reporting reduces the load on the R/3 instance and gives you tremendous flexibilty in consuming the data. Typically you would create database views with Liberated data that you would then use as a regular SQL data source for Qlikview or any other tool that you are using. Since all data manipulation is outside of SAP there is no ABAP code nor RFCs, BAPIs or the like.

            The real time nature of our software insures that any updates in SAP are availble for your analysis within about 5 seconds of posting in SAP.

            We are big fans of in memory analytics and believe that with an adequate supply of data the need to build cubes is substantially reduced.

            I hope this information is of use to you. We can be found at www.simplement.us

            Regards,

            Robert MacLean

             

            • SAP connector to BSEG
              s j

              Dear Linda,

              BSEG is cluster talbe and cluster table does not have any physical identity and database level. so it is not present in OLE db connection. You can download BSEG table only through SAP Connector.

              BESG is non indexed table so select query fetch data slowly. so you can select limited field to improve the extraction speed.

              Regards,

              Sunil Jain.

               

               

               

              Hi, the sap connector is to slow to pull the BSEG table into qlikview, i am now using ole db connection as a workaround on this problem. But I want to download now the BSEG table ( using the script of the connector) but this table is not present through the OLE db connection.

              Does anyone experienced the same issue or knows how to pull down the BSEG data?

              Any help is welcome.

              Kind regards,

              Linda Monincx