Skip to main content
Solved

Dynamic Parameters for MySQL database reader

  • May 22, 2017
  • 1 reply
  • 22 views
jeroen
Contributor
Forum|alt.badge.img+15

I'm looking for a solution to make my workspace a lot more dynamic for my use. I'm working on a easy to set up workbench where MariaDB (MySQL-compatible) Spatial reader and writer are connected with an AttributeManager in between.

I would like to add my fmw to the server with some parameters that can set the Table list as prompt input data. The SourceDataset_MYSQL is already a prompted parameter but i cannot find a way to set the Table list/table name as a parameter. Any idea how to set this?

http://docs.safe.com/fme/2017.0/html/FME_Desktop_Documentation/FME_ReadersWriters/mysql/MYSQL_reader.htm

Constraints -> Table List

Best answer by markatsafe

@JeronR - All readers have a Feature Types to Read parameter that you can publish. For a database reader, this will give you a list of tables. On FME Desktop, this list will be dynamic and give you the current list of tables. On FME Server, it behaves slightly differently, and it is a static list. But you can select any table(s) from that list. More on Feature Types to Read here.

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.

1 reply

M
Forum|alt.badge.img+2
  • markatsafe
  • Best Answer
  • May 29, 2017

@JeronR - All readers have a Feature Types to Read parameter that you can publish. For a database reader, this will give you a list of tables. On FME Desktop, this list will be dynamic and give you the current list of tables. On FME Server, it behaves slightly differently, and it is a static list. But you can select any table(s) from that list. More on Feature Types to Read here.

Community Stats

32,154
Posts
122,047
Replies
39,812
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.