Cognos Analytics

 View Only
  • 1.  DataDirect REST connector 11.1.7

    Posted Fri November 20, 2020 03:12 AM
    I want to connect to a REST endpoint that has  a page limit of 10000 records.I understand that I have to use pagination but I don't know how to implement this in my REST config file on the Cognos server.

    The DataDirect REST connector manual in the IBM topic describes the necessary parameters also with a sample but how do I translate the Pagination mechanism from my endpoint to the right values in the REST config file?

    It concerns the eindpoint below that uses the OData protocol:

    https://beta-odata4.cbs.nl/CBS/83878NED/Observations

    Is there more information available on how to do this?


    ------------------------------
    Bastiaan Krijgsman
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: DataDirect REST connector 11.1.7

    Posted Thu June 01, 2023 02:30 AM

    same issue is with me 



    ------------------------------
    IBM BD
    ------------------------------



  • 3.  RE: DataDirect REST connector 11.1.7

    Posted Thu June 01, 2023 09:37 AM

    To implement pagination for your REST endpoint in the Cognos server's REST configuration file, you need to specify the appropriate parameters in the configuration file. Here are the steps to do that:

    1. Open the REST configuration file on the Cognos server. The file is typically located in the installation directory of Cognos Analytics. The file name is rest-config.xml.

    2. Look for the section related to your specific REST connection. It may be defined as a <connection> element or within a <connections> element.

    3. Within the relevant <connection> element, add the following parameters for pagination:

      xml
    1. <parameter name="pagingEnabled">true</parameter> <parameter name="pageSize">10000</parameter>
      • The pagingEnabled parameter should be set to true to enable pagination.
      • The pageSize parameter specifies the number of records to retrieve per page. In your case, since the endpoint has a page limit of 10,000 records, set the pageSize to 10000.
    2. Save the changes to the rest-config.xml file.

    After making these changes, Cognos will retrieve data from the REST endpoint in a paginated manner, fetching records in chunks of the specified page size. This allows you to work within the limitations of your endpoint's pagination mechanism.

    Regarding more information on this topic, you can refer to the IBM DataDirect REST Connector documentation



    ------------------------------
    PANAGIOTIS ROUTSIS
    ------------------------------