How to: |
Synonyms constitute the metadata that DataMigrator requires to define unique names (or aliases) for each table or view that is accessible from the server. A synonym must be created for every table that DataMigrator accesses.
Once you have created the metadata (synonym), it is a good idea to test it to make sure that the data is available for DM processing.
You can also create and test metadata from the Managing Metadata page of the Web Console. For information, see the Server Administration for UNIX, Windows, OpenVMS, IBMÂ i, and z/OS manual or the Web Console online help.
The Select adapter to configure dialog box opens, showing the adapters that you have configured.
The Select Synonym Candidates dialog box opens, as shown in the following image.
Note: The contents of this dialog box will depend on the adapter selected.
The Create Synonym dialog box opens, as shown in the following image, showing all objects that meet the specified criteria.
Note: If the cardinality of the tables to be used in the application are dynamic, it may not be beneficial to choose this setting.
If this option is selected, column data is retrieved dynamically from the data source at the time of the request.
To select all tables or views in the list, select the check box to the left of the Default Synonym Name column heading.
To select specific tables or views, select the corresponding check boxes.
Synonyms are created and added under the specified application directory.
The status field of the Create Synonym window shows that the synonyms were created successfully, as shown in the following image.
If you create a synonym for a relational stored procedure, you can use that stored procedure as a data source in a flow. When you create the synonym, you will be prompted for values for the parameters of the procedure. For information on creating the flow, see How to Use a Relational Stored Procedure as a Data Source.
We are using Oracle as an example for this procedure.
The Select Synonym Candidates (Step 1) dialog box opens, as shown in the following image.
The Select Synonym Candidates (Step 2) dialog box opens.
The Select Synonym Candidates (Step 3) dialog box opens.
Note: Values entered are used only when creating the synonym and are not saved.
A confirmation message appears.
The synonym now appears in the navigation pane listed under the application directory it was created in, as shown in the following image.
Note: If the synonyms are not listed, select the synonyms button from the toolbar above the navigation pane.
Sample procedures and data are needed for Tutorial: Creating Data and Process Flows With DataMigrator and for the exercises in Advanced DataMigrator Tips and Techniques.
The Create Sample Procedures and Data dialog box opens, as shown in the following image.
Note: The WebFOCUS samples are not used with DataMigrator but creates Star Schemas and loads data into them for reporting.
The Retail Demo loads tables with a pre-determined amount of data designed for WebFOCUS reports.
The Star Schema with variable data option generates random data. It allows you to specify the number of rows generated for each dimension table, a start date, and the number of rows loaded in the fact table.
For the Prefix for SQL Tables field, use the default value unless you have a reason to avoid tables starting with the indicated default. If so, enter a different value.
For the Application directory field, use the default directory, ibisamp, to make it easier to follow the tutorial described in Tutorial: Creating Data and Process Flows With DataMigrator, Advanced DataMigrator Tips and Techniques, and other examples in this manual.
When the creation process is complete, a confirmation message appears, as shown in the following image. The message will depend on the type of samples you create, for example, DataMigrator - General, DataMigrator - Iterator, DataMigrator - File Listener, DataMigrator - Star Schema, Star Schema with Stress Test Data.
The message also displays in the Console Log.
The procedures and synonyms appear in the ibisamp application directory, which is created and added to the server search path during installation. For FOCUS, the sample data is also stored in ibisamp. For other adapters, it is stored in the database of the configured adapter. The source data for the file listener flow is stored in ibisamp in four files with names starting with dmord and an extension of data.
Star Schema sample procedures are needed for Loading a Star Schema.
The Create Sample Procedures and Data dialog box opens. Your display will depend on the specific adapters you have configured.
For the Prefix for SQL Tables field, use the default value unless you have a reason to avoid tables starting with the indicated default. If so, enter a different value.
For the Application directory field, use the default directory, ibisamp, to make it easier to follow the tutorial described in Tutorial: Creating Data and Process Flows With DataMigrator, Advanced DataMigrator Tips and Techniques, and other examples in this manual.
Star Schema sample procedures created for database
where database indicates the database type you have selected.
The procedures and synonyms appear in the ibisamp application directory, which is created and added to the server search path during installation.
From the DMC:
The Create Sample Procedures and Data dialog box opens. Your display will depend on the specific adapters you have configured.
For the Prefix for SQL Tables field, use the default value unless you have a reason to avoid tables starting with the indicated default. If so, enter a different value.
For the Application directory field, use the default directory, ibisamp, to make it easier to follow the tutorial described in Tutorial: Creating Data and Process Flows With DataMigrator, Advanced DataMigrator Tips and Techniques, and other examples in this manual.
Additional sample procedures and data are needed for Iterating Through Multiple Tables. These instructions should be followed after you have loaded the sample data and procedures for DataMigrator.
The Create Sample Procedures and Data dialog box opens. Your display will depend on the specific adapters you have configured.
For the Prefix for SQL Tables field, use the default value unless you have a reason to avoid tables starting with the indicated default. If so, enter a different value.
For the Application directory field, use the default directory, ibisamp, to make it easier to follow the tutorial described in Tutorial: Creating Data and Process Flows With DataMigrator, Advanced DataMigrator Tips and Techniques, and other examples in this manual.
Sample procedures created for database
where
Indicates the database type you have selected.
The procedures and synonyms appear in the ibisamp application directory, which is created and added to the server search path during installation.
Find the dmplntpf flow in the list, right-click it and select Submit.
iWay Software |