If your Windows Authentication or other data source user account password changes, you may need to update the password in objects that were published from that data source to Intelligence Central. This can include objects you access in Intelligence Central, as well as objects you published yourself.
Use this guide to help you determine where you may need to update your password when it changes and how to accomplish this for the various object types in Intelligence Central.
The following are objects in Intelligence Central where your password might be used and where you might need to update your password if it changes.
Windows Authentication is sometimes used to provide user account credentials to a data sources. Review the following to help determine where you might need to update your Windows Authentication password when it changes.
Toad allows you to use Windows Authentication to create a connection to the following data sources.
In addition, you might be connecting to other data sources that are pre-defined to use your Windows Authentication account.
You might also be using your Windows Authentication account to run scripts on Intelligence Central.
The first step is to update the password in the Toad connection when the password to the data source changes. Perform this step prior to attempting to change the password for a connection in an Automation script or Toad document published to Intelligence Central.
To change a connection password
Each time you publish a view or snapshot to Intelligence Central from a remote data source, an Authentication key is created. This key stores the login information to the remote data source. For objects you publish, this information is automatically gathered from your Toad connection during publishing. For objects others publish with a Private key, you provide your own login information the first time you access the object.
If your password to a remote data source changes, you must also change this password in your Authentication key/keys. You must do this for each object published from this data source that has a Private key applied. For objects with a Shared key, the Authentication key can be updated once by the owner.
For more information about Authentication keys, see User Authentication in Intelligence Central.
Tip: If you attempt to access a view or refresh a snapshot and you encounter an "invalid password" or "logon denied" error from the data source (such as an ORA-01017 error from an Oracle database), this may indicate that you need to update the password in your Authentication key for that object.
To change the password for views and snapshots
See Alter Authentication for more information.
If you publish a script that uses a connection to a remote data source and then run the script on the Intelligence Central server, when your password to that remote data source changes you must update the connection information in the script.
In addition, each Automation script executing on Intelligence Central runs under a specified user account. If scripts are currently running on Intelligence Central under your Windows Authentication account, you must update the account information when your password changes.
To change the password for a connection in a script
To change the password for script execution
Toad documents, such as Query Builder files, can contain one or more connections. If you published a Toad document containing a connection and you want to update the password, you can do so by editing the document using the Get File command.
Query Builder files and other Toad documents (except Automation scripts) shared through Intelligence Central must be executed in Toad Data Point. Therefore, entering credentials or modifying the connection in the document is a fundamental part of the Get File process.
To change the password for a connection in a Toad document