Adding database definitions to the IBM Integration Toolkit
You must have a database definition (.dbm file), contained in a data design project, to create database mappings by using the Mapping node.
About this task
A database definition file holds the physical data model that details all the database resources, such as the schema, the tables, and other resources, that you need access to.
If you can connect to your database server by using the IBM® Integration Toolkit, you can create a database definition when you create your database mapping. For more information, see Mapping database content.
If you cannot connect to your database server by using the IBM Integration Toolkit, you must create a database definition file from scratch before you can create your database mapping. For more information, see Creating a database definition from scratch.
You can also use database definitions in other nodes, such as the Compute node, to validate references to database sources and tables. You must include a data design project in an application, or reference it from an Integration project, before you can use the database definitions that the data design project contains.
Database definition files in the IBM Integration Toolkit are not automatically updated. If you modify your database, you must re-create the database definition files.
- Creating a data design project
- Creating a database definition by using the New Database Definition File wizard to connect to a database server.
- Create a database definition from scratch when it is not possible to connect to the database server by using the IBM Integration Toolkit.
- Creating a database definition (.dbm file) by using the New Database Definition File wizard
- Creating a database definition from scratch