topic Extract Data From Oracle Database and append it to an existing Table in QlikView in QlikView

Extract Data From Oracle Database and append it to an existing Table in QlikView

Wed, 15 Dec 2010 15:24:48 GMT

I am attempting to read a table from Oracle and place the entire table into an existing QlikView table so that I can display the newly added data for a Customer. The end result is so that the Customer can run a new report and see the existing data which will include the new data which was recently added to Oracle. I have and OLEDB Connection to get into Oracle but need a little assistance in getting the data from Oracle into an existing QlikView application and then being able to work with the data once into QlikView.

Extract Data From Oracle Database and append it to an existing Table in QlikView

Wed, 15 Dec 2010 15:30:47 GMT

Hi there

You should be able to just extract it as you would from the Oracle database. Make a connection with your OLEDB driver and then use the Select wizard to create your query.

This will then automagically pull in the table to qlikview and you can manipulate it at will.

//John

Extract Data From Oracle Database and append it to an existing Table in QlikView

Wed, 15 Dec 2010 15:59:55 GMT

I currently have my connection through the Edit Module Section of my Application. I was trying to keep all of my logic in line due to numerous other processing that I have going on. How I can accomplish this in the Edit Module Section?

Extract Data From Oracle Database and append it to an existing Table in QlikView

Wed, 15 Dec 2010 16:07:01 GMT

Using the macro editor (module section) complicates matters as you must then use VBScript (or JScript).

Qlikview is built to use the regular script editor to deal with all connections and have built in wizards for this.

If you must use the macro editor you will have to manually create VBScript connections (most likely using ADO and windows COM objects).

Have a look here http://michaelkizer.com/Blog/tabid/117/articleType/ArticleView/articleId/6/How-to-retrieve-data-from-an-Oracle-database-with-VBscript.aspx for a rundown of this but I STRONGLY suggest you use the script editor instead of the macro editor.

//John

Extract Data From Oracle Database and append it to an existing Table in QlikView

Wed, 15 Dec 2010 16:13:29 GMT

Thanks for the timely response and the valuable information. I appreciate it.

Extract Data From Oracle Database and append it to an existing Table in QlikView

Wed, 15 Dec 2010 17:42:34 GMT

I have another slight problem. While the user/Customer is in QlikView, they are able to add in new data through an input box for a particular table. Currently, in the application, It is structured so that when they query for a report, they have the ability to choose another button which will add in new data for a particular table. Right now I am sending that new data out to an Oracle table. Now I need to be able to bring in that new data back into my QlikView application and append the data to a table which was created in the initial load script. The customer needs to be able to run another report like an hour later and the new data which was written out to Oracle earlier needs to show up in the report that the Customer runs. An easy way to sum it up, how do I take data out from an Oracle table and append it to an existing table in QlikView and be able to do this several times a day.

Extract Data From Oracle Database and append it to an existing Table in QlikView

Wed, 15 Dec 2010 19:44:39 GMT

To achieve this you must use the regular script editor. The you can use partial reloads to only run parts of the script and can then "add" to an existing table.

Remember that Qlikview is built to read data so be careful when you do write backs to databases.

Extract Data From Oracle Database and append it to an existing Table in QlikView

Wed, 15 Dec 2010 20:44:18 GMT

Thanks for the information. I appreciate it.