Page 1 of 1

Question on Orchadmin usage

Posted: Tue Jul 01, 2014 11:08 am
by JPalatianos
Hi,
I have been asked if we can use the Orchadmin command from the client machine. We have a windows environment and the application teams typically ask us to dump DataSets to text files. We are looking to see if this is something they might be able to run on their own from their client machine.
Thanks - - John

Re: Question on Orchadmin usage

Posted: Wed Jul 09, 2014 12:53 am
by rohitagarwal15
Typically orchadmin command cannot be used from client machine but do you mean to say that your requirement is to convert datasets into text files? If this is case, then you can create a job to read dataset using dataset stage and write it to text file using sequential file stage.

Posted: Wed Jul 09, 2014 4:08 pm
by ray.wurlod
The orchadmin command requires use of the parallel engine binaries. But you should be able to invoke it remotely from your client machine, since both tiers are on Windows.

Posted: Fri Jul 11, 2014 3:35 am
by JPalatianos
Thank you both for your input. I ended up craeting a parametrized batch script on our servers with a DataStage wrapper that call this. Now both our developers and operations folks can use the dump option to view the contents of a Dataset.