User Story:
As an FME user working with multiple databases on the same SQL Server instance, I want to be able to create a "SQL Server Instance Connection" in FME Options, similar to how I connect in SSMS. This would allow me to:
- Connect to the SQL Server instance without initially specifying a database.
- Dynamically switch between databases within my workspace using a transformer or parameter.
- Execute SQL statements against different databases without needing separate connections for each database.
This would greatly simplify my workflows, reduce connection management overhead, and provide more flexibility when working with multiple databases in FME.
Example Scenario:
I have a workspace that processes data from three different databases on the same SQL Server instance. Currently, I need to create three separate database connections in FME. With an "FME server connection," I could:
- Join between tables from different databases in the same query
This enhancement would make FME even more powerful and user-friendly for those who work with multiple databases on the same SQL Server instance. And the performance would take a leap.
Yes sure you have a better overview of debugging etc to force the records in the flow. But if performance is important then I believe this could be good
