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.