Dear friends,
I am trying to establish the data source connection between cognos to Google sheets as a source.
We know that Google Sheets ODBC Driver is tool that allows you to easily connect-to live Google Sheets data through ODBC capable application Cognos.
Please explain uses and Pre requisites and howits useful for business cognos with google sheets
I have installed the Microsoft ODBC Data Source Administrator and configure the ODBC System DSN to connect the Google Sheets .
When I test the connection with sample google sheet it is successful.
But when I set up the new data source in cognos Administration it failed. Could you please help us what are the other parameters/Connection string
I should give to establish the data source connection.
Also If you have already done set up for Cognos 10 BI with Google Sheets integration,Please share the document.