Create Mappings

If you do not have the schema that you want in the Data Access Builder window, create a schema mapping by invoking the Data Access Builder SmartGuide. In the SmartGuide steps, specify your schema and then the mapping is created for you. The schema mapping is represented as icons in a tree structure in the Data Access Builder window.

If you already have the schema that you want in the Data Access Builder window, you can create another mapping from the same schema:

  1. Select the schema icon.
  2. Select the appropriate Create Mapping option from the schema's popup menu. If the database source is DB2, you will have the options Create Mapping (CLI) and Create Mapping (ESQL). If the source is ODBC, the option is simply Create Mapping.

The Data Access Builder window displays the new mapping linked to the schema.



Data Access Builder Workflow


Start Data Access Builder SmartGuide
Change Mapping Properties

Change Attribute Properties
Create a Mapping from More than One Database Table
Create More than One Mapping from a Schema