topic Re: Does SAP connector is a must when loading data from SAP sitting on SQL? in QlikView

Does SAP connector is a must when loading data from SAP sitting on SQL?

Mon, 26 Jan 2026 21:26:37 GMT

As caption title

Re: Does SAP connector is a must when loading data from SAP sitting on SQL?

Wed, 16 Apr 2014 02:43:35 GMT

Hi Ming Sung,

Please elaborate. I am finding it hard to understand what message your trying to convey here.

What do you actually mean by the way?

Are you trying to connect to SAP BW directly to extract data?

Are you trying to connect to SAP data which lies in a SQL server?

Best Regards,

Re: Does SAP connector is a must when loading data from SAP sitting on SQL?

Wed, 16 Apr 2014 05:33:36 GMT

Ho Ram,

I mean sap data lies in Sql server. I try to pitch those SAP customer for using Qlikview. but you know it is quite an investment even for SAP connector license, I just wondering whether could loading the data without sap connector, and would it cause a lot of trouble when defining the data model.

ming

Re: Does SAP connector is a must when loading data from SAP sitting on SQL?

Anonymous — Wed, 16 Apr 2014 05:49:39 GMT

Hi Ming

You can create a connection using OLE-DB provider but it will be only a database connection and not application connection (you will not be able to extract SAP queries, reports only extract Tables w/o metadata )

Thanks

Yaniv

Re: Does SAP connector is a must when loading data from SAP sitting on SQL?

Wed, 16 Apr 2014 06:03:36 GMT

Hi Ming,

No, you wouldn't need SAP connector to do so. You can just use a OLE-DB/ODBC connection to the DB. There are ways to work around it, just like Yaniv said below you can only have a database connection and not an application connection.

If it is BW your worried about, you the Analysis Process Designer to extract the data into .csv files and then pump it into a QlikView Report.

Regards,

Re: Does SAP connector is a must when loading data from SAP sitting on SQL?

Mon, 28 Apr 2014 10:14:56 GMT

here is the info you need on the SAP connector for QV.

You can connect to SAP using ODBC . but the connector has its own benefits

Re: Does SAP connector is a must when loading data from SAP sitting on SQL?

Thu, 01 May 2014 19:03:41 GMT

These are some reasons why you should use the connector.

ODBC driver will not give you access to all the SAP tables, like pool and cluster.

SAP admins frown upon access to the SAP instance via ODBC drivers, but it's ok with a certified tool like the SAP connector.

Also, there might be license restrictions when using SAP data outside SAP sanctioned methods, which SAP connector is.

Also, I attached the latest slides for the connector.