Prev
Next
Forums Performance Management Smart Notification

LSN Connection to non-Lawson Database

 3 Replies
 0 Subscribed to this topic
 14 Subscribed to this forum
Sort:
Author
Messages
Nick
Veteran Member
Posts: 50
Veteran Member
8/4/2010 11:16 PM
    I was wondering if anyone had used LSN to pull information from a SQL database outside of Lawson?

    We are looking at creating some notifications when changes occur in our Time and Attendance system, and I have everything ready on that side. I'm unsure about how to set up the JDBC data source in LSN though. Is it possible to do?

    Thanks!
    Nick
    Matthew Nye
    Veteran Member
    Posts: 514
    Veteran Member
    8/5/2010 5:16 PM
      Nick,

      This is very easy. The only difficult part is getting the class reference. For each database platform it will be different and you will have to make sure you have all the right JAR files deployed to WAS. What platform are your non-lawson sources on?
      If any of my answers were helpful an endorsement on LinkedIn would be much appriciated! www.linkedin.com/pub/matthew-nye/1a/886/760/
      John Henley
      Posts: 3353
      8/13/2010 7:26 PM
        Absolutely. Just set up a different data source. =
        Thanks for using the LawsonGuru.com forums!
        John
        Nick
        Veteran Member
        Posts: 50
        Veteran Member
        8/19/2010 6:02 PM
          Thanks for the replies. I want to pull from a SQL 2005 database on a virtual Windows 2003 box. So it sounds like I will need to verify that the MS SQL 2005 driver has been deployed and then use that class along with the database connection information from our DB and T&A teams.