topic Re: Urgent Help needed pls. in QlikView

Urgent Help needed pls.

rahulhv1 — Mon, 26 Jan 2026 21:26:37 GMT

Towards one more step, i would like to know with an example, how to access table from SAP using SAP BW OLE DB provider or is there any other way to access the tables from SAP. Please help me out on this

Regards

Rahul Varma.

Re: Urgent Help needed pls.

Anonymous — Tue, 17 Dec 2013 09:29:35 GMT

Hi Rahul,

to connect to SAP you need SAP connector, in the SAP connector there already have SAP BW connector & function.

Regards,

Re: Urgent Help needed pls.

Tue, 17 Dec 2013 09:34:36 GMT

You need to create the connection string. Just open the script editor and select SAPconnector and click on 'Connect'. A dialogue box will open up. Enter the SAP server credentials in that dialogue box and then click on 'Test Connection'. Once the test connection is sucessful, clic OK and your connection string will appear in the script editor.

After creating Connection string you just need to write the script for the tables you want to fetch.

for example:

Load * ;

SQL Select * from PA9100;

store PA9100 into $(vDestination)PA9100.qvd;

drop table PA9100;

It is a good practice to first fetch the tables and store them into qvd and after that use those qvds in the data model.

Re: Urgent Help needed pls.

rahulhv1 — Tue, 17 Dec 2013 09:35:05 GMT

Would you pls. elaborate the same with any example. i have tride it by SAP BW OLE. At begining, it
says 'Test conection succedded' but again nothing further. Please explain it setp by step with an example. It would be great help to me.

Re: Urgent Help needed pls.

jagan — Tue, 17 Dec 2013 09:39:13 GMT

Hi Rahul,

To access SAP tables you need to download and install SAP connector, and just normally use how you usually use ODBC and OLE DB drivers.

Regards,

Jagan.

Re: Urgent Help needed pls.

Tue, 17 Dec 2013 09:39:22 GMT

QlikView recommends connecting to SAP using Remote Function Calls, SAP’s recommended method, not an ODBC or OLEDB connection to the underlying database.

Advantages of the QlikView SAP Connector over ODBC:

ODBC drivers will not work with pool and cluster tables.
Some SAP customers have only a runtime database license which they purchase from SAP. Using it to access the database without logging in through SAP will violate their license agreement.
Using the SAP connector will ensure that when SAP changes their data structures (due to an upgrade), applications written in QV will not need to be re written.
Full audit trail

Info about the SAP Connector can be found in this PDF download: http://www.qlik.com/uk//~/media/Files/resource-library/global-us/direct/datasheets/qlikview11/DS-QlikView-Connector-…

Re: Urgent Help needed pls.

Anonymous — Tue, 17 Dec 2013 09:47:36 GMT

Hi rahul,

for SAP BW there is two types of connector which is OLAP Connector or DSO/ODS connector.

after you choose one of them and success to connect there will be another for each connection, if OLAP there will be cube button, if DSO/ODS there will be DSO/ODS button. and you can choose the table that you like to used.

hope it can be help.

Regards,

Re: Urgent Help needed pls.

saniiiil — Wed, 18 Dec 2013 15:22:11 GMT

Hi Rahul,

Check Xtract QV the SAP Connector for Qlikview of theobald Software.

Check this pdf to see how to extract SAP tables:

http://www.theobald-software.com/download/xtractqv/ClickThroughXtractQVTable.pdf