{"id":38510,"date":"2018-11-19T10:34:32","date_gmt":"2018-11-19T05:04:32","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=38510"},"modified":"2021-12-07T11:20:05","modified_gmt":"2021-12-07T05:50:05","slug":"loading-data-from-database-in-qlikview","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/loading-data-from-database-in-qlikview\/","title":{"rendered":"Loading Data From Database in QlikView – Simple Steps to Load Data"},"content":{"rendered":"

In our last session, we talked about Loading Data from files<\/strong>. Today, we will learn Loading Data From Database in QlikView. Moreover, we will learn different steps to load data from database in Qlikview.<\/p>\n

If data could only be loaded from external files or inline, how limited the scope of QlikView will become. That is why being able to connect and fetch data from commercial databases is a very important facility.<\/p>\n

As databases stores data in great amounts, more data can use for analysis in QlikView by connecting to databases.<\/p>\n

So, let’s start the Loading Data<\/strong> From Database in QlikView.<\/p>\n

Loading Data From Database in QlikView<\/h3>\n

QlikView provides easy ways of connecting to external data sources, databases to be specific. It connects with several commercial databases through an ODBC or OLE DB connection interface.\u00a0<\/span><\/span><\/p>\n

The basic steps are to first install a driver specific to the database you want to connect and also, configure that database as an ODBC data source. <\/span><\/span><\/p>\n

In the Database section of the script editor<\/strong>, you can select the type of connection interface from ODBC and OLE DB<\/strong>. Then click on Connect. <\/span><\/span>This will open a dialog in which you can select the Data Source Name (DSN) of the database of your choice from a list of available DSNs. <\/span><\/span><\/p>\n

To view the user databases available, check the <\/span><\/span>Show user DSN<\/b><\/span><\/span> box. Once you have selected your database name, you can test the connection.<\/span><\/span><\/p>\n

Upon exiting this dialog, the connection statement will load into the script with keyword CONNECT.\u00a0<\/span><\/span>After setting up the connection with the desired database, you can select which data files are to load from the databases available under the DSN. <\/span><\/span><\/p>\n

This can done through <\/span><\/span>Select<\/b><\/span><\/span> option given below <\/span><\/span>Connect<\/b><\/span><\/span> option. Here, you can select from available databases from a drop-down menu. <\/span><\/span><\/p>\n

Then you can select from the tables available in the selected database. Then in an adjacent section, you see the list of fields present in the selected table.<\/span><\/span><\/p>\n

Once you click on Ok, you will see that the script has been updated and now shows statements for the selected table using SELECT and FROM keywords. <\/span><\/span><\/p>\n

Upon saving and executing the script, data will finally get loaded from the database and will be ready to be used in sheet objects<\/strong>. <\/span><\/span><\/p>\n

The sheet objects created will follow the associations as usual and such fields which are common in two or more tables loaded from the database will link the table and become the Key fields.<\/span><\/span><\/p>\n

How QlikView Load Data From Database?<\/h3>\n

QlikView can connect to many different data sources like MySQL, Oracle, SQL server<\/strong> etc. Data from a database can load into the QlikView\u2019s in-memory and can quickly retrieve for further analytical purposes.<\/span><\/span><\/p>\n

Let us see how to connect databases in QlikView. Before we move on, you might need to make sure that you have a pre-existing database in your computers.<\/span><\/span><\/p>\n