DSXchange

Hi All,

Is DataStage out of the box, capable of creating basic graphs and visualizations without having to export its information to another tool (such as WebFOCUS)?

Thanks,

Bill

As far as I know, such a feature has never been part of DataStage; it does not claim to be a data visualization tool. Some of the IBM Cognos products are included as supporting programs but their use as restrictions. Check your license information document for details.

You might ask your IBM sales rep, if you have one, if graphing might be included in the upcoming release or not. I assume it will be version 11.7 but not sure.

The next version is 11.7. It's currently in beta testing. DataStage will never become a visualization tool, though.

With a wrapper stage, you could generate some json data.. and maybe pass that to a highchart piece of code... You could build your own... but ya... nothing by default other than the graphs provided with the DSODB dashboard.

We built some wrapped capability for a customer's data science group where DataStage feeds Python scripts that generate .png's for a portal. It avoided a lot of inefficient Python code for data transformation--as well as a lot of flat file dumps.

DataStage can also do interesting statistical metrics internally using the Aggregator stage.

Lamont

you can dump an excel file which has a lot of built-in charting technology.
but that is sort of backwards because excel can tap a database directly, reusing the same file with fresh data.

you can do some things like this with column analysis tool, not directly in datastage, and you can do some non-graphical stuff with quality stage.

but this is a round hole square peg problem. Its the wrong tool. You want something like cognos for this.