App Connect

Hello,

We need to configure multiple integration nodes in the same on-prem server (linux), and requires to setup a ODBC connection for each integration nodes, but with different databases. Is that possible to configure the Integration nodes to run under the same service id, but with a reference from separate ODBCINI for each integration node ?

Regards,

Not sure, if my writing helps you.

In your context, what do you mean with Service ID?

You can work with plenty of ODBC Connections in the same odbcs.ini file.

ODBCINI is an environment variable it can point only to one odbc.ini file.

If you run the Nodes in containers, each Node could have its own ODBCINI / odbc.ini file

Hello,

We need to configure multiple integration nodes in the same on-prem server (linux), and requires to setup a ODBC connection for each integration nodes, but with different databases. Is that possible to configure the Integration nodes to run under the same service id, but with a reference from separate ODBCINI for each integration node ?

Regards,

Thank you for the response.

Service ID --> the ID that runs the Integration node.

in the existing setup, the odbc.ini is configured at node level for each integration nodes and have a dedicated id to run each nodes. ODBCINI set for each user to refer the odbc.ini. 

If I understand correctly, it shouldn't be an issue to have a same odbc.ini for all the integration nodes which can run under the same id. Correct me if I'm wrong.

Not sure, if my writing helps you.

In your context, what do you mean with Service ID?

You can work with plenty of ODBC Connections in the same odbcs.ini file.

ODBCINI is an environment variable it can point only to one odbc.ini file.

If you run the Nodes in containers, each Node could have its own ODBCINI / odbc.ini file

Hello,

We need to configure multiple integration nodes in the same on-prem server (linux), and requires to setup a ODBC connection for each integration nodes, but with different databases. Is that possible to configure the Integration nodes to run under the same service id, but with a reference from separate ODBCINI for each integration node ?

Regards,

Yes, you can run them all with the same user id with the same odbc.ini file

.

Thank you for the response.

Service ID --> the ID that runs the Integration node.

in the existing setup, the odbc.ini is configured at node level for each integration nodes and have a dedicated id to run each nodes. ODBCINI set for each user to refer the odbc.ini. 

If I understand correctly, it shouldn't be an issue to have a same odbc.ini for all the integration nodes which can run under the same id. Correct me if I'm wrong.

Not sure, if my writing helps you.

In your context, what do you mean with Service ID?

You can work with plenty of ODBC Connections in the same odbcs.ini file.

ODBCINI is an environment variable it can point only to one odbc.ini file.

If you run the Nodes in containers, each Node could have its own ODBCINI / odbc.ini file

Hello,

We need to configure multiple integration nodes in the same on-prem server (linux), and requires to setup a ODBC connection for each integration nodes, but with different databases. Is that possible to configure the Integration nodes to run under the same service id, but with a reference from separate ODBCINI for each integration node ?

Regards,