+48Has anyone got any tried and tested methods for testing ArcSDE connections that are stored in FME Flow, en masse rather than one by one.
I thought i could use an SQL Executor but it appears FME doesn’t handle the error messages when they’ve come from a failed SDE connection so the workspace terminates if there is one bad connection.
You could perhaps test the connections using e.g. arcpy.Describe(my_sde_connection_file) and loop over them in a PythonCaller. That way you can handle any errors yourself with try/except.
The tricky part is knowing the the names of the SDE connections, since the FMENamedConnectionManager class lacks any mechanism to discover available connections. So you’ll basically have to provide the list of SDE connections yourself.
