DB2 iseries (AS400 DB)

[Chris_Doudet]

hi,
is there a plan to integrate iseries database ?

connect-db2

thanks

[RicardoE105]

I just changed the post to a feature request. Remember to upvote it.

The more votes, the more chances of being developed.

[georgejeffcock]

@Chris_Doudet how weird

starting to play with this today and thought who am i fooling, who wants IBM i (as400) connectivity!

connect-db2 will not help you but this would be great https://www.npmjs.com/package/node-jt400

I have contacted node-jt400 owners today!

cant promise anything asI know IBM i very well and JTOpen JT400 but not nodejs

[georgejeffcock]

by the way as400, iseries changed its name 14 years ago to IBM i

[georgejeffcock]

@Chris_Doudet did you have any particuar use case? I’m getting data from an AS400 now…

[Chris_Doudet]

Waoow @georgejeffcock
great job,
Query execution is the only thing i need for now.
thanks

[georgejeffcock]

@Chris_Doudet well I have that working…i currently dont plan to merge with master(fyi @jan ) as there is a dependency to https://www.npmjs.com/package/node-jt400 and guidelines at least for http (this is tcp) recommend no dependencies for good reason…but it is not practical to rewrite node-jt400 into n8n and have therefore wrappered/referenced this well known IBM i / AS400 open source project.

maybe I can create a branch with no intention of merging and you can have a play…

FYI I am doing this for fun and community, I use pub400.com so trivial data size and content

[georgejeffcock]

this seems to good fit:

Create own custom n8n-nodes-module

If you want to create multiple custom nodes which are either:

• Only for yourself/your company
• Are only useful for a small number of people
• Require many or large dependencies

[Chris_Doudet]

Hi @georgejeffcock ,
If i understand i need to create my own nodes-modules.
I am not able to do this, too complicated for me.
Why not create a store ? May be with paid services for installation.

thank you again

[georgejeffcock]

I have done the creation.

you can use this GitHub - GeorgeJeffcock/n8n: Free and open fair-code licensed node based Workflow Automation Tool. Easily automate tasks across different services.

I can zoom to show you if you want

[jan]

@Chris_Doudet Here an previous answer I gave about a paid node store:

Integration store $$$

Yes, I also thought shortly about something like that but there are very many problems. Here are a few examples: It would take considerable resources to create and operate something like that. Resources we currently do not have. We have a project that everybody can currently run for free and we want to keep it that way. If suddenly most integrations would get charged for that would not be the case anymore. We want to keep the quality of the integrations high and we want to make sure that they…

Generally do we want to make it easier in the future to load external nodes in n8n. Sadly do not have an ETA for that yet.