DSXchange

Hi

Anyone have a case using R Functions (https://www.r-project.org/) in DataStage.

Thanks for any idea!!!

I cannot think of any useful application for R in an ETL environment.

Well... you did ask for a "case", why one would use it rather than how one would use it, hence the answer that you got. As to your options - assuming both are equally valid methods - I'd suggest picking the path your site is best equipped to handle from a development and support standpoint.

Other than that, I've got nothing.

Is there anything in R that you need that isn't also available in C++ or Java?

As Ray and Craig note, the "why" is important here.....

Technically speaking, if you know how to invoke R from Java, then it should be very straightforward. Exactly "why" you would do it is another question, but once the Engine gives control to your java class, you can do just about "whatever you want".... In theory, there might be limits on what can be done from inside the jvm that DataStage starts along with your Job, but most things can be performed.

Ernie