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

[montubhardwaj]

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

[#2]

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

[#3]

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

[montubhardwaj]

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. 

[montubhardwaj]

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 ?

[#6]

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

[#7]

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

[montubhardwaj]

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 ?

[#9]

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

[montubhardwaj]

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

[suniljain]

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