ETL process in QLIKVIEW using SQL.

[prasad333]

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

[Anil_Babu_Samineni]

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 ..

[techvarun]

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?

,

[prasad333]

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.

[prasad333]

Hi Anil,

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

[oknotsen]

What is the data source?

[Anil_Babu_Samineni]

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.

[prasad333]

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.

[oknotsen]

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.

[rwunderlich · Accepted solution]

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