All Forums Teradata Studio
tsalonia 6 posts Joined 09/13
09 Jun 2016
Is there a way to modify Connection Properties of DB Connections through some external Windows config file?

We are in the process of migrating our systems to a new environment, with new server names, and, as such, need to modify all users' connection properties within Studio.  Is there a way to modify these connection properties in an external file in Windows somehow?  I would like for our Desktop Support team to be able to write a batch process to be able to mass-update this file to modify the connection properties for the new servers.  Possible?

fgrimmer 553 posts Joined 04/09
09 Jun 2016

1) One option is to distribute an .xml file that contains the connection profile with the new server name in the profile definition and users would import it into their Studio or Studio Express. During the import, be sure to check the box "Overwrite existing connection profiles with same names". The Export and Import options are on the Data Source Explorer toolbar.
2) The other option is to pre-configure connection profiles that are used during the install process. There is a template in the /config directory of the Windows install unzipped media. During install it will ask if you want to pre-configure connection profiles and locate the configuration file. This would be an approach to distribute Connection Profiles to your users during install.

tsalonia 6 posts Joined 09/13
10 Jun 2016

Are these connection profiles stored in a file somewhere on the OS?

fgrimmer 553 posts Joined 04/09
10 Jun 2016

Yes, but it is encrypted.

tsalonia 6 posts Joined 09/13
10 Jun 2016

ok, for option 1 above, each user may have a different name for a given connection to a particular server, since these names are customizable.  how would we address this with a generic .xml file distribution?  we don't know what the entry name is for every user.  the only think that would be consistent would be the server name.

fgrimmer 553 posts Joined 04/09
10 Jun 2016

It will import any new connection profiles or overwrite existing ones that match the name. Possibly another option is to modify the host files that map the database server names?

You must sign in to leave a comment.