Who's On?

	Membership:
	Latest: Lauren Beeker
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5222

	People Online:
	Visitors: 88
	Members: 0
	Total: 88

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

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

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

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?

John Henley

Posts: 3365

New Poster

Engaged Reader

Avid Reader

8/13/2010 7:26 PM

Absolutely. Just set up a different data source. =

Nick

Veteran Member

Posts: 50

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.