{"id":25857,"date":"2018-08-28T05:30:48","date_gmt":"2018-08-28T05:30:48","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=25857"},"modified":"2021-12-07T11:25:07","modified_gmt":"2021-12-07T05:55:07","slug":"qlikview-database-connection-inline-data","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/qlikview-database-connection-inline-data\/","title":{"rendered":"QlikView Database Connection | QlikView Inline data"},"content":{"rendered":"<p>In our last tutorial, we talked about <strong>QVD Files<\/strong>. Today, we will discuss QlikView Database Connection &amp; Inline Data. In this QlikView Inline Data tutorial, we will explore steps for a data connection in QlikView. At last, we will cover QlikView Inline Data.<\/p>\n<p>So, let&#8217;s start the QlikView Database Connection.<\/p>\n<h3>QlikView Database Connection<\/h3>\n<p>QlikView can connect to many different data sources or databases like MySQL, Oracle, <strong>SQL server<\/strong> etc. Once the database from these external files is loaded into the in-memory of QlikView software. This stored data can be quickly retrieved for further analytical purposes.<\/p>\n<p>Let us see the QlikView Database Connection. Before we move on, you might need to make sure that you have a pre-existing MySQL database in your computers.<\/p>\n<ul>\n<li>In order to connect with a MySQL database, you need to follow some steps. You can connect through the ODBC connection which connects to DSN (Data Source Name) and then the DSN connection fetches the MySQL database.<\/li>\n<li>If you do not have a DSN connected to MySQL database you can do that online.<\/li>\n<\/ul>\n<p>Moving on with the steps for QlikView Database Connection,<\/p>\n<div id=\"attachment_25888\" style=\"width: 1090px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Database-Connection.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-25888\" class=\"wp-image-25888 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Database-Connection.png\" alt=\"QlikView Database Connection | QlikView Inline data\" width=\"1080\" height=\"1080\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Database-Connection.png 1080w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Database-Connection-150x150.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Database-Connection-300x300.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Database-Connection-768x768.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Database-Connection-1024x1024.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Database-Connection-100x100.png 100w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><p id=\"caption-attachment-25888\" class=\"wp-caption-text\">QlikView Database Connection | QlikView Inline data<\/p><\/div>\n<h4>a. Database Connection<\/h4>\n<p>Open the script editor in QlikView and click on the <em>connect<\/em> option after choosing ODBC in the database option. A window will appear showing all the existing databases.<\/p>\n<p>Select MYSQL\u00a0userdsn (DSN) and click on the <em>test connection<\/em>. If your connection goes okay, then a message prompt saying <em>Connection Test Succeeded<\/em> will appear.<\/p>\n<div id=\"attachment_25870\" style=\"width: 590px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs1.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-25870\" class=\"wp-image-25870 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs1.jpg\" alt=\"Step.1 QlikView Database Connection\" width=\"580\" height=\"545\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs1.jpg 580w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs1-150x141.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs1-300x282.jpg 300w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/a><p id=\"caption-attachment-25870\" class=\"wp-caption-text\">Step.1 QlikView Database Connection<\/p><\/div>\n<h4>b. Connection Verification<\/h4>\n<p>Next, we need to check whether our connection with the database was successful or not. For this you need to notice the<strong> script editor<\/strong> window, which will show confirmatory text on the screen.<\/p>\n<p>Now click on <em>Select<\/em> below the <em>Connect<\/em> tab to continue.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SET DateFormat='M\/D\/YYYY';\r\nSET TimestampFormat='M\/D\/YYYY h:mm:ss[.fff] TT';\r\nSET MonthName='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';\r\nSET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';\r\n\r\nODBC CONNECT32 TO mysqluserdsn;\r\n<\/pre>\n<div id=\"attachment_25871\" style=\"width: 592px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs2.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-25871\" class=\"wp-image-25871 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs2.jpg\" alt=\"QlikView Database Connection | QlikView Inline data\" width=\"582\" height=\"517\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs2.jpg 582w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs2-150x133.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs2-300x266.jpg 300w\" sizes=\"auto, (max-width: 582px) 100vw, 582px\" \/><\/a><p id=\"caption-attachment-25871\" class=\"wp-caption-text\">Step.2 QlikView Database Connection &#8211;\u00a0Connection Verification<\/p><\/div>\n<h4>c. Selecting Database Table<\/h4>\n<p>Here the database name is Sakila which is in the Data source file that we selected earlier. It has got a list of table databases to select from. We have chosen actors.<\/p>\n<p>You can also choose any other database from the drop-down list. Then click OK to continue.<\/p>\n<div id=\"attachment_25872\" style=\"width: 592px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs3.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-25872\" class=\"wp-image-25872 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs3.jpg\" alt=\"Step.3 QlikView Database Connection - Selecting Database Table\" width=\"582\" height=\"547\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs3.jpg 582w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs3-150x141.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs3-300x282.jpg 300w\" sizes=\"auto, (max-width: 582px) 100vw, 582px\" \/><\/a><p id=\"caption-attachment-25872\" class=\"wp-caption-text\">Step.3 QlikView Database Connection &#8211; Selecting Database Table<\/p><\/div>\n<h4>d. Table Loading Script<\/h4>\n<p>Now that the table titled actor is been selected it starts showing in the script editor as well.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SET TimestampFormat='M\/D\/YYYY h:mm:ss[.fff] TT';\r\nSET MonthName='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';\r\nSET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';\r\n\r\nODBC CONNECT32 TO mysqluserdsn;\r\nSQL SELECT *\r\nFROM sakila.actor;<\/pre>\n<div id=\"attachment_25873\" style=\"width: 590px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs4.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-25873\" class=\"wp-image-25873 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs4.jpg\" alt=\"Step.4 QlikView Database Connection -\u00a0Table Loading Script\" width=\"580\" height=\"516\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs4.jpg 580w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs4-150x133.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs4-300x267.jpg 300w\" sizes=\"auto, (max-width: 580px) 100vw, 580px\" \/><\/a><p id=\"caption-attachment-25873\" class=\"wp-caption-text\">Step.4 QlikView Database Connection &#8211;\u00a0Table Loading Script<\/p><\/div>\n<h4>e. Storing Loaded Data<\/h4>\n<p>We will have to type some commands to store our data permanently. We give all the important information through this command and define a path for the file.<\/p>\n<p>The extension to this file will be .qvd. Next, we save this file with a suitable name in .qvw format.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">ODBC CONNECT32 TO mysqluserdsn;\r\n\r\nactors:\r\nSQL SELECT *\r\nFROM sakila.actor;\r\n\r\nstore actors into E:\\Qlikview\\data\\actors.qvd;<\/pre>\n<div id=\"attachment_25874\" style=\"width: 593px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs5.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-25874\" class=\"wp-image-25874 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs5.jpg\" alt=\"QlikView Database Connection | QlikView Inline data\" width=\"583\" height=\"516\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs5.jpg 583w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs5-150x133.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs5-300x266.jpg 300w\" sizes=\"auto, (max-width: 583px) 100vw, 583px\" \/><\/a><p id=\"caption-attachment-25874\" class=\"wp-caption-text\">Step.5 QlikView Database Connection &#8211; Table Loading Script<\/p><\/div>\n<h4>f. Creating the Table<\/h4>\n<p>The final .qvd file can be retrieved or reloaded in the main document by pressing CTRL+R. You can now select a straight table to visualize the data in a tabular form with all required columns and rows.<\/p>\n<div id=\"attachment_25875\" style=\"width: 610px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs6.jpg\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-25875\" class=\"wp-image-25875 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs6.jpg\" alt=\"QlikView Database Connection | QlikView Inline data\" width=\"600\" height=\"478\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs6.jpg 600w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs6-150x120.jpg 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/dtbs6-300x239.jpg 300w\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" \/><\/a><p id=\"caption-attachment-25875\" class=\"wp-caption-text\">Step.6 QlikView Database Connection &#8211; Creating the table<\/p><\/div>\n<h3>QlikView Inline Data<\/h3>\n<p>Inline data features allow you to directly enter data into QlikView from a clipboard. Let us learn how to do it. First of all in a new QlikView document\u00a0open the script editor. <strong>Go to Insert &gt; Load Statement &gt; Load Inline<\/strong>.<\/p>\n<div id=\"attachment_25889\" style=\"width: 1090px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Inline-Data.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-25889\" class=\"wp-image-25889 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Inline-Data.png\" alt=\"QlikView Database Connection | QlikView Inline data\" width=\"1080\" height=\"1080\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Inline-Data.png 1080w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Inline-Data-150x150.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Inline-Data-300x300.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Inline-Data-768x768.png 768w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Inline-Data-1024x1024.png 1024w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Inline-Data-100x100.png 100w\" sizes=\"auto, (max-width: 1080px) 100vw, 1080px\" \/><\/a><p id=\"caption-attachment-25889\" class=\"wp-caption-text\">QlikView Database Connection | QlikView Inline data<\/p><\/div>\n<h4>a. Inserting Data<\/h4>\n<p>An excel like spreadsheet will open in QlikView itself and you can enter data there as shown in the image below.<\/p>\n<div id=\"attachment_25876\" style=\"width: 977px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl1.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-25876\" class=\"wp-image-25876 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl1.png\" alt=\" QlikView Inline Data -\u00a0Inserting Data\" width=\"967\" height=\"685\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl1.png 967w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl1-150x106.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl1-300x213.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl1-768x544.png 768w\" sizes=\"auto, (max-width: 967px) 100vw, 967px\" \/><\/a><p id=\"caption-attachment-25876\" class=\"wp-caption-text\">Step.1 QlikView Inline Data &#8211;\u00a0Inserting Data<\/p><\/div>\n<h4>b. Loading Script<\/h4>\n<p>Once you did with making all the entries (we have entered an electronic store record), click on OK. As soon as you do this all your entries will appear on the script.<\/p>\n<p>Save this file with a suitable name (will be saved in .qvw format) and click on OK.<\/p>\n<div id=\"attachment_25877\" style=\"width: 971px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl2.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-25877\" class=\"wp-image-25877 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl2.png\" alt=\" QlikView Inline Data -\u00a0Loading Script\" width=\"961\" height=\"691\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl2.png 961w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl2-150x108.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl2-300x216.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl2-768x552.png 768w\" sizes=\"auto, (max-width: 961px) 100vw, 961px\" \/><\/a><p id=\"caption-attachment-25877\" class=\"wp-caption-text\">Step.2a QlikView Inline Data &#8211;\u00a0Loading Script<\/p><\/div>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">SET FirstMonthOfYear=1;\r\nSET CollationLocale='en-US';\r\nSET MonthName='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';\r\nSET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';\r\nSET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';\r\nSET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday'\r\nLOAD * INLINE\r\n    F1, F2, F3\r\n    Customer id, Item, Price\r\n    dx600, Fridge, \"70,000\/-\"\r\n    dx890, TV, \"1,00,000\/-\"\r\n    dx788, AC, \"40,000\/-\"\r\n    dx654, Laptop, \"32,000\/-\"\r\n    dx566, Camera, \"20,000\/-\"\r\n    dx729, TV, \"55,000\/-\"\r\n    dx899, AC, \"50,000\/-\"\r\n    dx899, Stereo, \"25,000\/-\"\r\n    dx328, TV, \"35,000\/-\"\r\n    dx425, AC, \"42,000\/-\"\r\n    dx190, Phone, \"40,000\/-\"\r\n    dx006, Laptop, \"47,000\/-\"\r\n    dx101, Fridge, \"60,000\/-\"\r\n    dx055, Microwave, \"22,000\/-\"\r\n];\r\n\r\n<\/pre>\n<div id=\"attachment_25878\" style=\"width: 839px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl3.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-25878\" class=\"wp-image-25878 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl3.png\" alt=\"QlikView Database Connection | QlikView Inline data\" width=\"829\" height=\"709\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl3.png 829w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl3-150x128.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl3-300x257.png 300w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl3-768x657.png 768w\" sizes=\"auto, (max-width: 829px) 100vw, 829px\" \/><\/a><p id=\"caption-attachment-25878\" class=\"wp-caption-text\">Step.2b QlikView Inline Data &#8211; Loading Script<\/p><\/div>\n<h4>c. Creating Table Box<\/h4>\n<p>On the main document in QlikView, retrieve the saved file through CTRL+R . Then go to LAYOUT and select a NEW SHEET OBJECT then TABLE BOX. Add fields you wish to be displayed on the table and click on OK.<\/p>\n<div id=\"attachment_25879\" style=\"width: 729px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl4.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-25879\" class=\"wp-image-25879 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl4.png\" alt=\" QlikView Inline Data - Creating Table Box\" width=\"719\" height=\"543\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl4.png 719w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl4-150x113.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl4-300x227.png 300w\" sizes=\"auto, (max-width: 719px) 100vw, 719px\" \/><\/a><p id=\"caption-attachment-25879\" class=\"wp-caption-text\">Step.3a QlikView Inline Data &#8211; Creating Table Box<\/p><\/div>\n<p>Upon clicking OK you will get to see a table with all the entries that you did.<\/p>\n<div id=\"attachment_25880\" style=\"width: 597px\" class=\"wp-caption aligncenter\"><a href=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl5.png\"><img loading=\"lazy\" decoding=\"async\" aria-describedby=\"caption-attachment-25880\" class=\"wp-image-25880 size-full\" src=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl5.png\" alt=\"QlikView Database Connection | QlikView Inline data\" width=\"587\" height=\"455\" srcset=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl5.png 587w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl5-150x116.png 150w, https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/inl5-300x233.png 300w\" sizes=\"auto, (max-width: 587px) 100vw, 587px\" \/><\/a><p id=\"caption-attachment-25880\" class=\"wp-caption-text\">Step.3b QlikView Inline Data &#8211; Creating Table Box<\/p><\/div>\n<p>So, this was all about\u00a0QlikView Database Connection. Hope you like our explanation on\u00a0QlikView Inline Data.<\/p>\n<h3>Conclusion<\/h3>\n<p>Hence, we are pretty sure that after learning to work on QlikView this much you must not be feeling daunted by this tool anymore. Be confident and you will become master of this tool in no time.<\/p>\n<p>So, we have seen how to load files like XML, Web, Delimited and Excel files.<\/p>\n<p>Here, we learned QlikView Database Connection and QlikView Inline data. Furthermore, if we miss something, do let us know in the comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In our last tutorial, we talked about QVD Files. Today, we will discuss QlikView Database Connection &amp; Inline Data. In this QlikView Inline Data tutorial, we will explore steps for a data connection in&#46;&#46;&#46;<\/p>\n","protected":false},"author":6,"featured_media":25869,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[2901,3155,3159,3518,6722,6745,8358,10982,11000,12709,13870,14138],"class_list":["post-25857","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qlikview","tag-connection-verification","tag-creating-table-box","tag-creating-the-table","tag-database-connection","tag-inline-data-in-qlikview","tag-inserting-data","tag-loading-script","tag-qlikview-database-connection","tag-qlikview-inline-data","tag-selecting-database-table","tag-storing-loaded-data","tag-table-loading-script"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>QlikView Database Connection | QlikView Inline data - DataFlair<\/title>\n<meta name=\"description\" content=\"QlikView Database Connection - QlikView Inline Data, How data connected in QlikView, Steps for Inline Data in QlikView, DataBase Connection Verification\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/qlikview-database-connection-inline-data\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"QlikView Database Connection | QlikView Inline data - DataFlair\" \/>\n<meta property=\"og:description\" content=\"QlikView Database Connection - QlikView Inline Data, How data connected in QlikView, Steps for Inline Data in QlikView, DataBase Connection Verification\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/qlikview-database-connection-inline-data\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-28T05:30:48+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T05:55:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Database-connection-and-Inline-data-01.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"QlikView Database Connection | QlikView Inline data - DataFlair","description":"QlikView Database Connection - QlikView Inline Data, How data connected in QlikView, Steps for Inline Data in QlikView, DataBase Connection Verification","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/qlikview-database-connection-inline-data\/","og_locale":"en_US","og_type":"article","og_title":"QlikView Database Connection | QlikView Inline data - DataFlair","og_description":"QlikView Database Connection - QlikView Inline Data, How data connected in QlikView, Steps for Inline Data in QlikView, DataBase Connection Verification","og_url":"https:\/\/data-flair.training\/blogs\/qlikview-database-connection-inline-data\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-08-28T05:30:48+00:00","article_modified_time":"2021-12-07T05:55:07+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Database-connection-and-Inline-data-01.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/qlikview-database-connection-inline-data\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-database-connection-inline-data\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"QlikView Database Connection | QlikView Inline data","datePublished":"2018-08-28T05:30:48+00:00","dateModified":"2021-12-07T05:55:07+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-database-connection-inline-data\/"},"wordCount":923,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-database-connection-inline-data\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Database-connection-and-Inline-data-01.jpg","keywords":["Connection Verification","Creating Table Box","Creating the Table","Database Connection","Inline Data in QlikView","Inserting Data","Loading Script","QlikView Database Connection","QlikView Inline Data","Selecting Database Table","Storing Loaded Data","Table Loading Script"],"articleSection":["QlikView Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/qlikview-database-connection-inline-data\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/qlikview-database-connection-inline-data\/","url":"https:\/\/data-flair.training\/blogs\/qlikview-database-connection-inline-data\/","name":"QlikView Database Connection | QlikView Inline data - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-database-connection-inline-data\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-database-connection-inline-data\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Database-connection-and-Inline-data-01.jpg","datePublished":"2018-08-28T05:30:48+00:00","dateModified":"2021-12-07T05:55:07+00:00","description":"QlikView Database Connection - QlikView Inline Data, How data connected in QlikView, Steps for Inline Data in QlikView, DataBase Connection Verification","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/qlikview-database-connection-inline-data\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/qlikview-database-connection-inline-data\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/qlikview-database-connection-inline-data\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Database-connection-and-Inline-data-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/08\/QlikView-Database-connection-and-Inline-data-01.jpg","width":1200,"height":628,"caption":"QlikView Database Connection | QlikView Inline data"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/qlikview-database-connection-inline-data\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"QlikView Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/qlikview\/"},{"@type":"ListItem","position":3,"name":"QlikView Database Connection | QlikView Inline data"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/25857","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=25857"}],"version-history":[{"count":10,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/25857\/revisions"}],"predecessor-version":[{"id":97600,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/25857\/revisions\/97600"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/25869"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=25857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=25857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=25857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}