Skip to main content
Solved

Reading data while data is being edited

  • May 21, 2019
  • 4 replies
  • 22 views
fmenco
Contributor
Forum|alt.badge.img+5

I have a general question about the way FME is able to read data.

Right now I have data stored on a fileserver, which I want to read into FME directly.

What would happen if someone else is accessing this data, either directly or through another application, while I was reading the data into FME?

Would this cause an error in FME? Or could simultaneously reading the data from the fileserver, while someone else is accessing or probably editing this data in another apllication have a negative effect on the performance in the other application?

Now, I just copy the files from the fileserver each time I want to read them all. However, I'm trying to find out if this is really neccesary or if I can just load them directly without causing other problems.

Best answer by redgeographics

If somebody else is reading at the same time I don't think it would be a problem, if they are also editing at the same time that might be an issue. Similarly if you're writing to a dataset and somebody else is reading it.

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.

4 replies

redgeographics
Celebrity
Forum|alt.badge.img+62
  • redgeographicsCelebrity
  • Celebrity
  • Best Answer
  • May 21, 2019

If somebody else is reading at the same time I don't think it would be a problem, if they are also editing at the same time that might be an issue. Similarly if you're writing to a dataset and somebody else is reading it.

FME rocks! \m/
fmenco
Contributor
Forum|alt.badge.img+5
  • fmencoContributor
  • Author
  • Contributor
  • May 21, 2019

If somebody else is reading at the same time I don't think it would be a problem, if they are also editing at the same time that might be an issue. Similarly if you're writing to a dataset and somebody else is reading it.

Thank you for your response. And how does that work when reading directly from a database, when somebody is editing or accessing the data through an application? Would that also result in possible errors?

redgeographics
Celebrity
Forum|alt.badge.img+62

Thank you for your response. And how does that work when reading directly from a database, when somebody is editing or accessing the data through an application? Would that also result in possible errors?

In that case the database is handling the transactions, you wouldn't get any errors but you might get data that's partly old, partly new.

FME rocks! \m/
fmenco
Contributor
Forum|alt.badge.img+5
  • fmencoContributor
  • Author
  • Contributor
  • May 21, 2019

In that case the database is handling the transactions, you wouldn't get any errors but you might get data that's partly old, partly new.

Thank you..!

Community Stats

32,212
Posts
122,316
Replies
39,898
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.