topic Re: ETL process in QLIKVIEW using SQL. in QlikView

ETL process in QLIKVIEW using SQL.

prasad333 — Wed, 11 Oct 2017 05:27:25 GMT

Hi, my name is Kharansu. I am learning Qlikview these days. Well my question is, which SQL commands can be used to extract data from any server if the OLEDB and ODBC drivers don't work? Please try to answer with real time example if possible.

Regards,

KHARANSU

Re: ETL process in QLIKVIEW using SQL.

Anil_Babu_Samineni — Mon, 16 Oct 2017 10:39:46 GMT

First of all, Welcome to Qlik world ..

For your question - Without that, Either you need to download and install Packages which done by Mik for some information. By help of packages we can able to pull the data from sources ..

Re: ETL process in QLIKVIEW using SQL.

techvarun — Mon, 16 Oct 2017 10:43:49 GMT

Hi,

To perform the ELT process from SQL server to QlikView you must establish a connection.

You can achieve the same without a connection string with one additional step.

from SQL load the table into a csv file from CSV load it into QlikView.

Is this what your question?

Re: ETL process in QLIKVIEW using SQL.

prasad333 — Sun, 05 Nov 2017 13:59:12 GMT

Hi Varun,

Thank you for answering but actually 'am concerned about the SQL command or codes which are written to extract the data if there is a data mismatch or delay in loading the data into qlikview. I am not that experienced in this. I have heard in a discussion but couldn't figure out what was it exactly. Please try to solve it with the possible scenarios. Thank you.

Re: ETL process in QLIKVIEW using SQL.

prasad333 — Sun, 05 Nov 2017 14:00:41 GMT

Hi Anil,

Thank you for answering but I was looking for the specific SQL commands. Hope you understand.

Re: ETL process in QLIKVIEW using SQL.

oknotsen — Sun, 05 Nov 2017 14:23:47 GMT

What is the data source?

Re: ETL process in QLIKVIEW using SQL.

Anil_Babu_Samineni — Sun, 05 Nov 2017 14:55:28 GMT

First of all, We don't require to learn any commands while extracting from ETL because Qlik automatic generate some script so like Select, SQL for main cases and there you need to understand business of each.

Re: ETL process in QLIKVIEW using SQL.

prasad333 — Sun, 05 Nov 2017 15:00:32 GMT

Hi Onno,

As I have mentioned earlier that I am very new to qlikview, so I don't have any real time data. I just heard in a discussion, so got the curiosity to understand it. I know it's tough to answer but that's why I seek your help.

Thank You.

Re: ETL process in QLIKVIEW using SQL.

oknotsen — Sun, 05 Nov 2017 22:06:05 GMT

Being new to QlikView has nothing to do with what I am asking you .

You have some sort of source that has data in it. What is that source?

We are trying to get a grip on what your problem is.

If we know the source, we can tell you how to connect to it.

Re: ETL process in QLIKVIEW using SQL.

rwunderlich — Mon, 06 Nov 2017 02:22:31 GMT

A working ODBC or OLE/DB driver is required to extract data from a relational database into QlikView. The QV script statement "SQL" passes whatever follows "SQL" (up to the semicolon) through the driver to the database for execution. QV does not execute the SQL statement, it consumes the data returned by the SQL statement.

The passed SQL statement may be as simple as "SELECT * FROM mytable" or a much more complex SQL statement. QV doesn't care or have limitations as the SQL is executed by the database.

The data returned by the driver may optionally be manipulated by QV script statements to create the final data QV model.

Your original question asked: " which SQL commands can be used to extract data from any server if the OLEDB and ODBC drivers don't work?" The answer is "None" if a standard relational DB. QV requires a working (installed, licensed and properly configured) driver to extract data from an external database.

Is there a specific database or datasource you are having difficulty with that we can offer help on?

-Rob

Re: ETL process in QLIKVIEW using SQL.

prasad333 — Mon, 06 Nov 2017 03:44:53 GMT

Thank you Rob. I was looking for this answer. May be my channelization wasn't perfect but you got the sense. Thanks again.

Re: ETL process in QLIKVIEW using SQL.

rwunderlich — Mon, 06 Nov 2017 22:11:15 GMT

Glad to help. If you got the information you are looking for, please mark an answer "Correct" to close the thread.

-Rob

Re: ETL process in QLIKVIEW using SQL.

prasad333 — Thu, 09 Nov 2017 13:08:44 GMT

My intention to put this discussion here is to attract not only 100% experts but the beginners as well to share as many examples of set analysis as they can where they have found difficulties and solved it fully or partially.