PBizme wrote:My idea was to query my Oracle DB to get a list of the tables and then loop through that list somehow and execute the subgraph each time.
In simple terms, you can imagine subgraph as a wrapper for your components. Therefore, you'd get the same result as if you'd have connected contents of that subgraph to the dataflow. Once subgraph is initialized, it CANNOT change its configuration.
PBizme wrote:I am very new to CloverETL so I was trying to get it working without the looping first, but I thought I needed to be able to set a parameter on the subgraph in order to reference it during various DB Input and DB Output operations.
You're right. You can set subgraph's parameter different with each execution. This way though, you'll be able to do just one table at a time. Not the whole bunch of them at once. Not even loop (which I recommend not to use in graphs at all) would help in this case I'm afraid.
PBizme wrote:Do you think that there is a way to accomplish what I'm trying to do dynamically using Clover ETL?
In fact, yes it is. Quite easily, Corporate server is a must to do that. Corporate server provides jobflows, those can be used to execute several graphs with different configurations - basically exactly the feature you're trying to use with subgraphs. The final setup could look like this (picture with rounded-cornered components is jobflow; yellow component is ExecuteGraph):