Page History
...
- 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.
Registering a new data source one at a time
If a data source is not present in Data Source explorer, you can add it.
To register a new data source
- In Data Source explorer, right-click the Managed Data Sources folder, and then select New > Data Source.
- In the New Data Source wizard, select the data source server platform.
- If you have previously set up a group and want to add this data source to that group, select the appropriate group in this window. Otherwise, leave the default selection, Managed Data Sources.
- Click Next.
- Type the connectivity details and login credentials, and then click Test Connection to confirm that the configuration information is correct.
- Click Finish. Data Source explorer now lists the new data source.
Grouping data sources
You can organize data sources in Data Source Explorer into groups and subgroups, which appear as folders. Groups help you manage a large number of data sources.
To create a data source group
- In Data Source Explorer, right-click the Managed Data Sources folder and select New > Data Source Group.
- Type a descriptive name for the new group in the Name field, and then click OK.
Data Source Explorer lists the new group. You can drag and drop data sources into the group folder or add new data sources to the folder.
To create a data source subgroup
- In Data Source Explorer, right-click the Group folder and select New > Data Source Group.
- Type a descriptive name for the new group in the Name field, and then click OK.
Importing and exporting data sources
You can import an existing data source catalog from other IDERA products or from third- party DBMS sources, including:
- Eclipse Data Tools Platform (DTP)
- Previously-registered IDERA Data Sources (File)
- Previously-registered IDERA Data Sources (Registry)
- Quest Software (TOAD)
Conversely, you can export your current data source catalog to a file, which can then be imported into other instances of DB Change Manager using the Previously Registered IDERA Data Sources (File) option.
Info |
---|
If you experience problems importing data sources from other IDERA products, you can import the old data sources using your Windows registry by selecting File > Import... > IDERA > Data Sources > Previously Registered IDERA Data Sources (Registry). |
To import data sources
- Select File > Import > Data Sources.
- Choose a source from which you want to import the data sources, and then click Next.
- Specify the details about the location of the import source.
- Click Finish. Data Source Explorer is automatically populated with the new data sources.
To export data sources
- Select File > Export > Data Sources.
- Browse the list, and then select a data source to export.
- Type or use the Browse File System or Browse Workspace buttons to enter the directory path and file name.
- Click Finish. The data source is exported as an XML file. You can import this file to other instances of DB Change Manager.