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
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 -
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
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
Hi,
The incident number: 14465330 Infor ION (OS)