Skip to Main Content
IBM Sterling

This portal is to open public enhancement requests for IBM Sterling products and services. To view all of your ideas submitted to IBM, create and manage groups of Ideas, or create an idea explicitly set to be either visible by all (public) or visible only to you and IBM (private), use the IBM Unified Ideas Portal (

Shape the future of IBM!

We invite you to shape the future of IBM, including product roadmaps, by submitting ideas that matter to you the most. Here's how it works:

Search existing ideas

Start by searching and reviewing ideas and requests to enhance a product or service. Take a look at ideas others have posted, and add a comment, vote, or subscribe to updates on them if they matter to you. If you can't find what you are looking for,

Post your ideas
  1. Post an idea.

  2. Get feedback from the IBM team and other customers to refine your idea.

  3. Follow the idea through the IBM Ideas process.

Specific links you will want to bookmark for future use

Welcome to the IBM Ideas Portal ( - Use this site to find out additional information and details about the IBM Ideas process and statuses.

IBM Unified Ideas Portal ( - Use this site to view all of your ideas, create new ideas for any IBM product, or search for ideas across all of IBM. - Use this email to suggest enhancements to the Ideas process or request help from IBM for submitting your Ideas.

Status Functionality already exists
Created by Guest
Created on Jan 12, 2023

Cognos reports extract through standard integration mechanisms

We have an inhouse alerting, monitoring and reporting capability that is dependent on receiving data from various applications. We are writing custom reports in Cognos reporting suite to access the data that is needed to deliver our requirements. However, there is no standard integration mechanism available to extract or interface these reports from SaaS platform.

The available options are to
1. Schedule and send the reports via email - attachment / link.

2. Save to the report to a local machine.

These options are not efficient interfacing mechanism due to the limitations they have. Our organisation has invested heavily in inhouse alerting, monitoring and reporting capabilities so having access to the data at right time is mandatory. These capabilities are helping us to identify and resolve issues proactively. In order to achieve this, we would like to receive the reports through standard integration patterns/mechanisms.

What is your industry? Retail
How will this idea be used?

This idea will enable us to plug the gap that will be created by moving the OMS application from on-prem to SaaS model. This is support our Operations & support teams to identify, manage and resolve issues proactively.

  • Guest
    Feb 14, 2023

    Hello Sampson, Thank you for the details. We have explored this option already and there are limitations in using the data extract agent:

    1. My understanding is that this tool allows us to extract the data at a table level with ability to select the columns that are required (but not the rows).

    2. We might be able to extract multiple tables at once but not with their relational definitions.

    3. We need to build the table relationship in our data repository, essentially replicating the OMS Database outside SaaS. This needs product/data model expertise.

    We require a subset of data to redefine our alerting and monitoring capability to manage our service operation from SaaS. So we need to build a intermediate data repository to hold all the tables, build the relational behaviour and then filter the required data. This will be an expensive tech debt to build.

    Our plan was to use Cognos to extract our custom data set but IBM has imposed limitations on number of executions per week.

    What would be your suggestion to extract required dataset out of SaaS for our processing?

  • Admin
    Sampson Wong
    Feb 14, 2023

    Please consider use of data extract agent as explained here.