Qlikview Connecting and Reporting with Oracle Database

January, 21-2020

BISP

Qlikview Connecting and Reporting with Oracle Database

Printing a single table or a graph this is done as easily as selecting a sheet object and then choosing Print from a menu or toolbar as in QlikView . Sometimes, there is a need to produce more complex reports including multiple charts and tables. This is where QlikView comes into the picture, QlikView Report Editor offers the possibility of different sheet objects together on one or more pages with full control of page layout, including headers and footers.
Our experts have prepared a complete end-to end guide for Qlikview reporting and data visualization. Document focuses on Connecting and Reporting with Oracle Database. The best knowledge sharing organization and for online training. The delivery of training in a smarter way by BISP by experienced faculty and they are excellent in all aspects.

Qlikview case study

Oracle as Data Source

Oracle as data source this allows Qlikview reports to directly access a database data-source like oracle data source. Qlikview, by default, loads all required data up-front into its own in-memory column-store database, but oracle as a data source feature allows it to in addition retrieve data from an SQL data source, on-demand, to supplement this in-memory dataset. This should allow larger datasets to be accessed from within Qlikview reports Makes corporate data easier for business users to access. This feature provides a common infrastructure for producing and delivering enterprise reports, scorecards, dashboards, ad-hoc analysis, and OLAP analysis Includes rich visualization, interactive dashboards, a vast range of animated charting options, OLAP-style interactions and innovative search, and actionable collaboration capabilities to increase user adoption and reduces cost with a proven Web-based service-oriented architecture that integrates with existing IT infrastructure.

Oracle Database
An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. We take Oracle as a front end tool and QlikView as a back end tool for generate the report by using the interface oledb.

OLE DB
OLE DB (Object Linking and Embedding, Database, sometimes written as OLEDB or OLE-DB), an API designed by Microsoft, allows accessing data from a variety of sources in a uniform manner.

Require Prerequisite
These are the prerequisite for creating connection between oracle data source and QlikView.
Oracle 10g or more then 10 g edition should install in your machine, because this version works with OCI and OLEDB, you need both.
Oracle client 10 g or more then 10 g should install in your machine.

Oracle Client
The client is used to connect to Oracle databases running on other machines. In Oracle 10g edition it already installed with the oracle set up but in Oracle 11g we have to install the client separately.

OCI
The Oracle Call Interface (OCI) consists of a set of C-language software APIs which provide an interface to the Oracle database.OCI offers a procedural API for not only performing certain database administration tasks (such as system startup and shutdown), but also for using PL/SQL or SQL to query, access, and manipulate data. The OCI library is based on Oracle's undocumented User Programmatic Interface (UPI), acts as an "interpreter" between applications and the low-level database network protocol. The OCI connection protocol is backwards compatible to 8i when first implemented by Oracle. Use the most current connector from Oracle which includes the current MS OS OLE DB from Oracle and includes Oracle’s OCI. This will create the best connection for the data pulls.

Connection
If you fulfill all the requirements then you can move through establish the connection of QlikView with oracle.

Step 1) Open the QlikView app and give the name Sales_History or you wants to give.

Step 2) Then go to the script Editor window and check the database interface should be OLEDB and then click on the connect option.

script editor window_oracle

Step 3) This will open the Data Link Properties window this having the set of providers choose the provider 'Oracle provider for OLEDB' then click the Next option.

OLEDB

Step 4) The in the connection tab give the data source name as you have given during installation and then the user name and password from which you logged on the oracle as a user.

The snap shot is shown here where you have give the name of your data source.

Oracle installation

And the user name and password which you giving in the oracle while creating the connection

Database connection

Step 5) After hit the test connection button the notification will come which display that Test connection succeeded then click on the ok.

test connection button

Step 6) Then another OraOLEDB Logon window will open which ask for the user id, password and server name.

Server name will be same as the data source name then ->OK

OraOLEDB Logon

Step 7) Now Go to the select option in Edit script window

Script window

From the owner you can select on which schema you have to work. A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user and has the same name as that user. Each user owns a single schema.

Step 8) Now choose the schema and all the fields of the table will be explore to you.You can add more table by pressing add button present in the bottom side of the wizard

Step 9) Now we have load countries, cost, sells, Time, product, customers and channels then go to the table viewer this will give the model as.

Table view

Thanks for reading our blog...

The BISP is committed to mark a learning program to acknowledge those who’ve Appetite to learn new things. Appreciate our outstanding faculty who have made excellent learning material and their contributions. We have a expert faculty list and they consistently add value to the online learner community.

Bookmark our blogs, follow us on Twitter, linkedin, facebook..we hope you check out our recommended blogs and spread the word in supporting. BISP is uniquely supported for those people who work on it and shows a genuine passion or Appetite to learn new things.

Share: -16 -10 -17