Integrating IBM InfoSphere Information Server
You can integrate IBM® InfoSphere® Information Server with Product Master. This integration enables use of IBM InfoSphere Business Glossary and IBM InfoSphere DataStage® with Product Master.
Product Master provides Java™ APIs that can be used to export PIM metadata, such as, specs and attribute collections for use in IBM InfoSphere Information Server tools: IBM InfoSphere Business Glossary and IBM InfoSphere DataStage. Data from IBM InfoSphere DataStage can also be imported into PIM using the tools and scripts available within the product.
Overview of IBM InfoSphere Information Server integration
IBM Product Master (Product Master) provides scripts, documentation, and Java APIs that make integration with the IBM InfoSphere Information Server eier.- Metadata export
- Export attribute collection in XSD formats with Product Master 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 Product Master spec attribute name details, with Product Master 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 and IBM InfoSphere QualityStage can further help data cleansing.
Final transformed output of IBM InfoSphere DataStage can be consumed by Product Master with the product APIs. Again, Product Master 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 Product Master. You can also use the IBM InfoSphere DataStage and IBM InfoSphere QualityStage components to publish data of improved quality to downstream systems.
Exporting for the business glossary
The glossary export capability exports IBM Product Master specification attribute name details in the business glossary format./**
* This method takes a Collection of String representing the Spec Names as the
* input parameter and exports the metadata(spec) description in the
* Business Glossary format in a XML file and uploads the file to the
* docstore for each spec.
*
* @param specNames Collection of Spec names
* @throws PIMInternalException when internal error occurs
* @throws IllegalArgumentException when the Collection of SpecNames is null
*/
public void exportBusinessGlossary(Collection<String> specNames);
/**
* This method returns a Business Glossary XML as String for given Spec
* name.
*
* @param specName
* Spec name to be exported for Business Glossary
* @return String XML content as a string
* @throws PIMInternalException when internal error occurs
* @throws IllegalArgumentException when the specName is null
*/
public String getBusinessGlossary(String specName);Loading data from upstream systems
For more information, see Loading data from upstream systems.
Publishing data to downstream systems
For more information, see Publishing data to downstream systems.