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.

Before you begin

Before you can import the schema into IBM InfoSphere Information Server, you must:

Create your data model.
Define your attribute collection.

Write a trigger script in Product Master that uses the APIs to export the attribute collections created.

Sample script:

getContextMethodDefinition = createJavaMethod("com.ibm.pim.context.PIMContextFactory","getContext","java.lang.String","java.lang.String","java.lang.String") ;
context = runJavaMethod(null, getContextMethodDefinition, user_name, password, company_name) ; 

getIISIntegrationDefinition = createJavaMethod("com.ibm.pim.context.Context","getIISIntegration") ;
IISIntegration = runJavaMethod(context , getIISIntegrationDefinition) ; 

getAttributeCollectionMetadataDefinition = createJavaMethod("com.ibm.pim.utils.IISIntegration","getAttributeCollectionMetadata","java.lang.String") ;
xsdString = runJavaMethod(IISIntegration , getAttributeCollectionMetadataDefinition, attribute_collection_name) ; 

xsdString = substring(xsdString,38);

out.write(xsdString);

Export your attribute collection as an XSD file.

About this task

Table definitions are flat lists of attributes. If you want to represent the complex structures in IBM Product Master specs, you must create multiple table definitions for each grouping level within the hierarchical structure. You must run the import process once for each table definition that you want to create.

If the spec allows for multiple addresses, and if the source feeds multiple addresses, then you must have a table definition for the addresses. If the source has one address, then the address attributes can be part of the main table definition that is imported from the XSD.

Procedure

Open the IBM InfoSphere DataStage and IBM InfoSphere QualityStage® Designer.
Click Import > Table Definitions > XML Table Definitions
Use the Import window, click File > File from the Web. In the subsequent popup, provide the URL to run the attribute collection export trigger script, which is already created in Product Master.

URL format: http://server_name:port/utils/invoker.jsp?company_code=company_code&invoking_user=user_name&bUserOutput=false&script=trigger_script_name.

Sample URL: http://localhost:8080/utils/invoker.jsp?company_code=trigo&invoking_user=Admin&bUserOutput=false&script=GetAttrCollectionMetadata.Wpcs. Where, GetAttrCollectionMetadata.wpcs is the trigger script that is created for exporting attribute collection. This script fetches the attribute collection metadata into IBM InfoSphere DataStage. Establish primary key relationships and save the table definition.
Repeat step 2 and 3 for each table definition that you want to create.
Export the Product Master spec and save it as a file. From IBM InfoSphere Business Glossary, click Manage Categories tab. Browse the file name of the spec that is saved and click Upload. Spec attributes are imported per business glossary definitions.