Overview of IBM InfoSphere Information Server integration
IBM® InfoSphere® Master Data Management Collaboration Server (InfoSphere MDM Collaboration Server) provides scripts, documentation, and Java™ APIs that make integration with the IBM InfoSphere Information Server easier.
- Metadata export
- Export attribute collection in XSD formats with InfoSphere MDM Collaboration Server APIs. This XSD can then be consumed in IBM InfoSphere Information Server tool that is called IBM InfoSphere DataStage® and IBM InfoSphere QualityStage® designer. This step is manual at IBM InfoSphere Information Server. When imported in IBM InfoSphere Information Server, the metadata is stored in IBM InfoSphere Information Server repository.
- Glossary export
- Export of InfoSphere MDM Collaboration Server spec attribute name details, with InfoSphere MDM Collaboration Server APIs, in XML format that is recognized by IBM InfoSphere Business Glossary. This can be consumed by IBM InfoSphere Business Glossary. This is a manual step at IBM InfoSphere Business Glossary.
Data from inbound streams such as classic applications and data feeds into IBM InfoSphere Information Server can be mapped to the metadata that was imported in IBM InfoSphere Information Server. This mapping must be done in IBM InfoSphere Information Server manually. IBM InfoSphere DataStage can now be used to apply transformation rules as appropriate and IBM InfoSphere QualityStage can further help data cleansing.
Final transformed output of IBM InfoSphere DataStage can be consumed by InfoSphere MDM Collaboration Server with the product APIs. Again, InfoSphere MDM Collaboration Server recognizes two data formats: CSV file and database tables.
You can use the IBM InfoSphere DataStage and IBM InfoSphere QualityStage components to transform and cleanse incoming data that is loaded from upstream systems into InfoSphere MDM Collaboration Server. You can also use the IBM InfoSphere DataStage and IBM InfoSphere QualityStage components to publish data of improved quality to downstream systems.
The image that is provided depicts the data flow between IBM InfoSphere Information Server and InfoSphere MDM Collaboration Server.