Thank you again. I dont see Driver class name for data server connection and available for data source connection.
Which Cognos Version you are in? We have 11.0.13
Is JDBC URL format is same for data server connection and data source connection same?
For data source connection, signon is the google cloud account which has access or service account?
------------------------------
Pavan Pothamsetty
------------------------------
Original Message:
Sent: Thu July 09, 2020 11:39 AM
From: NIGEL CAMPBELL
Subject: Configure data server connection for Google Bigquery
Data Server Connections UI and from Admin UI both have a text control box which shows the driver class name.
If you have further issues, suggest you open a support ticket.
------------------------------
NIGEL CAMPBELL
------------------------------
Original Message:
Sent: Thu July 09, 2020 11:09 AM
From: Pavan Pothamsetty
Subject: Configure data server connection for Google Bigquery
I dont see Driver class name while creating new data server connection for big query. Enclosed the screenshot
------------------------------
Pavan Pothamsetty
Original Message:
Sent: Thu July 09, 2020 10:08 AM
From: NIGEL CAMPBELL
Subject: Configure data server connection for Google Bigquery
The text control in the connection editor with the label "Driver class name".
------------------------------
NIGEL CAMPBELL
Original Message:
Sent: Thu July 09, 2020 09:39 AM
From: Pavan Pothamsetty
Subject: Configure data server connection for Google Bigquery
HI,
Thank You. Where can i edit the driver class name in connection? Is it in the JDBC url?
------------------------------
Pavan Pothamsetty
Original Message:
Sent: Wed July 08, 2020 11:47 AM
From: NIGEL CAMPBELL
Subject: Configure data server connection for Google Bigquery
Google supplies the SIMBA developed JDBC driver.
Prior to 1.2.2.1004, Google (SIMBA) were shipping JAR files which used different driver class names
com.simba...jdbc41.Driver
com.simba...jdbc42.Driver
As of 1.2.2.1004 they only supply the 42 driver class.
When a connection is created in CA, you will see it assign a default driver class name. Normally one would never edit the entry.
The error you see means that the Java Runtime cannot locate a JAR which implements. jdbc 41driver.
If you have downloaded the driver and put it into <cognos>\drivers, you probably have their 42 driver.
So edit the driver class name in the connection.
------------------------------
NIGEL CAMPBELL