Cognos Analytics

Cognos Analytics

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


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

  • 1.  Amazon Redshift data source connection does not show procedures, functions in FM

    Posted 08/25/21 10:25 AM
    Cognos Analytics 11.1.7FP1
    We created JDBC data source connection to Amazon Redshift database using Redshift JDBC driver redshift-jdbc42-2.0.0.7.jar.
    We are creating the Framework Manager project to create the model and need to work with Redshift procedures and functions.
    They do not show up in the schema objects list when running Metadata Wizard. Tables show as expected, but no procedures and functions. When connecting to the database using other tools, procedures and functions show.
    Is it possible to work with Redshift procedures and functions in FM? Is there a trick to getting them to show?
    Thanks for any help.
    Charles

    ------------------------------
    Charles Dennis
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Amazon Redshift data source connection does not show procedures, functions in FM

    Posted 08/26/21 10:53 AM
    There were quality issues associated to versions of the Amazon Redshift driver and their implementation of the DatabaseMetadata interface interface methods that describe those objects. In some cases resulting in errors not just incorrect information etc. Hence, older CA releases would not return metadata for those objects even if you were to use newer Amazon drivers.

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



  • 3.  RE: Amazon Redshift data source connection does not show procedures, functions in FM

    Posted 08/27/21 06:51 AM
    Thank you for your reply. Do no driver versions pick up these objects? Would the ODBC driver work? Is there no way to create FM packages based on procedures, functions in this case? Thanks again.

    ------------------------------
    Charles Dennis
    ------------------------------

    Original Message


  • 4.  RE: Amazon Redshift data source connection does not show procedures, functions in FM

    Posted 08/27/21 07:51 AM

    You do not have to import scalar functions metadata from a database before you can reference them in an expression.

    Importing procedures via the driver is in our backlog, per prior comment, that would require Redshift users to be on versions >= when they fixed their issues.

    Unfortunately, they like a few other cloud databases announced support for procedures and UDF, but had defects in their drivers, which we noted to them etc.

    Note also that a reference to an in database function can be annotated, if necessary to identify if it should be treated as an aggregate etc.

    This is covered in the following docs https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=rules-using-scalar-aggregate-functions



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

    Original Message


Related Content