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:
Sent: Fri June 12, 2020 01:56 AM
From: CAMILO CARLO MENDIOLA
Subject: Need help to connect to local access database
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:
Sent: Thu June 11, 2020 01:09 PM
From: Sanjay Chakravarty
Subject: Need help to connect to local access database
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
Original Message:
Sent: Thu June 11, 2020 12:34 PM
From: CAMILO CARLO MENDIOLA
Subject: Need help to connect to local access database
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