I want to connect two databases (Oracle) in an SQLExecuter Transformer. This is to compare the changes. Currently I can add only one connection. Is it possible through User Parameter? Thanks in advance Harish

@harish​ Hi there, thanks for your question. Our SQLExecutor can only accept a single database connection at a time as the value for the Connection parameter. It sounds like you would need two separate SQLExecutors to bring in the two datasets to compare in a change detection workflow.

We do have a nice FME Community article on Change Detection, if you're interested. This article gives users a good overview of the various ways to employ a change detection workflow in a given workspace. We also have a more database-specific article on change detection, available here. I would recommend taking a look through these two articles to see if any of the recommendations therein will suit your needs.

Please let me know if you have further questions after having a look through those linked articles. If the above articles do not provide the guidance that you need for your workflow, please reply to this thread with further details on your specific workflow needs and your expected outcome(s).

@natalieatsafe​ thanks for the support.