Adding Databases to the Mapping Print this Topic Previous Page Up One Level Next page

Home >  Data Sources and Targets > Databases and MapForce > Introduction to Database Mappings >

Adding Databases to the Mapping

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 ( mf_ic_insert_db ) 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 on how to proceed with this wizard so as to set 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.

© 2019 Altova GmbH