DB Change Manager can register data sources by scanning your systems on startup or as needed. Also, instead of scanning, you can provide the information for one data source at a time.
Once registered, the data source appears in the Data Source Explorer view. If you have created more than one workspace, they all share the same data source catalog. You can organize data sources into groups and subgroups.
Once a data source has been registered, the connection parameters are stored locally. In some cases, a user ID and password are required to connect to a registered data source. DB Change Manager can encrypt and save user IDs and passwords to connect automatically.
You can import an existing data source catalog from other IDERA products, or from third- party DBMS sources. You can also export a data source to an XML file. These topics include:
Registering data sources on start up
When DB Change Manager first starts, it prompts you to discover data source catalogs that have been created by any previously installed IDERA products (DBArtisan, Rapid SQL, DB Optimizer), or other instances of DB Change Manager.
Additionally, the system can scan your machine for the client software of all supported third- party DBMS platforms (TOAD or Eclipse Data Tools Platform) and add them to the data source catalog.
If you do not want to do this on startup, at a later time you can scan for data sources, or add them one at a time.
Scanning for and registering data sources
DB Change Manager can register data sources by scanning your systems.
To initiate a scan for data sources
- Click the Discover Data Sources icon at the top of Data Source explorer.
- In the Discover Data Sources dialog, choose the type of data sources that you want returned in the search results.
- Click Next.
The search returns a list of the discovered data sources.
- Choose the data source(s) that you want to add to the DB Change Manager environment, and then click Finish. Data Source explorer automatically populates with the new data source selections.
