Skip to main content
Solved

Dynamic Parameters for MySQL database reader

  • May 22, 2017
  • 1 reply
  • 12 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.

View original
Did this help you find an answer to your question?

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.

Reply


Helpful Members This Week

Community Stats

31,491
Posts
119,382
Replies
39,113
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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.