This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I can run this SQL script in an application like dBeaver but don't know how to set it up in Alteryx as an SQL query within an "Input Data" tool. As you can see below, the workflow returns an error. Is there a method that I can use to read a DB table that would work the same way as dirty read?
@flipperdm I don't think that Informix is supported by Alteryx as of now. You can check this link for the supported data sources. https://help.alteryx.com/11.7/DataSources/SupportedDataSources.htm. You can use the ODBC connections to try to connect with Alteryx, but you might see some issues with it. Also, I would recommend creating your SQL query inside the SQL Editor or Visual Query Builder instead of copying/pasting from a source. Sometimes, things do get lost in translation and causes an error.
However, you can try creating custom database connections located in .\Alteryx\bin\RuntimeData\ODBC\Customizable ODBC Driver Connections.pdf. Note, these were originally meant for partners to develop custom connectors for customers, not for customers themselves. If you were to try this, you would be completely on your own supporting it.
@DiganP Thanks for responding. I have been running several workflows for Informix using the ODBC connections and it seems to work well, just this one. I have found a solution though which I can share for anyone that runs into record lock issues.