DSXchange

I've dug into topic a bit deeper and understood one thing: orchdbutil will not make the import :oops: It will only show me the schema definition. Now, one of the approaches I came across is to parse the output of orchdbutil and save it in .dsx format. Then it can be imported using dscmdimport. It is...

I've managed to get it running after putting dsenv at the beginning of the script. Thanks for that advice. One thing I need to figure out (I guess these are basics but I'm not strong with Linux) is why it does work only when I copy-paste the whole content of dsenv into my script. It doesn't work whe...

By "as in outside of your script" You mean to type "orchdbutil ..." directly to the Linux command line? If yes then this is exactly what I do.
Before I put it into any script I want have it going for a single table and I'm running it from the command line.

I see that I ain't got much choice. Ok, I can run script on the server directly. I started putting pieces together but now ran into something like (while trying to call orchdbutil): "(...) Could not find orchoracle on the library search path (...)". I do have path ...PXEngine/lib in LD_LIB...

I found information which, I think, would be enough for me to create tool for mass orchestrate import but one thing stands in my way: it seems like orchdbutil is only on the server side. Do You know if one can run it from the client side? I would like very much to avoid any remote calls because it w...

Could You give me a bit more detail? Of course I can get the list of tables with Java, that's not a problem, but do You know how to call orchestrate import from outside DataStage Designer (with appropriate set of parameters)?

Thank You for Your answer.

One time I heard about some Java API for DataStage and I hoped that this could be the way - to write some Java app that would loop through database tables and call orchestrate import.
Do You know if it is possible? Or maybe this Java API is not meant for such purpose?

Hello. The question is about DataStage Designer client. Is there any way to import many table definitions through orchestrate import (Import -> Table definitions -> Orchestrate schema import) "at once"? By "at once" or "bulk" I mean without importing every table separat...