Workflow Oracle components
Updated: 21 May 2010 | 4 comments
Hi all,
I need to find a workflow component to connect to an Oracle DB and launch some export/import/something else commands.
Do you know a component to do that?
Thanks in advance
discussion Filed Under:
Comments
A generated SQL script
A generated SQL script component may be right up your alley (New Integration project - Query/Script generator). Specify a valid Oracle connection string, and you should be off.
Thank you reecardo,
Thank you reecardo, unfortunately the 'Query/script' generator is not present in the generator list i have from 'Create integration library' button on WFD7: is there any way to get back all the generators that were available in WFD6?
Thanks in advance
At the basic licensing level,
At the basic licensing level, you just have the Symantec generators available to you (ASDK, Task, Report and Resource for NS6 and NS7). A higher license level unlocks the remainder of the generators.
You also might want to look at the SQL library (not loaded by default into your project) and play with the Execute Non Query component. Though these components have been depracated by the generators, they may still have what you need.
One thing to note...
You have to have the Oracle Drivers on your computer and on the server in order for this component to work!
Rob
Would you like to reply?
Login or Register to post your comment.