• Search Forums
    Advanced Search
Prev
Next
Forums Performance Management Lawson Business Intelligence/Reporting/Crystal

DME substitute- RW?

 2 Replies
 0 Subscribed to this topic
 23 Subscribed to this forum
Sort:
Author
Messages
Nabil
Veteran Member
Posts: 61
Veteran Member
New Poster
New Poster
Congrats on posting!
4/8/2011 6:18 PM
Hello Gurus,

So we know very well that in order to create custom crystal report that use user level security, OleDB is an option. We also know that OleDb is really really sllllowwwww

So, are there any other alternatives to this painful reality? Can there be OleDb reports written with a language other then DME? How about SQLOLEDB?

Thanks much,
John Henley
Posts: 3364
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
4/8/2011 6:37 PM
squardius, you can definitely use native providers. See this article for comparison:
https://www.lawsonguru.co...OLE-DB-Provider.aspx
Thanks for using the LawsonGuru.com forums!
John
mikeP
Veteran Member
Posts: 151
Veteran Member
4/8/2011 6:44 PM
For us, Lawson proper is hosted on an iSeries. We write most of our CRs using the iSeries ODBC driver, which is very fast.  We also use the native MS SQL server driver to write CRs to report from LBP, which is on SQL server.  That's not as fast, which is more a function of the wimpy SQL server box.

We implement security via LBI custom groups, but it's also possible to grant report access in LBI via security group defined in the Lawson Resource Mgmt. Administrator.