Hey guys, I see this thread is a couple of years old, but I have just encountered the same problem. We are integrating with a MS SQL installation if Infor M3 (formerly Lawson), and we cannot do a direct connection because of the collation issue. We can revert to linked tables or web services if necessary, but we would prefer to do read-only queries directly against the database.
Any help would be GREATLY appreciated.
Chris Bullock wrote:
Lawson/Infor M3 uses DB2 in the installations I worked with, the DB2 connector in the Forge let us read directly from it (see my post above for details).
We're using MS SQL. Hopefully we can find a solution.
For clarification, did you use the DB2 connector to connect to a Microsoft SQL database server?
No, but I am surprised to hear that you are using Lawson/Infor in a MS SQL environment, that's a bit unusual from what I understand.
I believe it is becoming more common with new installations. We purchased last (infor M3) year and are currently implementing the latest revision.
I'd love to learn more about how you guys are using OutSystems and Lawson. We are just starting our integration efforts, but are going to be using OS to do some pretty interesting things.
I am no longer using it, I used to work for Conigent who did an integration with it to build a dispatch system for technicians (among other things).