Lawson security model: CE 9, Oracle DB

[synapsevampire]

Please share any information regarding implementing Lawson 8.02 environment and 8.03 application, and CE 9.

The overall model is of interest with regards to OLE DB security, how the data is extracted from th Oracle DB (extraction layer?). How is security implemented?

Then what sorts of safe things can be done with respect to modifying the CSP.

I am intending to allow for both Lawson security, and for people using direct NT Authentication against the same CE server. I assume that I'm best served to have 2 versions of ePortfolio CSP pages?

All information is appreciated, and advice from seasoned Lawson<->CE Administrators/coders would be great.

Thanks,

-k

 

[jbullman]

Did you ever get what you wanted? This is my, and my company's, area of expertise (Lawson and Crystal). Because of that, however, I'm somewhat restricted in the information I can give you. But let me know where you stand and I can see what I can do.

Judith

Judith Ullman

http://www.innovativeinformation.com

Metro New York Crystal Decisions Training and Consulting Partner

 

[synapsevampire]

Well I've delved a bit into it and have a fairly good grasp of the integration.

I'm particularly annoyed by the horrendous performance of the Lawson Query Builder and OLE DB.

One report runs < 1 second when I use Native Oarcle connection, 10 minutes by using the Lawson security model (OLE DB and the Query Builder).

If there's anyway to observe the Lawson security model and provide the report from within the Lawson Portal WITHOUT using the Lawson Query Builder I'd be grateful to read anything about that.

Thanks for your post, Judith.

-k

 

[MottMacMan]

We have CE9 with Lawson, however we connect to the oracle database server using native oracle drivers for reporting purposes not Lawson OLEDB drivers.

We synchonize our CE users with Lawson via our own in house tool. When the users change their Lawson password the CE one is automaticly changed by a listener app via the CE SDK.

The CE groups have been mapped to match Lawson security model classes with similar object rights.

 

[synapsevampire]

This sounds VERY intriguing. Can you elaborate on your methodology?

We are currently in the process of doing something similar, however our security will be limited to the department level, are you doing this with row level security?

I use Native connectivity for reports outside of the portal (most are), but some need to observe the security model.

-k

 

[katdan113]

Crystal 9.0 and or 10.0, Lawson software, oracle db.
want all lines from a particular standing order(stpoline). I know this is 2451 records. Do outer left join to itemmast and still have 2451 records. Do left outer join again from stpoline to povenitem and lose 27 records because they do not exist in poitemven. All joins are on item which is a field in all 3 tables. Why is the left outer join not working. It should give me all 2451 records in the left table but as soon at it hits the table that do not contain 27 matching items I lose the records from the initial table. ODBC connection to oracle 9i.
All help appreciated.

 

[mdwyer]

Can you provide the SQL statement?

 

[katdan113]

SELECT "STPOLINE"."COMPANY", "STPOLINE"."ORDER_NAME", "STPOLINE"."ITEM", "STPOLINE"."LINE_NBR", "STPOLINE"."ENT_BUY_UOM", "STPOLINE"."ENT_UNIT_CST", "ITEMMAST"."ITEM", "ITEMMAST"."DESCRIPTION", "ITEMMAST"."DESCRIPTION2", "ITEMMAST"."MANUF_CODE", "ITEMMAST"."MANUF_DIVISION", "ITEMMAST"."MANUF_NBR", "POITEMVEN"."COMPANY", "POITEMVEN"."ITEM", "POITEMVEN"."VENDOR", "POITEMVEN"."VBUY_UOM", "POITEMVEN"."VEN_ITEM"
FROM "LAWPROD"."STPOLINE" "STPOLINE", "LAWPROD"."POITEMVEN" "POITEMVEN", "LAWPROD"."ITEMMAST" "ITEMMAST"
WHERE ("STPOLINE"."ITEM"="POITEMVEN"."ITEM" (+)) AND ("STPOLINE"."ITEM"="ITEMMAST"."ITEM" (+)) AND "STPOLINE"."COMPANY"=99 AND "STPOLINE"."ORDER_NAME"='AH03VL99' AND "POITEMVEN"."COMPANY"=99 AND "POITEMVEN"."VENDOR"='8005069'

 

[katdan113]

SELECT "STPOLINE"."COMPANY", "STPOLINE"."ORDER_NAME", "STPOLINE"."ITEM", "STPOLINE"."LINE_NBR", "STPOLINE"."ENT_BUY_UOM", "STPOLINE"."ENT_UNIT_CST", "ITEMMAST"."ITEM", "ITEMMAST"."DESCRIPTION", "ITEMMAST"."DESCRIPTION2", "ITEMMAST"."MANUF_CODE", "ITEMMAST"."MANUF_DIVISION", "ITEMMAST"."MANUF_NBR", "POITEMVEN"."COMPANY", "POITEMVEN"."ITEM", "POITEMVEN"."VENDOR", "POITEMVEN"."VBUY_UOM", "POITEMVEN"."VEN_ITEM"
FROM "LAWPROD"."STPOLINE" "STPOLINE", "LAWPROD"."POITEMVEN" "POITEMVEN", "LAWPROD"."ITEMMAST" "ITEMMAST"
WHERE ("STPOLINE"."ITEM"="POITEMVEN"."ITEM" (+)) AND ("STPOLINE"."ITEM"="ITEMMAST"."ITEM" (+)) AND "STPOLINE"."COMPANY"=99 AND "STPOLINE"."ORDER_NAME"='AH03VL99' AND "POITEMVEN"."COMPANY"=99 AND "POITEMVEN"."VENDOR"='8005069'

 

[synapsevampire]

I'd guess that your difficulty is caused by the use of:

"POITEMVEN"."COMPANY"=99

You're exlicitly stating only these rows, so that's what you'll get.

You can try changing it to:

isnull("POITEMVEN"."COMPANY")
or
"POITEMVEN"."COMPANY"=99

Depending upon the data, you may end up with less rows though.

-k

 

[synapsevampire]

BTW, you should start a new post, this has little to do with the original intent, and you'll get more results.

-k