Some IDERA products contain data source catalogs that are shared with DB Optimizer. In other words, instead of manually adding data sources to the environment, you can import an existing data source catalog from other IDERA products or third-party DBMS sources.
You can import Data Sources via the File > Import command in the Main Menu, expanding the IDERA folder in the Data Source Selection tree, and then choosing Data Sources.
The following types of sources can be imported to Data Source Explorer:
Once a data source is registered, it automatically appears in Data Source Explorer. Connection parameters are stored locally, and DB Optimizer can be set to connect automatically each time you select the data source from the tree.
Conversely, you can also Export your current data source catalog to a file, which can then be imported into other instances of DB Optimizer via the Previously Registered IDERA Data Sources (File) option. This is performed using the File > Export command in the Main Menu, and then selecting IDERA > Data Sources from the tree view in the Export dialog.
To import data sources
To export data sources
| | | | | | | |