Who's On?

	Membership:
	Latest: Steve G
	Past 24 Hours: 0
	Prev. 24 Hours: 0
	Overall: 5242

	People Online:
	Visitors: 94
	Members: 0
	Total: 94

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
Chesca	1042

Drill to 3rd Party Tables

2 Replies

0 Subscribed to this topic

17 Subscribed to this forum

Sort:

Author

Messages

Ari

Veteran Member

Posts: 49

4/27/2012 4:42 PM

We have a Process Flow that picks up GL extracts from a foreign system and creates importdb and GL165 jobs that posts the GL transactions in Lawson. I would like to be able to drill back into the foreign system from the posted transactions and/or from the GL165 print file. I can create all the necessary drill info(file defs, relations, indexes, .or file descriptions, etc.) for the tables in the foreign system. The Lawson app database and the foreign system database are SQL Server.

What I need to know is if there is a way in Lawson to "see" into a separate database for the Tables. There are ways within SQL Server to Replicate\Copy the foreign tables into the Lawson app database. I would prefer not to replicate the tables into the Lawson app database. I would rather have Lawson access these tables directly in the foreign system database.

I would appreciate any info from anyone who knows how to do this or if it is even possible.

John Henley

Posts: 3362

4/27/2012 6:25 PM

Short answer is yes. You can do it by putting the tables in a database space defined over a view.

Ari

Veteran Member

Posts: 49

4/27/2012 6:55 PM

Yes. Thank You. Since I am only reading the data a VIEW should work. I have also discovered that a synonym will work quite well.