topic DO we always require SAP Connector to access data from SAP BW? in QlikView

DO we always require SAP Connector to access data from SAP BW?

montubhardwaj — Thu, 26 May 2011 05:00:02 GMT

Hi All,

We have a QV9 SR6 platform and we want to test the feasibility of QV with SAP BW. But I have read through forums/docs that we need to have SAP connector to extract the data and the bad part is we do not have SAP connector with us

Please give your inputs/suggestions/thoughts on how this can be done in best possible way.

Many thanks in advance.

Regards,

Sharma

DO we always require SAP Connector to access data from SAP BW?

montubhardwaj — Thu, 26 May 2011 07:11:21 GMT

Any inputs on this ?

DO we always require SAP Connector to access data from SAP BW?

Thu, 26 May 2011 07:48:47 GMT

For loading for example Info Cubes from the BW you need the SAP Connector. Alternativ is to load the needed data direct from the Database Tables.

If you like to test the SAP Connector contact your Account Manager.

DO we always require SAP Connector to access data from SAP BW?

Thu, 26 May 2011 07:53:08 GMT

Hi,

There is one solution.You can use "Extract QV" for fetching data from SAP system.It is middle ware compnoent.

But only thing is it is not certified by QlikTech.(I hope)

-Jai

DO we always require SAP Connector to access data from SAP BW?

montubhardwaj — Thu, 26 May 2011 08:08:09 GMT

@ dzr: Ok that make some sense. But how do we connect to SAP BW using QV directly ? can you please guide me through a bit ? Also do we need to have SAP installed in local machine ?

@ Jai: Thanks Jai. Is it available for free/trial ? What is the cost of this one ? Have you worked on it by any chance ?

DO we always require SAP Connector to access data from SAP BW?

Thu, 26 May 2011 08:17:27 GMT

Hi Sharma,

I think it is available demo version available for trial purpose.I never worked and I gone through the doccument only.Hee is the link http://www.theobald-software.com/download/XtractQV/XtractQVWhitePaper_EN.pdf

-Jai

DO we always require SAP Connector to access data from SAP BW?

Thu, 26 May 2011 08:18:47 GMT

You can't connect to SAP from QV directly, but to the database used for SAP (for example Oracle). The problem you will face in this way is, that you need to have someone with good knowledge of how SAP is handling the database. Some SAP Tables in SAP are build from different Tables in the database.

You do not need to install SAP on local machine for using the SAP Connector.

DO we always require SAP Connector to access data from SAP BW?

montubhardwaj — Thu, 26 May 2011 08:29:56 GMT

@dzr: I want to connect to SAP directly and pull the data in QV. So once we have pulled the data from SAP, it will hit SAP BW everytime we reload QV application?

Is SAP connector is free to download or is available for trial? How to avail it ?

@Jai: Thanks for your link. I will go through the document.I will try to get the trail version and test with it.In the mean time, please keep me posted if you are trying something new with XtractQV.

DO we always require SAP Connector to access data from SAP BW?

Thu, 26 May 2011 08:36:02 GMT

It depends on how you build your QVW will connect to SAP. Often used is to have a QVD Generator wich load the data into QVD files from SAP, mostly on night run. After this your applicaton can load from these files.

It is not free for download, but you can contact you Account Manager to get a Test license.

DO we always require SAP Connector to access data from SAP BW?

montubhardwaj — Thu, 26 May 2011 08:41:17 GMT

@dzr: SAP connector is provided by SAP or by QV?

DO we always require SAP Connector to access data from SAP BW?

Thu, 26 May 2011 08:41:42 GMT

Hi,

you should never connect to SAPs Oracle DB directly (no matter if BW or not)!

The reason is: if you read Data while SAP is trying to change or read the same data SAP might stop the whole SAP System! Please don´t ask why, I do not know. Might be something like security violation???

If you use the QV-connector you somehow go through the SAP-security and access-management and will never have such problems.

Another reason is that a lot of tables in SAP - especially in BW - are created during runtime and do not physically exist in the Oracle DB. Using the QV-SAP-Connecotr you can also access those tables.

Hope that helps.

Regards

Sabine

Re: DO we always require SAP Connector to access data from SAP BW?

Thu, 26 May 2011 08:42:13 GMT

Hi,

you should never connect to SAPs Oracle DB directly (no matter if BW or not)!

The reason is: if you read Data in the oracle DB while SAP is trying to change or read the same data, SAP might stop the whole SAP System! Please don´t ask why, I do not know. Might be something like security violation???

If you use the QV-connector you somehow go through the SAP-security and access-management and will never have such problems.

Another reason is that a lot of tables in SAP - especially in BW - are created during runtime and do not physically exist in the Oracle DB. Using the QV-SAP-Connector you can also access those tables.

Hope that helps.

Regards

Sabine

DO we always require SAP Connector to access data from SAP BW?

montubhardwaj — Thu, 26 May 2011 08:46:45 GMT

HI Sabine, ]

That was helpful and thanks for your advise.I think SAP connector/XtractQV is the only option to access SAP BW and use the data in QV for reporting. Share your expreience if you have any on this.

DO we always require SAP Connector to access data from SAP BW?

montubhardwaj — Fri, 27 May 2011 04:41:47 GMT

For working on QV-SAP, i.e. pulling data from SAP to QV(using SAP-Connector or XtractQV), do we need to have expert in SAP as well ? What level of expertise do we need in SAP ?

DO we always require SAP Connector to access data from SAP BW?

Tue, 31 May 2011 08:20:09 GMT

Hi Sharma,

when connected to SAP its like any other DB

You need someone who knows where in the SAP-Tables the informations you need are and how the tables -if you need more that one and I bet you will- should be connected.

In my case, most of the time it was the customer who had an expert on that. Someone who built up the SAP system, an employee or another consultant.

I only worked with the QV-SAP-Connector but I heard goog things about the THEOBALD. Might be that the TEOBALD is better than the QV-SAP-Connector but as I sad I have no experience in that one.

Regards.

Sabine

Re: DO we always require SAP Connector to access data from SAP BW?

Tue, 31 May 2011 08:21:41 GMT

Hi Sharma,

when connected to SAP its like any other DB

You need someone who knows where in the SAP-Tables the informations you need are and how the tables -if you need more that one and I bet you will- should be connected.

In my case, most of the time it was the customer who had an expert on that. Someone who built up the SAP system, an employee or another consultant.

I only worked with the QV-SAP-Connector but I heard goog things about the THEOBALD. Might be that the TEOBALD is better than the QV-SAP-Connector but as I sad I have no experience in that one.

Regards.

Sabine

DO we always require SAP Connector to access data from SAP BW?

montubhardwaj — Tue, 31 May 2011 09:15:15 GMT

Thanks for your information Sabine.I am too not sure about the performence of XtractQV(THEOBALD). What all settings we need to do for using SAP-CONNECTOR? is it user friendly ?

Re: DO we always require SAP Connector to access data from SAP BW?

Tue, 31 May 2011 11:31:52 GMT

Installing the SAP-Connector is quite easy and you can look that up in the SAP-Connector Installtion Guide.

Not so easy and not documented is the changes on the SAP-Site.

I wrote my own documentation about that. I could send it to you but it is in german.

Regards.

Sabine

DO we always require SAP Connector to access data from SAP BW?

montubhardwaj — Tue, 31 May 2011 11:40:26 GMT

Many thanks Sabine. I will let you know/seek your help if I came across unexpected issues. Thanks for your guidence.

Re: DO we always require SAP Connector to access data from SAP BW?

suniljain — Mon, 29 Aug 2011 06:51:56 GMT

you can also extract data by makig ABAP Program or By Using JCO.