6 Replies Latest reply: May 3, 2012 4:36 PM by Federico Puig RSS

    Oracle & SAP

    Federico Puig

      Could someone indicate me, what kind of ODBC or OLE DB driver is better to extract SAP/R3 Tables from Oracle DB, directly?

      Thanks

        • Oracle & SAP
          Edgar Kech

          personally I would recommend using the Qlikview SAP-Connector. If you connect directly to Oracle you have to make sure, that your Oracle-License permits it. From a technical viewpoint the direct access via the native Oracle OLEDB or ODBC should be possible without problems...

          Also you get besides the SQL-Connector a bunch of other useful connectors (especially the Extractor Connector).

           

          regards,

          Edgar

          • Oracle & SAP
            s j

            You require SAP connector to extract data from database of SAP R/3.

              • Oracle & SAP
                Federico Puig

                Sorry Sunil, but It's mandatory to get the SAP/Connector to extract data? I had understood, that you could extract some data with simple OLE DB or ODBC driver. In fact, QlikTech sell the connector as extra and no mandatory, if I'm not wrong or mistaken?

                Can you assure this point?

                Thanks

                • Re: Oracle & SAP
                  Federico Puig

                  Sorry Sunil, but It's mandatory to get the SAP/Connector to extract data? I had understood, that you could extract some data with simple OLE DB or ODBC driver. In fact, QlikTech sell the connector as extra and no mandatory, if I'm not wrong or mistaken?

                   

                  Can you assure this point?

                   

                  Thanks

                   

                   

                   

                  Federico Puig

                  http://www.seidor.es

                          cid:imageafc4e8.JPG@9f0a4b89.4e8a4ac1

                   

                  Tel:    +34 93 304 32 22

                  Fax:    +34 93 317 68 18

                  Móvil:  617421026

                          Pujades, 350 2ª

                  Edificio Inbisa 22@

                  08019 Barcelona

                  España

                   

                  cid:image23363d.GIF@86c6eb25.42a8b76e        Antes de imprimir este mensaje, asegúrese de que sea imprescindible. Proteger el medio ambiente está a nuestro alcance.

                   

                   

                   

                  La información que contiene este correo electrónico es confidencial y compete exclusivamente al destinatario. Si Vd ha recibido esta comunicación por error, por favor, notifíquelo inmediatamente al remitente y borre el mensaje junto con sus ficheros anexos sin leerlo, copiarlo, grabarlo, distribuirlo o divulgarlo o hacer cualquier otro uso de la información sin el consentimiento de la empresa. El correo electrónico vía Internet no permite asegurar la confidencialidad o correcta recepción de los mensajes, por lo que Seidor no asume responsabilidad alguna por los daños causados.

                   

                  The information contained in this communication is confidential, may be privileged and is intended for the exclusive use of the above named addressee. If you receive this communication in error, please notify the sender immediately and delete it, and all its attached documents. If you are not the intended recipient, you are expressly prohibited from reading, copying, distributing, disseminating or, in any other way, using any of the information without the company consent. Please note that Internet e-mail guarantees neither the confidentiality nor the proper receipt of the message sent, so that Seidor shall not be liable for any damages caused.

                    • Re: Oracle & SAP
                      Ferran Garcia Pagans

                      Federico,

                      If you go directly thought a ODBC connection you will not be able to read cluster tables and Z fields. You'll have to solve the complexity of the SAP data model, the sap connector would do it for you.

                       

                      If you use an ODBC you will lose the sap security, if you use the sap connector you will use the sap security model.

                       

                      I think, if you use an ODBC, probably you need to upgrade the Oracle DB license. Usually, the orcl license distributed by sap is and embedded license and if you want to access directly the db you need a full use license (as long as I know). Please be aware I'm not an expert in orcl licensing.

                       

                      Finally if you want to access an orcl db I would install the Oracle Client. In this post you will find how to access an Oracle DB.

                       

                      http://ferrangarciapagans.blogspot.com.es/2012/02/acceder-bases-de-datos-oracle-desde.html

                       

                      Regards, F.