I know 9.0 came out, but has anybody started or achieved the functionality of updating db connections in bulk? We have a need to do this, and I will start on a Python script next week, but would prefer to not recreate the wheel if somebody has already started.
Nightly before the batch schedule initiates.
The concept I'm thinking to implement is to get workbook / data source connections that have a specific host name within our GP database. Then update these to use a generic app id / password to connect to the database. This way user credentials will not fail.