Question

How to fefine MySql DB table as parameter

  • 2 December 2022
  • 0 replies
  • 0 views

Badge

Hello

I have to migrate a MySQL DB to a Postgres DB. The input DB contains about 200 different tables. Some fields of these tables contain url. Before migrating these urls, I would like to validate them. I have created a workspace which works perfectly fine using a sequence of transformers HTTPCaller transformer.

Before publishing it to FME Server, I would like to define some parameters amongst which the name of the table and the name of the field containing the url to check. Is there a way to do this? I have tried to use published paramaters which is ok for the fieldname but I cannot see how to do it on reader feature type. Thanks in advance for your help.

I would like to create a workspace using a MySQL DB containing about 200 tables as input to let user define the table (and the field)


0 replies

Be the first to reply!

Reply