Can anyone tell me how to fetch data from the a sq... - Qlik Community

nikhilgarg · ‎2014-09-17

HEy,

Can anyone tell me how to fetch data from the a sql database ??

Please help.

Thanks

anbu1984 · ‎2014-09-17

Which database do you want to connect?

vikasmahajan · ‎2014-09-17

you can give table name : and execute sql statement in load script following example show how

DIM_CFAMaster:

SQL SELECT

LocId,

LocCode,

"Loc_name",

"Loc_add1",

"Loc_City",

"Loc_Type",

FROM "QLIKVIEW_SIM_DB".dbo."DIM_QV_CFAMaster";

Store DIM_CFAMaster into [$(vQVDFileDir)DIM_CFAMaster.qvd];

Drop table DIM_CFAMaster;

Hope this will help you

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

ajaykumar1 · ‎2014-09-17

Hi,

In the Script level---choose ODBC/OLEDB---Click on connect--then choose your DB---Next-----provide server name--

user name and password---and check Allow saving password---test Connection.

Then you will get the ODBc connection string in the script.Then you can Choose SELECT option and import your fields/tables.

Regards,

Ajay

sujeetsingh · ‎2014-09-17

there are vedios to guide you for the same and samples to available just explore man.