InfoSphere DataStage integration in InfoSphere Information Server

Collaborate across projects by using the metadata repository

The metadata repository serves as a collaboration point for users of the components in InfoSphere Information Server. You can investigate the metadata in the repository from across projects to support impact analysis and data lineage so that your organization understands how information is used.

For example, a data analyst in your company can profile data and discover that some of the data in a specific resource is bad. As a developer, you can review the data profile and develop a job to transform the data and correct the problem. A data steward in your company can run a report to review the data lineage and evaluate how the data is being used. Anyone in your company who is authorized to work on the project can review who profiled the data and who developed the job.

When you are developing a job in InfoSphere DataStage, you can use metadata that has been shared from multiple projects. You can import metadata from tables, views, and stored procedures to use in your job designs. Your jobs and metadata are automatically included in the metadata repository.

Collaborate with business analysts to jump-start job designs by using IBM InfoSphere FastTrack

A business analyst can create specifications for source-to-target mappings by using InfoSphere FastTrack. The mappings in the specifications can contain data value transformations that define how to build applications. The business analyst can then generate draft jobs from the specifications. As a developer, you can use those jobs as the starting point for your InfoSphere DataStage jobs.

Develop data rules by using IBM InfoSphere Information Analyzer

You can use data rules from InfoSphere Information Analyzer to improve data quality in your InfoSphere DataStage jobs. For example, a data analyst can use InfoSphere Information Analyzer to profile data sources to develop data quality rules. You can then use these data rules in your InfoSphere DataStage jobs. As a developer, you can also create rules directly in the job designer, and then share those rules so that business analysts can also use them in InfoSphere Information Analyzer.

Deploy jobs as services by using IBM InfoSphere Information Services Director

You can deploy jobs that function as services for service-oriented applications by using InfoSphere Information Services Director. For example, you can develop a job that uses the InfoSphere Information Services Director input and output stages. You can then publish the data integration logic as shared services that can be invoked via REST, SOAP, or other bindings, and reused across the enterprise. InfoSphere Information Services Director processes the service requests from your InfoSphere DataStage jobs.