IBM DataStage Features

View ETL process data via reports and visualizations like charts and graphs.

Record ETL historical data for auditing and potential data correction needs.

Extract data from the designated source(s) like relational databases, JSON files, and XML files.

Cleanse and re-format extracted data to the needed target format.

Load reformatted data into target database, data warehouse, or other storage location.

Arrange ETL processes to occur automatically on needed time schedule (e.g., daily, weekly, monthly).

Capable of scaling processing power up or down based on ETL volume.

Creates a visual map of the data from the source to the target database for the user to see.

Transforms the data into the appropriate format before being transferred.

Moves the data from one database to another.

The software can process numerous type of data and formats.

The software can create the data map with no use of code. This is typically done via drag-and-drop.

Allows the data to be merged or executed before being mapped and transformed.

Offers built-in analytics functionality.

Offers reporting functionality.