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
Veteran Member
    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: 3353
      Short answer is yes. You can do it by putting the tables in a database space defined over a view.
      Thanks for using the LawsonGuru.com forums!
      John
      Ari
      Veteran Member
      Posts: 49
      Veteran Member
        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.