You are here: Chapter 7: Configuration and Administration > Workspace Administration > Fields > Dynamic SQL Field Mapper

Dynamic SQL Field Mapper

This feature enables data from an external table to be populated in an Issue into one or more fields. The lookup is performed automatically when lookup key field is populated. The lookup key field may be something like "User ID", "Asset Name", etc.

One or more lookup key fields can be designated within a Workspace. The lookup key field can be either an Issue Information or Address Book field. Associated Issue Information or Address Book fields can then be designated to be populated with data from the external database. Allowed field types for lookup are character (single line), integer, mail, and drop-down.

Note

If a customer process has an Access database open, FootPrints may not be able to read that Access database until the customer process closes. If you encounter this situation, check the permissions for the folder in which the database (.mdb) file is located and make sure that the folder is enabled for read and write permissions for everyone. When the folder is enabled with read and write permissions for everyone, the database should be available to FootPrints and the customer process at the same time.

Supported Databases

Windows FootPrints versions—Can connect to MS SQL Server, Oracle, MySQL, Sybase, Postgres, Access, and DB2 for Windows.
UNIX/Linux Versions—Can connect to Oracle, MySQL, DB2 or Postgres. If the external database is of a different type than the FootPrints database, a DBD driver must be built.

Note

This feature is part of the Dynamic SQL Database Link add-on module and must be licensed. Please contact your salesperson for more information on obtaining a license to enable this feature.

Topics in this section:

©Copyright 1999, 2009 BMC Software, Inc. © Copyright 1996 - 2017 BladeLogic, Inc. BMC, BMC Software, and the BMC Software logo are the exclusive properties of BMC Software, Inc., are registered with the U.S. Patent and Trademark Office, and may be registered or pending registration in other countries. All other BMC trademarks, service marks, and logos may be registered or pending registration in the U.S. or in other countries. All other trademarks or registered trademarks are the property of their respective owners. FootPrints is the exclusive property of BladeLogic, Inc. and is registered with the U.S. Patent and Trademark Office, and may be registered or pending registration in other countries. All other BladeLogic trademarks, service marks, and logos may be registered or pending registration in the U.S. or in other countries. All other trademarks, service marks, and logos may be registered or pending registration in the U.S. or in other countries. All other trademarks or registered trademarks are the property of their respective owners.BladeLogic, Inc. and BMC Software, Inc. Confidential. Click here for the installation guide which includes the provisions described in the BMC License Agreement and Order related to third party products or technologies included in the BMC Product.