I’m attempting to pull live customer order information from an existing ERP system (QAD MFG).
The backing data store for their system is a Progress OpenEdge Database.
I’ve successfully installed the OpenEdge JDBC driver in Ignition, can query successfully, and can see all tables/columns in Ignitions Query Browser Tool.
The problem is, I can’t seem to query the right data. The entity model used by QAD is complex, and after referencing their official technical document, the queries I do write seem to always time out if they work at all.
Checking the gateway logs reveals the queries take 2-5 minutes, which is enough time for my designer to have a socket-timeout exception and drop the gateway connection entirely.
Can I configure the gateway to wait longer for queries to return, or do I have other options here?
Any help or advice would be greatly appreciated.