Change Database Connectors Data Source

dataflow-actian
#1

Hi all,

I have an issue with my actual project. Basically, my workflow contains several database connectors (Access DB) that are saved locally on my computers.

Well, in case I share my project with my colleagues, the database URL needs to be replaced one-by-one for each database connectors. Does anybody knows how to automate this process or have experience with this issue?

Thanks in advance for your support.

Alessandro

0 Likes

#2

Hi Alessandro,
I don’t know the actian nodes. But with the KNIME database connector nodes it would be enough to have on connector node and than connect this with all of the consequent nodes.

Otherwise, maybe you can control the configuration via Flow Variables. An Intro to Flow Variables you can find here: https://www.knime.com/knime-introductory-course/chapter7/section1/creation-and-usage-of-flow-variables
Cheers, Iris

0 Likes