Dynamic connections to Multiple database in single workflow

[ankur]

is there any way that let me make the DB connection dynamically to different databases without me specifying by going in the configuring section of DB CONNECTION. Basically the ask is to cater the use case, where I need to create a workflow, which is capable of exporting data from hadoop to various flavors of database like oracle,DB2,SQL server etc and perform operations like Insert,Update and Delete on them.The connection and credential should be passed on the fly, and connection can be made to various databases based on the configuration passed and accordingly operations can be performed.

[AlexanderFillbrunn]

Hi,
That’s possible, but the workflow will be quite large. You can pass in credentials with the Credentials Widget or Credentials Configuration node and enable different branches of the workflow using for example a CASE Switch Variable (Start) node or some other CASE Switch node. You will have to work with flow variables a lot for this.
Kind regards,
Alexander

[ipazin]

Hi there @ankur,

similar thing was discussed here so might give you some ideas:

Multiple DB Connections in one Meta-node output

Hello, I saw on this forum how to ease the use of a “master” DB connection by using a shared meta-node that encapsulate a DB-connection. The purpose was: if the password connection change (or even the RDBMS), it is easier to change only one point (the meta-node), so that everyone is up to date. But Id’ like to go further, if it is possible. I work with multiple Oracle schema, therefore, multiple connections, therefore, multiple meta-node. Is there a way to gather all the connections into one…

Note: Wrapped Metanodes are now Components. Quickform nodes are now either Widget either Configuration nodes. New database framework is actual.

Br,
Ivan