Skip to main content
Solved

Can FME read in data from Oracle SQL Views?

  • October 7, 2024
  • 3 replies
  • 98 views

ed-progres
Contributor
Forum|alt.badge.img+1

Hello,

I was wondering if FME can read in  data from Oracle SQL Views?
If yes, great. How?

Best answer by david_r

Sure, you can either use a regular Oracle reader, FeatureReader or SQLExecutor/SQLCreator. They should behave like a regular table in FME.

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.

3 replies

david_r
Celebrity
  • Best Answer
  • October 7, 2024

Sure, you can either use a regular Oracle reader, FeatureReader or SQLExecutor/SQLCreator. They should behave like a regular table in FME.


hkingsbury
Celebrity
Forum|alt.badge.img+65
  • Celebrity
  • October 8, 2024

ed-progres
Contributor
Forum|alt.badge.img+1
  • Author
  • Contributor
  • October 8, 2024

Ugh… I see the SQL Views now! I must have glanced over them. 😅

Thanks all.