Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only
  • 1.  Still no Native BigQuery connection?

    Posted Sat June 10, 2023 06:40 AM
    It looks like the 12 release still doesn't have an option to connect to BigQuery for On Cloud on Demand customers.

    Seems a very big gap in the offering.
    Any idea if this is on the roadmap?

    Thanks
    Gill
    --
    Please note that our normal operating hours from Monday to Thursday are 08h00-17h00 SAST and 08h00-13h00 SAST on Fridays. SSN believes in the need for flexibility in how we and our partners work. Whilst it suits me to send this email now,  any response or action required from you respects your flexibility, unless time-sensitivity is explicitly indicated. 


  • 2.  RE: Still no Native BigQuery connection?

    Posted Mon June 12, 2023 10:59 AM

    We are using the Simba driver, as recommended by Google.  Performance is a concern however.  Agree a native driver would be preferred and one that meets security requirements for more regulated environments.



    ------------------------------
    Kay Vandevanter
    ------------------------------



  • 3.  RE: Still no Native BigQuery connection?

    Posted Mon June 12, 2023 01:39 PM
    Thanks Kay.

    The problem is that with the On Demand license, there is no option to add additional drivers, or even use an ODBC connection.  So the Simba driver is not an option.

    --
    Please note that our normal operating hours from Monday to Thursday are 08h00-17h00 SAST and 08h00-13h00 SAST on Fridays. SSN believes in the need for flexibility in how we and our partners work. Whilst it suits me to send this email now,  any response or action required from you respects your flexibility, unless time-sensitivity is explicitly indicated. 





  • 4.  RE: Still no Native BigQuery connection?

    Posted Wed July 26, 2023 09:03 AM

    With respect to the comment about performance of the driver Google BigQuery distributes.
    https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers

    Have you proven outside of Cognos Analytics where the JDBC driver Google distributes causes performance issues?
    In turn, did you open issues with Google BigQuery support re those topics and your comment about security?



    ------------------------------
    NIGEL CAMPBELL
    ------------------------------



  • 5.  RE: Still no Native BigQuery connection?

    Posted Fri July 21, 2023 04:28 AM
    Edited by Zachary Taylor Fri July 21, 2023 04:32 AM

    Hi Gill, We have not added the Simba BiqQuery driver to the On Demand offering because we don't have the legal right to redistribute their driver on someone else's behalf. If this is a need and you are willing to communicate this requirement to Google, please let me know and we could start to gather requirements. Thanks, Zach  - Cognos PM

    **Point of clarification - for the Cognos Analytics Hosted offering, you can upload your own drivers, and for the On Demand offering, the list of drivers is provided. 


    ------------------------------
    Zachary Taylor
    ------------------------------