Prev
Next
Forums Lawson Business Intelligence/Reporting/Crystal

DME substitute- RW?

Sort:
You are not authorized to post a reply.
Author
Messages
Nabil
Veteran Member
Posts: 61
Veteran Member
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
    Senior Member
    Posts: 3348
    Senior Member
    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.
        You are not authorized to post a reply.