IBM WebSphere DataStage ETL Tools

What versions of IBM WebSphere DataStage are supported in EPM?

EPM only supports IBM WebSphere DataStage version 8.1 server edition.

What if I am using an earlier version of DataStage either as part of a non-PeopleSoft installation or as part of EPM?

You must upgrade to IBM WebSphere DataStage version 8.1 server edition

What are the differences between ETL content for EPM release 9.1 and the previous EPM releases?

For 9.1 OWS staging tables contain all the fields of its related source tables.

What are the IBM WebSphere software components that are delivered with EPM?

EPM delivers IBM InfoSphere Information Server 8.1

What is QualityStage?

IBM WebSphere QualityStage provides a powerful framework for developing and deploying data investigation, standardization, enrichment, probabilistic matching and survivorship operations. For use in transactional, operational, or analytical applications, in batch and real-time, the same services are seamlessly deployed to facilitate data validation, cleansing or master data entity consolidation for your, locations and products.

For more information, please use the following link to the IBM WebSphere website: http://www-01.ibm.com/software/data/infosphere/qualitystage/

What is InfoSphere Information Analyzer?

For more information, please use the following link to the IBM WebSphere website: http://www-01.ibm.com/software/data/infosphere/information-analyzer/

What is IBM Metadata Workbench?

IBM Metadata Workbench provides Web-based exploration of information assets that are generated and used by IBM Information Server applications. IBM Metadata Workbench gives you out-of-the-box reporting on data movement, data lineage, and the impact of changes and dependencies. With the workbench, you can trace the data lineage of business intelligence reports to provide a basis for compliance with regulations such as Sarbanes-Oxley and Basel II. IBM Information Server components generate design time and runtime metadata, automatically storing that metadata in the IBM Information

What is Parallel Extender?

DataStage Parallel Extender (DS-PX) is a highly scalable parallel processing infrastructure package for the development and execution of data integration, data warehousing, business intelligence and analytical applications.

How does DataStage ensure application security?

Password and role based security can be effectively implemented in DataStage at a project level from the DataStage administrator.

How does DataStage ensure data security?

EPM accesses data on databases using the DRS stage. The user ID and password for accessing the databases are parameterized as environmental variables and the password parameter can be set as an encrypted field in the DataStage Administrator. This ensures data security by restricting the database access passwords.