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...
Solved
Is there an easy way to copy database connection definitions from Desktop to Server?
+16- Contributor
Best answer by mark2catsafe
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
+5No, 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
+16- Contributor
mark2catsafe wrote:
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:
+16- Contributor
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
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.