DSXchange

Hi All,

I am not much aware about Java so here is my scenario:

1) We have a new project going and we need to suggest technology stack for the project and primarily the ETL tool.
2) We have Amazon S3 as our file storage system.
3) This is a Gaia cloud based project. We have Gaia Maria DB as our database.
4) There is back end Java code which should call our ETL process.

I am proposing DataStage as the ETL tool but now, below are my questions:
1) Can we call a DataStage job through Java code in cloud based environment? I read in one of the forum that yes, we can call it. But project must have "InfoSphere Information Services Director" installed. Is it the only way?
2) Can the Unix box connect with cloud based system?

Appreciate your help on this!

Thanks!
Vaibhav

In your shoes I would be opening a support case while waiting for additional input from the community...

You can always have Java open a command line call to the dsjob -run process to kick off the job.

You can have a WISD job set up so that Java does a REST api call to it.


You can connect DataStage with an external source of data. Just need to ensure that the method you use has the firewall ports open for you.

Adding to Paul's thoughts, using ISD is a super elegant way to do it.......but requires ISD, as you noted.......dsjob command line is a no brainer too, if your java folks are ok with calling out to the OS.

Ernie

For using dsjob command - can you please reply for my second concern i.e. 2) Can the Unix box connect with cloud based system? Some of my seniors said 'NO' but I just wanted you guys opinion on this.

Thanks!

My opinion is that you should ask your seniors to explain their point of view. Rules at your company are unknown to us.

Right... isn't the "cloud based system" just another UNIX box?