5 Replies Latest reply on Oct 13, 2014 10:12 AM by 992405

    Tables in FDM

    992405

      Dear All,

       

      I wounder which database tables of FDQM  should I be accessing in order to fetch data relating to Mapping and Uploaded Data.

      Once I get to know this I can build some view tables based on these tables.

       

      I have tried connecting to FDQM Schema and able to see lot many tables, not sure which table to pick in order get the desired data.

      Please help me in this regard.

       

       

      Thanks & Regards.

        • 1. Re: Tables in FDM
          SSN01

          For mapping look for TDATAMAPSEG table

          for imported data look for TDATASEG & TDATASEG1,2....

          1 person found this helpful
          • 2. Re: Tables in FDM
            SH_INT

            To get the correct tDataSegx table for a particular location take a look at the PartSegmentKey field in the tPOVPartition table for the associated Location ID (PartitionKey). Also bear in mind that FDM already as pre-built views that provide this sort information already e.g. vData, vDataFact, vDataMap etc

            • 3. Re: Tables in FDM
              992405

              I have tired to check for these table like TDATAMAPSEG, vData, VDataFact but could not find them in the list of  available tables in the FDM Schema (Schema which we have used while configuring FDM) .

              And tables which we can see they don't have any data, although we can check & extract data from FDM application.

               

              Please let me know where I can check for these tables that would be of great help.

               

              Thanks.

              • 4. Re: Tables in FDM
                SH_INT

                Are you using FDM or FDMEE and if FDM which version of FDM are you using?
                What tables can you see in your schema as tDataMap should definitely be there regardless of product type/version.

                 

                Regards,

                SH

                • 5. Re: Tables in FDM
                  992405

                  Thank you SH & SSN01 for your valuable time and suggestions, I could find the tables.