Before you start:
Before you use any mappings that you create, ensure that any databases that you have defined are correctly registered with ODBC on your machine.
You can add a database mapping input (source) from the Resource Navigator view in two different ways, depending on whether you are adding the database to the workspace for the first time, or the database has previously been imported and is in the workspace.
If you cannot import the database definition, have your database administrator export the database schema files for you to use.
You can also import database schema files using the Data Perspective, which is available with the WebSphere Studio Application Developer Integration Edition.
Database.table_name.However, if you define a broker schema for your application and define tables within the broker schema, you must prefix the table names with the broker schema name to produce the following format:
Database.schema_name.table_name.To do this:
Database.table_name.
Database.schema_name.table_namewhere schema name is obtained from the database table .xmi file.
Database.user_specified_schema_name.table_name.
Defining the database schema name for an individual table, as described above, overrides the global definition in the Preferences dialog (see Defining the schema name).
Related concepts
Mappings
Mapping types
Message mapping
Related tasks
Adding a message mapping input
Adding a message mapping output
Defining the schema name
Related reference
Mappings
Notices |
Trademarks |
Downloads |
Library |
Support |
Feedback
![]() ![]() |
ar03000_ |