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?
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.