dynamic DSN creation

[anat]

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

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

[giakoum]

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

[anat]

any alternative ways?

[giakoum]

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