Introduction

IBM InfoSphere Master Data Management Server (MDM Server) provides a complex data model for party, account, and product master data, and a large number of services (known as transactions) for querying and modifying master data records. A variety of extension mechanisms are supported to allow the data model and transaction behavior to be customized, or to add completely new transactions if required.

MDM Server includes MDM Server Workbench, tooling that supports development of extensions to MDM Server. The workbench allows you to define the desired data model and transactions and generate the code required to implement the MDM Server extensions. For simple data model extensions, the generated code may meet your requirements without additional work. But if you require new transactions, you will need to customize the generated code to implement the transaction behavior.

Implementing transactions requires knowledge of the MDM Server API and frameworks, as well as general Java™ technology, J2EE, and SQL programming experience.

Learn the basic concepts needed to design new MDM Server transactions with a focus on implementing new queries. Step-by-step instructions are given for building three example transactions that illustrate simple techniques for implementing custom queries.

Objectives

In this tutorial, you will learn:

• The different transaction interface styles
• The different transaction implementation styles
• How to define new query transactions using the MDM Workbench
• How to implement a query transaction as a business proxy
• A technique for implementing simple queries on custom entities with static SQL
• How to implement simple search transactions on custom entities with dynamic SQL

Back to top

Prerequisites

You need to be familiar with MDM Server and the MDM Server Workbench tooling, know how to use the workbench to develop simple data model extensions, and have experience of Java programming using the Eclipse development environment.

System requirements

To follow along, you will need an MDM Server development environment. This tutorial was developed using MDM Server Workbench V9.0.2 installed on Rational® Software Architect V7.5.5, with WebSphere® Application Server V6.1 and DB2®.

If you are using an earlier version of MDM Server, the same concepts and techniques are applicable, but some of the workbench features described here may not be available to you.

1 of 10 | Next

Comments

Back to top

Table of contents

• Introduction
• Implementing a custom query transaction
• Generating skeleton code with the MDM Server Workbench
• Implementing a query transaction as a Business Proxy
• Customizing a Get Record transaction
• Implementing a search transaction with dynamic SQL
• Summary
• Download
• Resources
• About the author

---

1 of 10 | Next

Local resources

• IBM Innovation Center - Austin, TX
• IBM Innovation Center - Chicago, IL
• IBM Innovation Center - Dallas, TX
• IBM Innovation Center - San Mateo, CA
• IBM Innovation Center - Waltham, MA
• Technical Briefings in North America

Dig deeper into Information Management on developerWorks

Try IBM PureSystems. No charge.

Experience today!

---

Get started with the cloud-based trial and pattern development kit.