Design Advise - Large number of servers
Posted: Mon Mar 28, 2011 2:54 am
I have a requirement to connect to 2000 servers and extract the data. The point is, each server is hosting same type of database and metadata also same.
I am just wondering creating 2000 separate dsn to connect to all the servers and extract the data is not a usual thing in ETL space. The data I need to pull from each server is leass than .5 million.
Please advise, can we say ETL is a best fit here? if yes, is there any method to dynamically create DSN's. Or any better approach where people follow in such cases
Many thanks in advance.
I am just wondering creating 2000 separate dsn to connect to all the servers and extract the data is not a usual thing in ETL space. The data I need to pull from each server is leass than .5 million.
Please advise, can we say ETL is a best fit here? if yes, is there any method to dynamically create DSN's. Or any better approach where people follow in such cases
Many thanks in advance.