Google sheets integration with Cognos 10 BI

[bhupalalerts@gmail.com]

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.