Charts & Graphics

mgsteiner · Post by **mgsteiner** » Fri Jan 02, 2015 3:28 am

Hello All,

I'm having a request to process some Data from CSV Files and create some charts as a result.
Is it any way to do the creation of such graphics in DataStage ?

Any hint would be great.
Thanks a lot in advance

ray.wurlod · Post by **ray.wurlod** » Fri Jan 02, 2015 4:49 am

In a word, NO.

DataStage is an ETL tool, it has no business in the presentation layer.

chulett · Post by **chulett** » Fri Jan 02, 2015 8:56 am

Right. Load the csv data into database tables and let your BI Team handle the graphics.

mgsteiner · Post by **mgsteiner** » Mon Jan 05, 2015 2:33 am

Yes I know we are doing ETL and not presentations. But I thought might be able to execute an API or so from a routine passing the data or using excel or so.

Have anybody done that before?

Anyway, thangs you guys for the answers.

chulett · Post by **chulett** » Mon Jan 05, 2015 8:39 am

I've never tried such a thing but I'm sure you do have some options along those lines, especially when running a Windows server. Perhaps via an Excel ODBC driver? And some clever macro work?

Perhaps someone here has been forced to do such a thing and will wander by.