I would like to purpose the ability to create connection files on the fly via Python.
This could be applied to ArcGIS Server, ODC, and SDE connections.(*.ags,*.odc,*.sde)
Currently in_memory acts like a temporary database but what would be nice is to be able to store Esri file formats in this location as well.
When scripting, a connection file must reside somewhere on disk and be accessible to the script. Through my proposal these connection files would no longer be needed and could be created on the fly within the script thereby making the script more portable and manageable over time.
Things like mapped drives, network shares, and servers are not always available and sometimes when a script is scheduled to run one of these devices might not be online, which would cause a script to fail. If we were able to build a connection file on the fly and store it in a temporary workspace like "in_memory" it would make the script easier to move from one location to another not to mention making it more error proof.
If "in_memory" cannot be used would it be possible to create another temporary workspace for Esri file formats or simply connections? Maybe instead of calling it "in_memory" it could be called something like "cached_connections". Then when using the Esri tools if we specify "cached_connections" in placed of something like "Database Connections" the logic behind the tool would know we are expecting this to only exist temporarily.
Thank you for your consideration.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.