SQL Creator is working fine while parameters are provided in query itself. But its not working while using published parameters and embed connection parameters.
Page 1 / 1
I tested this in FME 2019.0 and can confirm the issue.
Seems that the published parameter in the SQL statement is not replaced by the value given for the published parameter.
Please submit this to www.safe.com/support as it seems a bug.
Published Parameters can sometimes not work as intended when used within a workspace and I find that it's good practice to first use a ParameterFetcher to put the parameter values into attributes.
In your case, as you're using a SQLCreator, you may need to replace that with a Creator > ParameterFetcher > SQLExecutor.
Published Parameters can sometimes not work as intended when used within a workspace and I find that it's good practice to first use a ParameterFetcher to put the parameter values into attributes.
In your case, as you're using a SQLCreator, you may need to replace that with a Creator > ParameterFetcher > SQLExecutor.
@nic_ran, I agree that would be a work around.
But I also feel like this should get the attention of Safe, as the transformer SQLCreator should be able to use published parameters.
@nic_ran, I agree that would be a work around.
But I also feel like this should get the attention of Safe, as the transformer SQLCreator should be able to use published parameters.
Absolutely agree! Published Parameters should just work everywhere and it seems to be not that uncommon for them not to work as intended. Whenever one of these issues is found it should definitely be brought to Safe's attention - but sometimes we need a workaround until the issue is resolved. :)