Sql query to pull data in qlikview is good? - Qlik Community

nareshthavidishetty · ‎2016-09-26

Hi ,

I need to know if data pull using direct SQL script in qlikview is good?

If not please let me know the different case scenarios.

Thanks..

Anil_Babu_Samineni · ‎2016-09-26

What do you meant the mean the pull?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

Anonymous · ‎2016-09-26

SQL script in qlikview is useful when we have multiple tables involving in join. This avoids complexity and ambiguous column names errors.

However, this case will be efficient for one time load and then store the data in to qvd's.

pradeep_s · ‎2016-09-26

Ideally NO, but you can use if data volume is too low and no need of Modelling/Calculations.

soloeeeoff · ‎2016-09-26

Yes,

Extracting SQL script can be a good choice if data base has lower amount of data.

1. If it has high no of data, Time elapsed may be high; which interrupts the CONNECTION by referencing the value set in the special variable set in the QlikView

2. Direct discovery : It has the stale after option which will establish the automatic connection with the database whenever the data (Implicit) is to be refreshed.

Thanks

avinashelite · ‎2016-09-26

Yes , it as good as you pull from other systems but it also depends on the data frequency and the amount data your trying to pull