How to connect with Database?

[#1]

Hi Community,

user has given one view to me i have to fetch data of that view from database but that view is in Qlikview Schema of ODSUAT schema(e.g ip adress 255.255.255.255)

so how i fetch that data.

Thanks in advance.

[ajaykumar1]

Hi,

To connect to the DB, we have to make ODBc/OLEDB connection---provide the server/DB name----Userid/pwd(or Windows NT).

Once you connect to the DB then find the name of the schema and the tables in that.

Regards,

Ajay

[ashfaq_haseeb]

After making connection

Try below

SQL SELECT *

FROM "ODSUAT"."Tablename";

Hope it helps

regards

ASHFAQ

[#4]

Hi Ajay,

thanku for your qiuk reply.

But user has told me that you have fetch the data from ODSUAT schema,  so i don't how to fetch the data from ODSUAT schema..

[ashfaq_haseeb]

look at my reply

[#6]

Hi ashfaq,

thanks for your reply

ODSUAT is not database name i have found one option in our qlikview edit script find the attached screen shot

[ashfaq_haseeb]

I know its schema name

Try that, by the way no attachment found

regards

ASHFAQ

[#8]

Hi Ashfsaq,

please find attached word file.when i try to connect with database through this option but i do not know how to connect with database.

[ashfaq_haseeb]

Hi,

First you need to establish a oledb or ODBC connection

Which server you are connecting with?

Ask your DBA to provide you a odbc or oledb connection on your QlikView server

regards

ASHFAQ