Customer Portal

Executing against multiple databases (outside Clover Server if possible)

Comments 4

  • Avatar
    Pedro Vazquez Rosario
    0
    Comment actions Permalink
    Hi vinny,

    Unfortunately, for the specific use case you are describing a CloverETL Server is the only way possible. The DbInputTable is designed to only accept one database names/hosts/username/password in the connection per graph execution. The only way to accomplish your use case would be to build a Jobflow that would create multiple graph executions per database by making use of Parameters (which unfortunately can't be changed during graph execution).
  • Avatar
    vinny_howard
    0
    Comment actions Permalink
    Thanks Pedro, I suspected that might be the case.
    cheers
    Vinny
  • Avatar
    vinny_howard
    0
    Comment actions Permalink
    Hi Pedro
    Just to clarify - if I were to use Clover Server, how would I set this up? Would I use a Jobflow, and have a FlatFileReader component to read the multiple rows of connection information from a CSV, and could that then be used to send the connection information into a Graph, to be picked up by the DBInputTable component? I'm playing around with the ExecuteGraph component but I can't see how to structure this to have one graph being run against multiple databases.
    thanks
    Vinny
  • Avatar
    Pedro Vazquez Rosario
    0
    Comment actions Permalink
    Hi Vinny,

    That is exactly how I would recommend setting up such a use case. I would create Parameters (ex. Username, Password, Host) in the main graph that contains the DBInputTable and map them using the ExecuteGraph Component. You will also need to use Dynamic Metadata to account for the changes in table structure. Please note that in the documentation that you need to specify a SQL query for the Dynamic Metadata to work properly, this value can be parameterize as well.

Please sign in to leave a comment.