Cognos Analytics

Expand all | Collapse all

Azure Data Lake Gen2

  • 1.  Azure Data Lake Gen2

    Posted 27 days ago
    Is it possible for Cognos Analytics v11.1.7 or v11.2 to use Azure Data Lake Gen2 files (parquet and/or csv) to build dashboards and reports?  I do not see Azure Data Lake as a type when I try to create a new Data Server connection.

    ------------------------------
    Missy Price
    BI Analyst
    ND Information Technology
    Bismarck ND
    ------------------------------


  • 2.  RE: Azure Data Lake Gen2

    Posted 26 days ago

    Hi Missy

    I guess you can look at REST API data sources if azure data lake zen 2 provides an api end point to access the data. See the below blog from @Jason Tavoularis

    https://community.ibm.com/community/user/businessanalytics/blogs/jason-tavoularis1/2020/07/30/connecting-to-rest-api-data

    Regards



    ------------------------------
    Kiran Passumarthi
    www.linkedin.com/in/kiranpassumarthi
    ------------------------------



  • 3.  RE: Azure Data Lake Gen2

    Posted 26 days ago

    Dynamic Query supports several engines, which would provide means to directly query various formats stored in S3, GCS or Azure storage etc.

    Examples include: Azure SQL, Presto (now called Trino), Starburst etc

    https://www.starburst.io/platform/deployment-options/starburst-on-azure/



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