Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
After making connection
Try below
SQL SELECT *
FROM "ODSUAT"."Tablename";
Hope it helps
regards
ASHFAQ
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..
look at my reply
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
I know its schema name
Try that, by the way no attachment found
regards
ASHFAQ
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.
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