Hey everyone,
Does anyone have experience working with on-prem databases like IBM Informix together with n8n?
I’m interested in whether it’s possible to integrate n8n with Informix databases, and if so, what would be the recommended approach. I’d also like to understand the security side of it a bit better — are there any best practices, limitations, or precautions that should be considered before setting this up in a production environment?
Thanks in advance for any advice or shared experiences!
hello Stefan! n8n has no built-in informix node so you have two practical paths : build a custom node using the informixdb npm package , or wrap your informix DB in a small rest API and hit it with n8n’s HTTP request node .For a quick production start, the REST API route is easiest. Just make sure Informix never faces the internet directly — keep it on a private network, use a least-privilege DB user, and always parameterize your queries to avoid SQL injection. Hope this clears things up, Stefan! 
If you have any follow-up questions — whether it’s help setting up the REST API, building the custom node, or anything else around the integration — feel free to drop them below, happy to help!
@Stefan_Zdravkovicc a quick check shows that IBM Informix offers REST API for accessing JSON collection in it. Hence you may use HTTP Request node to access the relevant REST APIs.
Hope this helps!
Check this out: IBM Documentation
Hi @Stefan_Zdravkovicc Welcome! If you go the Informix REST API route Wilson mentioned, put n8n on the same VLAN as the DB and front the API with mTLS, then store the token in a Header Auth credential so it never ends up inline in the workflow JSON. Also pin the DB user to read-only on just the schemas you need, Informix grants are per-table so it’s easy to over-permission.