User Interface with Datastage

santosh · Post by **santosh** » Fri Feb 24, 2006 8:45 am

Guys
We have a data migration requirement where business wants to run the migration activity record by record for sometime(10 months daily). Then they will think if we can bulk transfer data.

So what we are looking is a solution where business gets screen to put customer number and whole ETL process runs to fetch data from DB2 and push it to MQseries. Is there any option where we can provide user interface to business.

regards,
Santosh

ArndW · Post by **ArndW** » Fri Feb 24, 2006 8:47 am

Santosh,

you can write the pretty GUI interface in whatever language/tool your organization likes to use. This can then execute the "dsjob" command with appropriate options and parameters to run the jobs.

kduke · Post by **kduke** » Fri Feb 24, 2006 7:21 pm

Why not use a named pipe?

vmcburney · Post by **vmcburney** » Fri Feb 24, 2006 8:14 pm

Seems like a perfect business case for use Real Time Integration. Currently it is an additional license fee, though in the Hawk release it may be free. It lets you turn any job into a web service. You can then write something that calls the web service and passes it the customer number.

kduke · Post by **kduke** » Sat Feb 25, 2006 8:10 pm

Exactly.