Open topic with navigation

About Dynamic SQL Address Book Link

The FootPrints Dynamic SQL Address Book Link feature retrieves contact data dynamically from supported contact databases for the Address Book via ODBC.  Open DataBase Connectivity, or ODBC, is a standard relational database access method developed by Microsoft Corporation.  The goal of ODBC is to make it possible to access any data from any application, regardless of which database management system (DBMS) is handling the data. FootPrints harnesses this power by providing access to existing ODBC-compliant contact data without requiring that the records be loaded into a separate FootPrints Address Book.  The supported ODBC-compliant databases include Oracle, SQL Server, Access, MySQL, and DB2.

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.

FootPrints dynamically accesses the outside database for contact information in the Address Book.  This feature is an optional add-on module and must be activated on your FootPrints server for the option to appear.  Please contact your BMC salesperson or reseller if you would like to purchase this option.

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.

This section contains the following topics:

• Selecting a data source for the Address Book
• Linking to an Existing Address Book
• Convert an Existing Address Book
• Naming the Data Source
• Dynamic SQL Address Book Configuration
• Linking to the Data Source
• Selecting the table used from the Data Source
• Data Source Table Mapping
• Address Book Field Setup
• Displayed Name and Field Type
• FootPrints Fields
• Customer Primary Key Select
• Organizational Unit
• Using a Dynamic SQL Address Book
• Limitations

©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.