topic Re: How to connect with Database? in QlikView

How to connect with Database?

Tue, 23 Sep 2014 11:16:45 GMT

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.

Re: How to connect with Database?

ajaykumar1 — Tue, 23 Sep 2014 11:25:22 GMT

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

Re: How to connect with Database?

ashfaq_haseeb — Tue, 23 Sep 2014 11:30:08 GMT

After making connection

Try below

SQL SELECT *

FROM "ODSUAT"."Tablename";

Hope it helps

regards

ASHFAQ

Re: How to connect with Database?

Tue, 23 Sep 2014 11:34:25 GMT

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

Re: How to connect with Database?

ashfaq_haseeb — Tue, 23 Sep 2014 11:38:28 GMT

look at my reply

Re: How to connect with Database?

Tue, 23 Sep 2014 12:15:17 GMT

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

Re: How to connect with Database?

ashfaq_haseeb — Tue, 23 Sep 2014 12:19:24 GMT

I know its schema name

Try that, by the way no attachment found

regards

ASHFAQ

Re: How to connect with Database?

Tue, 23 Sep 2014 12:54:18 GMT

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.

Re: How to connect with Database?

ashfaq_haseeb — Tue, 23 Sep 2014 12:59:33 GMT

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