Publishing data to downstream systems

You can use the IBM® InfoSphere® Information Server product, along with IBM InfoSphere Master Data Management Collaboration Server to transform data from downstream systems.

1. Exporting the product data

   You can use existing IBM InfoSphere Master Data Management Collaboration Server features to export the product data into a CSV file that InfoSphere DataStage can read.

2. Defining the attribute collection

   You can define an attribute collection in InfoSphere MDM Collaboration Server to match the data that you want to import from IBM InfoSphere DataStage. You can then import this metadata from InfoSphere MDM Collaboration Server into IBM InfoSphere DataStage to design and build your IBM InfoSphere DataStage jobs. Before you can export your data from external or input systems to cleanse it using IBM InfoSphere DataStage, you must define the attribute collection that includes the attributes from one or more of your specifications.

3. Exporting the attribute collection

   To cleanse the product information data, you must export the attribute collections that are created in InfoSphere MDM Collaboration Server in a format that IBM InfoSphere DataStage can use.

4. Importing the schema into IBM InfoSphere Information Server

   You must import your XSD file into IBM InfoSphere Information Server. Importing the XSD creates the table definitions in IBM InfoSphere DataStage that outline the column names, data type, length, and other column properties of the data that you want IBM InfoSphere DataStage to process.

5. Building InfoSphere DataStage and InfoSphere QualityStage jobs

   You can use the IBM InfoSphere DataStage and IBM InfoSphere QualityStage Designer to build jobs that cleanse, transform, and write data to a database table or a comma-separated value (CSV) file. After the data is written, you can import the data into IBM InfoSphere Master Data Management Collaboration Server