System administration
      Back to home
      2. System administration

      Using the Analytics Odata API

      The Analytics API uses the Odata protocol to support integration of register data with most business intelligence tools.

      The Analytics API must be configured in the LogiqcQMS platform by Logiqc engineers before the System Administrator can go ahead and set up the data feed.  This article explains how to set up the data feed once the feature has been configured.

      If you would like to know more about this feature click here to register your interest.

      Setup instructions

      Setting up the Odata user account requires administrative permissions. Learn more

        Step 1:  Once Logiqc has released the feature, log in to your platform, enter Admin mode and navigate to the Users menu.

        Change the password of the  Odata Reader user account.

        Learn more here: Updating your password

        Step 2:  In your BI tool (eg.eg. Power BI, Excel, Tableau), 'get data' using the odata feed option establish the connection to your platform. Enter the following address: https://<YourLogiqcQMSURL>/odata

        Step 3: Use ‘basic authentication’ method to connect to the LogiqcQMS Odata feed with the following credentials:

        • Username = odata
        • The password you created in Step 1.

        Note: A maximum of 3 unique connections are permitted.

        Once connected you will have access to multiple register and related table feeds as defined in the attached data dictionary.

        Click on the image below to download the file to your local computer.

        doc

        doc_764 v8 Last updated 17/12/2023