topic Re: dynamic DSN creation in QlikView

dynamic DSN creation

anat — Fri, 13 Feb 2015 10:40:16 GMT

Team,

how to pull the data from multiple databases(sql server),for multiple databases how to create dynamic DSN's and if data bases are increase then automatically it should create DSN, suppose if one DB is removed then DSN also should remove and how to connect all these DSN's in qlikview, and automatically qlikview should extract data from all available DSN DB.

1)how to create dynamic DSN's

2)how to connect all available DSN's in qlikview at a time

Regards

.............

Re: dynamic DSN creation

giakoum — Fri, 13 Feb 2015 10:48:43 GMT

You can put the connection string in a excel file, and loop through them in QlikView to create the connections

Re: dynamic DSN creation

anat — Fri, 13 Feb 2015 13:55:09 GMT

any alternative ways?

Re: dynamic DSN creation

giakoum — Fri, 13 Feb 2015 14:05:23 GMT

you need to be more specific. What is it you want to achieve? Why and how are databases changing etc.