Skip to main content
Question

Run a Workspace with external resources

  • March 4, 2016
  • 2 replies
  • 23 views
G
Forum|alt.badge.img

It seems I have a misconception on how FME should access external resources like databases and CSV files. We have a default setup meaning the FME services run as Local System. It doesn't appear there is a way to assign permissions at the workspace level. For instance, Workspace1 is run by domain account X, Workspace2 run by domain account Y, etc. Changing the services to run as a domain account wouldn't provide separate Workspace security to file shares and databases.

How should we provide access to external resources like a CSV on a network share or a database? Is the standard to copy files to the FME server and use SQL Authentication? Any thoughts would be appreciated.

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.

2 replies

jdh
Contributor
Forum|alt.badge.img+40
  • jdhContributor
  • Contributor
  • March 4, 2016

What I've done is have FME server running the service as a domain account with all necessary accesses, but have the different workspaces in separate repositories and set up different role profiles for each repository.

So even though FME server is using a super domain account, when the user X logs in, they only have access to workspaces in repository X.

On the desktop level, when accessing databases, I've created published parameters for the username/password.

erik_jan
Contributor
Forum|alt.badge.img+26
  • erik_janContributor
  • Contributor
  • March 4, 2016

For files you could use the Resources menu in FME server. You can store the required source files on FME server and avoid network communication by the FME server account.

Community Stats

32,207
Posts
122,305
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.