Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

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?

View solution in original post

2 Replies
Not applicable
Author

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
Specialist
Specialist

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.