Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

is there any difference between fetching database from sap and fetching database from oracle ? generating and desigining reports is common or any difference is there ? pls tell me?

is there any difference between fetching database from sap  and  fetching database from oracle ? generating and desigining reports is common or any difference is there ?  pls   tell me?

1 Solution

Accepted Solutions
Not applicable

Re: is there any difference between fetching database from sap and fetching database from oracle ? generating and desigining reports is common or any difference is there ? pls tell me?

I'm not sure what you mean, but in general there is a difference between a Table in SAP and the table in the Database SAP is using. A SAP Table can be split into three tables in Oracle.

About Reports, what do you mean with it. Building SAP Reports, Reports in QlikView or general QlikView Application?

2 Replies
Not applicable

Re: is there any difference between fetching database from sap and fetching database from oracle ? generating and desigining reports is common or any difference is there ? pls tell me?

I'm not sure what you mean, but in general there is a difference between a Table in SAP and the table in the Database SAP is using. A SAP Table can be split into three tables in Oracle.

About Reports, what do you mean with it. Building SAP Reports, Reports in QlikView or general QlikView Application?

evan_kurowski
Valued Contributor

Re: is there any difference between fetching database from sap and fetching database from oracle ? generating and desigining reports is common or any difference is there ? pls tell me?

Hello Manojqlik,

Extracting data from an Oracle data source requires configuring a connection through the ODBC or OLE avenues.  The QV script editor contains menu options for accessing the Windows 32bit and 64bit Data Sources Administrator.  Selecting OLE will pull up the OLE connection interface.

Importing data into QlikView via an ODBC or OLE connection does not require any additional plug-ins or add-ons, just a properly configured DSN (ODBC) or valid set of connection credentials/parameters (OLE).

SAP connections are a different matter and require the installation of an add-on package, the SAP connector (downloaded from Qlik website).  It must be installed/configured as a separate step in order to begin importing SAP data.

All connections regardless of the data source require that the syntax passed via those connections be valid for the particular data hosting software (i.e. a SQL Server ODBC connection requires valid T-SQL statements, Oracle OLE connection requires valid PL-SQL statements, SAP extraction requires valid SAP query syntax).

However, once data from any source is loaded into a QlikView data model, from that point forward it can be treated exactly the same, and must be manipulated via QlikView syntax.  Once in QlikView, data handling will make no distinction as to the origin, data from text files can be treated the same as data from SAP can be treated the same as data from Oracle.

Community Browser