The Infor Communities is globally accessed system by
Infor and its customers, please do not post or upload
any content that could be deemed as sensitive, confidential or
subject to any data regulation requirements.
If you are unsure whether or not the content contains sensitive,
confidential or has any data regulation requirements,
please seek the advice of your internal security, legal, and compliance experts.
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
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…
It’s already working with me without fixes and After many trails as per my earlier comment
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 -
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
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?
same issue here, did you logt an incident? Can we have the number? thank you
You need to use the advance setting option and add the serverName/DBScheme and it will work fine
The incident number: 14465330 Infor ION (OS)