Web Developer looking for information on remote SQL commands OurCzar

​[[{“value”:”Hi there,
I have a client I’m building a site for that uses an IBMi in their warehouses to manage inventory and other business related applications.
We’re looking for integration options on the site with the IBMi so that they don’t have to keep things like inventory and stock populated in multiple places.
My current thought is to have them setup TCP/IP network access to the IBMi database and create a database user who has read access to whatever tables are related to inventory. Then I can query and update the site’s data on regular cron intervals by fetching data from the IBMi using Db2 SQL.
Is this a good idea? Or should we take a different approach?
Thank you!
submitted by /u/OurCzar[link][comments]”}]] Read More 

Verified by MonsterInsights