SYMPTOM:
When trying to connect to a Google BigQuery datasource, using Service Account authentication, the following error appears in Strategy ONE Update 11:
(QueryEngine encountered error: Connect failed. Error type: Odbc error. Odbc operation attempted: SQLDriverConnect. [28000:8706: on SQLHANDLE] [Strategy][BigQuery] (8706) Unable to open keyfile: P12 key file is not supported in this version..
CAUSE:
Strategy ONE Update 11 ships a new Google BigQuery driver that no longer supports using a P12 file as the Key File. In previous versions, the Key File could be a JSON or P12 file, but starting in Strategy ONE Update 11 only JSON will be supported.
ACTION:
Use a JSON file as the Key File.
