SQL Creator is working fine while parameters are provided in query itself. But its not working while using published parameters and embed connection parameters.
+17- Contributor
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.
+16- Contributor
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.
+17- Contributor
nic_ran wrote:
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.
+16- Contributor
erik_jan wrote:
@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. :)
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.