Edit output connection string based on WorkflowName

Question

Dear Colleagues

For the past days i am trying to edit connection string in output tool using actions -without any progress.

I tried to use update value with formula similiar to :

if EndsWith('TEST',[Engine.WorkflowFileName]) then

'odbc:Driver={PostgreSQL UNICODE(x64)};Server=xxxx;Port=111;Database=db1;Uid=zzzz;Pwd=__EncPwd1__|||stg.TEST_VARIABLE'

else

'odbc:Driver={PostgreSQL UNICODE(x64)};Server=xxxx2;Port=222;Database=db2;Uid=zzzz;Pwd=__EncPwd1__|||stg.PROD_VARIABLE'

endif

Any ideas how this should be implemented ?

Thanks

afv2688 · Answer

Well forget about the second part, already modified it for you here 😋

Regards

dynamic_output_workflow.yxzp

afv2688 · Answer

Hello @RafalS ,

Here you go 🙂

The worklow creates the odbc connection and passes it to the control parameter (¿ input of the macro). Meanwhile the data enters through the normal input.

On the macro, the output value is then dynamically altered to fit your specifications. Here as you will see I have the parameters set up for an yxdb file, you would need just to enter any odbc connection on the settings to that the output format is changed. Would recommend using a staging or test odbc connection.

Once the fileformat has been changed there shouldn´t be any issues with the workflow

Regards

dynamic_output_workflow.yxzp

RafalS · Answer

can You attach sample WF how this might look like ?