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.  Need help to connect to local access database

    Posted 06/11/20 12:34 PM
    Hi. I'm trying to connect to an access database saved in my machine but not successful. Is there a guide I can refer to? I'm on a standard plan. Thanks.

    ------------------------------
    Camilo Carlo Mendiola
    Data Analyst
    IBM
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Need help to connect to local access database

    Posted 06/11/20 01:09 PM
    Hello Camilo
    You will need to create a ODBC connection. See below link
    https://www.ibm.com/support/pages/how-setup-datasource-connection-microsoft-access-database-cognos-analytics
    Thank you

    ------------------------------
    Sanjay Chakravarty
    ------------------------------



  • 3.  RE: Need help to connect to local access database

    Posted 06/12/20 01:57 AM
    Hi Sanjay. Tried that but I don't see ODBC from the list of connections. Can I use MS SQL?

    ------------------------------
    Camilo Carlo Mendiola
    Data Analyst
    IBM
    ------------------------------

    Original Message


  • 4.  RE: Need help to connect to local access database

    Posted 06/12/20 03:11 AM
    Hi,

    did you check IBM Cognos Analytics on Premises Supported Software Environments ?
    are you able to provide us error message / cognos release / environment information ?

    if you are using MS SQL Server Express it is not supported, so a little bit tricky to make it works.

    regards,

    ------------------------------
    Vivien
    Senior Consultant
    Talan Solutions
    Paris
    ------------------------------

    Original Message


Related Content