Extend enterprise information integration with metadata tools

You can use the metadata tools that are provided with this product to enhance and extend the information that you have accessed with the InfoSphere Information Server federated functions.

An enterprise needs to access and integrate diverse data assets and infrastructures. Enterprises need to integrate with new businesses and support new business assets with existing systems. The need for a solution to efficiently access and manage information crosses product and industry boundaries.

The workbench provides metadata-driven design tools for visualizing, mapping, finding relationships, and generating code.

Start with InfoSphere Information Server

To use the functions of InfoSphere Information Server with the workbench, you must install InfoSphere Information Server. Then you access the diverse data sources that are in your enterprise by using the federated functions. The next task is to determine what you can combine and how to combine it.

The metadata tools in the workbench can help you solve some of the following problems:
Finding relationships and designing queries
  • Create efficient and useful queries of the heterogeneous information.
  • Find out what information is available.
  • Determine how to combine information from different schemas.
  • Find out the relationships between information elements.
Deploying
  • Compare and synchronize changes in data objects.
  • Generate and deploy scripts that are compliant with the InfoSphere Information Server environment.

By using the workbench with InfoSphere Information Server, you can share the metadata between the heterogeneous products. The workbench provides tools that support the management, impact analysis, search, and reporting across all forms of metadata. You can then map your heterogeneous data and structures and deploy to a server.

Use the integrated data sources with the workbench tools

The workbench extends the function of InfoSphere Information Server with the following actions:
  • Mapping the schemas. You can include a variety of heterogeneous data sources in your mapping model. The schemas can originate from any of the data sources that the workbench supports. If you are using federated data sources, you can include federated nicknames and views in the physical data models.
  • Finding relationships between the heterogeneous schemas. The discover function can automate the action of finding matching elements between divergent data sources that might not be visually apparent.
  • Transforming, and applying filters, joins, or sorts to source elements. You can use the Expression Builder to transform source elements to be compatible with target elements.
  • Generating and deploying new objects. You can generate scripts that reflect the variety of data sources and then deploy those scripts to non-federated or federated servers.
Related tasks
Generating scripts that you can deploy

Feedback