Before adding a database to the mapping, make sure to select a transformation language where database mappings are supported. This can be either the BUILT-IN transformation language, or any of the following languages: C++, C#, Java (see also Selecting a Transformation Language). Note that, if you intend to deploy the mapping to FlowForce Server or execute it with MapForce Server, or use features such as Bulk Transfer and stored procedures, BUILT-IN must be selected as transformation language.
Once the desired transformation language is selected, you can add a database to the mapping in one of the following ways:
•On the Insert menu, click Database.
•Click the Insert Database ( ) toolbar button.
When you take any of these actions, a database connection wizard appears, guiding you through the steps required to connect to the database.
Database Connection Wizard
|Note:||In some advanced scenarios, databases can also be added to the mapping as variables (see Using Variables). When you choose to add a database structure as a variable, the same database connection wizard mentioned above appears.|
For instructions about setting up a connection to any of the databases supported by MapForce, see Connecting to a Database.
Once the database connection is successfully established, you are prompted to select the database objects that should appear on the mapping. See Adding, Editing, and Removing Database Objects for further information.