DSXchange

Is it possible to import multiple table definitions using Orchestrate schema definitions?

I want to import a number of tables from Oracle using the Orchestrate import. Is it possible to somehow do this for several times in a row without having to click through all of them?

I know you can show table definitions from the command line using orchdbutil. Is there something like that, that you can use to import them in a project as well?

It's one at a time.

You could create a shell script that invoked orchdbutil over and over, but there's nothing "out of the box".

A shell script would be fine, but can I used orchdbutil to import a definition into the datastage project? I only know about "orchdbutil show etc" to show the definition from the command line.

Good point. The script would also need to construct an appropriate record structure and insert the record into DS_METADATA table. Not a task for the faint-hearted or even for the inexperienced!