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
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
+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
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.