Removal of support for P12 key file with the Google BigQuery Connector in February 2024

[Sonja_Bauernfeind]

Edited 29th of January, 15:00 CET, added information on how to migrate to use a JSON key file, as well as updated the release date for on-premise from February to May 2024.
Edited 23rd of February, 15:10 CET, updated release date for Qlik Cloud release, which has been confirmed for the 6th of March 2024. 

Hello everyone,

An upcoming update of the Qlik Sense Google BigQuery Connector will no longer support the use of a p12 file as the Key File. This is currently supported while Service Authentication is used as the OAuth mechanism. If you are using a p12 key file in the definition with this connection scenario, you will have to migrate to a JSON key file instead.

Why is this change being made?

The latest version of OpenSSL, 3.0, has deprecated p12 as a legacy function. Therefore, while the new connector version will have a new driver supporting OpenSSL 3.0, it cannot support p12 key files anymore.

How do I migrate to use a JSON key file?

The easiest way to migrate is to create a new JSON key file in the Google Console. Then, the new key file can be used in the connection definition replacing a currently used p12 file. See Google Cloud documentation for more details on how to create and delete service account keys.

When will this change take effect?

The updated Connector will be rolled out in Qlik Sense Cloud on the 6th of March, and in the May 2024 release of Qlik Sense Enterprise on Windows.

Thank you for choosing Qlik,
Qlik Support

[ksandeepmahindra]

Hi,

Can we have exact roll out date in Qlik Cloud as customers has to prepare for this change in their tenants.

--Sandeep

[Sonja_Bauernfeind]

Hello @ksandeepmahindra 

Let me find out for you.

All the best,
Sonja 

[rzenere_avvale]

Hey there @Sonja_Bauernfeind ,
Just to be sure: if we have an environment which will not be updated anytime soon, the BigQuery connector will keep working with p12 key files? Or will they stop working?

Regards,
Riccardo

[Sonja_Bauernfeind]

@ksandeepmahindra Our target date is the 28th of February. (Update from the 23rd of February: this has been moved to the 6th of March)

@rzenere_avvale If you do not upgrade Qlik Sense Enterprise on Windows (on-prem) to May 2024, your current installation will continue to function with p12 key files. Drivers for connectors are not included in patches on older versions, unless a critical defect is detected (such as a vulnerability). 

All the best,
Sonja 

[rzenere_avvale]

Thanks for the clarification @Sonja_Bauernfeind!

Riccardo

[ksandeepmahindra]

Thanks @Sonja_Bauernfeind