expose lawson db
Last Post 09/15/2010 06:09 PM by Raj. 3 Replies.
    Printer Friendly
    •  
    •  
    •  
    •  
    •  
    Sort:
    PrevPrevNextNext
    You are not authorized to post a reply.
    AuthorMessages
    RajUser is Offline
    Private
    Private
    New Member
    (4 points)
    New Member
    Posts:2
    Raj

    Send Message: Send Private Message

    --
    09/10/2010 03:57 PM
      HI I'm new to Lawson systems.All i want to do is to bring in Accounts payable tables into my Datawarehouse. wondering how easy or hard lawson exposes its db?
      Any thoughts?
      thanks in advance
      Raj
      Chris MartinUser is Offline
      Private
      Private
      Veteran Member
      (678 points)
      Veteran Member
      Posts:228
      Chris Martin

      Send Message: Send Private Message

      --
      09/10/2010 05:09 PM
        Establish connectivity with the Lawson database (Oracle, SQL, or DB2) by installing the relevant db client. What database does Lawson reside on?
        Jimmy ChiuUser is Offline
        Private
        Private
        Veteran Member
        (1518 points)
        Veteran Member
        Posts:516
        Jimmy Chiu

        Send Message: Send Private Message

        --
        09/13/2010 09:32 AM
          John posted a great tip on how to id which table and column.

          www.lawsonguru.com/portals/0/docs/addins/Excel Addins-Translating Form Fields to Table Field Names.pdf

          I am sure you will find it useful.
          RajUser is Offline
          Private
          Private
          New Member
          (4 points)
          New Member
          Posts:2
          Raj

          Send Message: Send Private Message

          --
          09/15/2010 06:09 PM
            Thanks Chris..its on Oracle 10g
            You are not authorized to post a reply.

            Forums >Integration / Customization >S3 Interfaces/Conversion

            New TopicsMinimize
            S3 Systems Administration
            ESS/MSS audit log
            02/10/2012 05:13 PM
            Does anyone know how to capture ESS activities? Fo
            Lawson S3 HR/Payroll/Benefits
            Pay Class Not Working
            02/09/2012 08:46 PM
            We have set up a pay class tied to a specific pay
            S3 Systems Administration
            GEN Database Fields
            02/09/2012 02:13 PM
            I was wondering if anyone knew what lawson used th
            Lawson S3 HR/Payroll/Benefits
            Headcount
            02/09/2012 12:32 PM
            We are currently looking into the possibility of a
            Lawson S3 Supply Chain
            Multiple UOM Setup
            02/09/2012 10:01 AM
            Ok so here is our issue, the warehouse orders and
            Lawson ProcessFlow
            Enterprise web forms with processflow?
            02/09/2012 08:21 AM
            I'm being asked about enterprise web forms for a s
            Lawson ProcessFlow
            15 Variable limit for WFWK.1
            02/08/2012 11:42 PM
            Have a custom design studio form that is consolida
            Lawson Business Intelligence/Reporting/Crystal
            Crystal/Xcelsius and LBI Bursting
            02/08/2012 12:06 PM
            We are currently working on rolling out LBI for ou
            S3 Application Upgrades
            Upgrade to 9.0.1 Workplan from 8.0.3 and 9.0.0
            02/08/2012 11:05 AM
            Does anyone have a workplan that you are willing t
            Lawson Business Intelligence/Reporting/Crystal
            Is there a way to get the user_id name to print on a Crystal rpt?
            02/08/2012 10:50 AM
            I'm looking to create a report that would show the