How to: |
Data adapters must be configured to allow the DataMigrator Server to access data on different types of databases. Once a data adapter is configured, you can create metadata for the tables or views in the form of synonyms. The synonyms are used to both access the data as sources, and to write the data to targets.
To access data in the DM process, the data adapters you need must be defined to the server. You need to add and configure a data adapter for every database type you want to access.
You can also configure and test data adapters from the Configuring Data Adapters page of the Web Console. For more information, see the Server Administration manual or the Web Console online help.
For complete documentation on configuring data adapters and for a detailed explanation of the associated connection parameters, refer to the Adapter Administration manual.
The Add to Configuration dialog box opens, as shown in the following image.
A confirmation message appears.
For complete documentation on configuring data adapters and for a detailed explanation of the associated connection parameters, refer to the Adapter Administration manual.
The Test Results open, as shown in the following image.
Note: The output will vary depending on the adapter.
The Adapters folder shown in the following image allows you to add and configure adapters from the DMC.
The Adapters folder has the following subfolders:
Contains the adapters that have been configured for this server, as well as the Remote Servers folder.
Contains all of the available adapters that can be configured for this server.
If you right-click the Adapters folder, the following options are available:
Shows a list of data adapters that are available on all platforms.
Displays a report of SQL functions and keywords that show how they are handled for each supported database. The keywords are:
Opens the Filter SQL Optimization Report dialog box, which allows you to specify settings for, and run, the report. The SQL Optimization report shows which functions are optimized to their SQL counterparts by adapter.
Opens the Filter Function Parameters Report dialog box, which allows you to specify settings for, and run, the report. The Function Parameters report lists parameters, description, and function examples.
Opens a submenu for each configured database adapter that opens a help page for the selected adapter.
Opens the Filter Data Types Report dialog box, which allows you to specify settings for, and run, the report, The Data Type report contains mapping options for different data types.
Opens the Change Settings for Common Adapter dialog box, which allows you to change adapter settings.
Opens a submenu with the choices of Alphabetically and In profile order.
For any adapters for which there are multiple connections configured, this controls the order in which they are displayed.
If you right-click an adapter folder, the options shown in the following image are available:
Allows you to configure another connection for that adapter.
Allows you to change optimization settings, controlling session parameters, and miscellaneous settings, depending on the adapter.
Removes the configured adapter from the server.
If you right-click a connection, the options shown in the following image are available:
Allows you to view and change the connection properties.
Allows you to create or update a synonym for that adapter.
Allows you to test the connection.
Shows synonyms and flows that use the selected adapter.
Allows you to delete the connection.
iWay Software |