Skip to main content

I have a lot of named database connections defined in FME Desktop and would like to have them all available on FME Server. Is there an easy way to publish / copy named connections from Desktop to Server? I know that I can publish a workspace and the connections will get copied up but I don't want to have to create a dummy workspace with all of my possible DB connections just to get them published. I'm also hoping not to have to re-create all of the connections manually on Server...

No, and I investigated and there is no apparent intention to add this capability. You can export a list of connections from Workbench, but there is no ability to import them into Server.

I suggest that you add this as an "idea" in the knowledge centre so we can get other users to vote for it and see how popular it would be. Also contact our support team and register your need for this functionality. Tell them it's related to PR#64612

Regards

Mark


No, and I investigated and there is no apparent intention to add this capability. You can export a list of connections from Workbench, but there is no ability to import them into Server.

I suggest that you add this as an "idea" in the knowledge centre so we can get other users to vote for it and see how popular it would be. Also contact our support team and register your need for this functionality. Tell them it's related to PR#64612

Regards

Mark

Thanks Mark. I've added two new "Ideas" to the knowledge center around named connections:

Easy upload of named connections from Desktop to Server

Better support for named web connections in FME Server


For what it's worth, until Safe can implement a proper solution, my workaround for this issue is to create a dummy workspace that performs no actual translation but includes a set of disconnected HTTPCaller transformers, one for each named web connection that I need pushed to FME Server, and a set of SQLExecutors, one for each named database connection.

I can them upload this workspace to a dummy Repository and the named connections will get uploaded with it.


Reply