Forum Discussion
Gateway is missing in Dataflow
did you by any chance change the spelling of your dsn ? Since about June 2020 the gateway connection definitions are case sensitive. If you have multiple data sources with the same connection but different case the result will be "no gateway available" and the available gateway being shown but not selectable, with duplicate connections.
To mitigate you need to correct the spelling discrepancy and then re-publish everything.
did you by any chance change the spelling of your dsn ? Since about June 2020 the gateway connection definitions are case sensitive. If you have multiple data sources with the same connection but different case the result will be "no gateway available" and the available gateway being shown but not selectable, with duplicate connections.
To mitigate you need to correct the spelling discrepancy and then re-publish everything.
Hi lbendlin , I didn't but this is exactly the issue as you described. The connection in my data model is in uppercase but there is a lowercase connection string appearing in my datasources under gateway connection tab. I can't figure how this is happening as I have no lower case connection strings anywhere in the model or in the gateway dsn. It could well be that I'll have to recreate to dataflow to resolve. Thank you for getting back to me. 🙂