Dynamic DB Account Use Cases

[kmiesse]

What are the use cases of dynamic database accounts if we can’t use pipeline parameters or fields in the input document to specify the host name, port number, database name, user name or password?

[shodge]

For a dynamic account, you can use pipeline parameters (though not fields in the document). When you create a dynamic account (take from MySQL):

You can toggle those fields with = into expressions and insert the name of the _pipelineParam that you want the field to be filled from.

Is that what you were looking for?

Thanks,

Shayne

[kmiesse]

Yes, thanks! Not sure what I was doing wrong when dynamic accounts first came out but I just tried the param again and it worked. That’s good enough!

[nganapathiraju]

What others have done is read these properties from a file or database and call the child pipelines passing these parameters through pipeline execute.

Hope that makes sense.

[kmiesse]

Yes, that’s what I plan on doing now that I know params can be used. Thanks.