Has anyone been testing the ION Data flows / AnySQL Modeler in order to retrieve data from i5 (DB2) tables? Could you provide information, examples to retrieve data? Connection point, document flows, etc..
you can find some example here > ion_12.0.x_iontechconceag_cloud_en-us.pdf
Hey Mauricio,
AnySQL supports both standard DB2 and DB2/400 drivers for modeling and connectivity. The only DB2 driver not supported today is the DB2 z/OS driver. You can get a quick overview of AnySQL below -
[View:https://www.youtube.com/watch?v=WXxyzszZtIE:640:385]
Thank you.
We are still getting an error when trying to stat the anysql modeler. It cannon load the object and the error is that we have an invalid schema name *LIBL. This is the not schema name we identified in the connection point
I have the same Issue
please log a ticket with Infor support - they should be able to help you work through the correct configuration and checking for errors. Please also report back here after to help others
Greetings;
That sounds like an error where the default Library on the user you are using to connect is set to *LIBL. It's been years since I looked at iSeries library list deeply. I believe *LIBL looks for a library list to all the schemas a user can access in a certain order. Try defaulting it to the actual SCHEMA / LIBRARY you want to pull data from, and see if that resolves the error.
Does the connection information you're using in ION work in another non-IBM tool, like a generic SQL client?
Billy
You need to use the advance setting option and add the serverName/DBScheme and it will work fine