How to set up Qlik Sense Google BigQuery connection?

[Bo_PT]

Hi, there,

I am trying to set up Google BigQuery connections in Qlik Sense and have some questions:

#1. I followed this instruction (https://help.qlik.com/en-US/connectors/Subsystems/ODBC_connector_help/Content/Connectors_ODBC/Google...), and downloaded a CA certificate (PEM file). What should I do with this certificate? Should it be used for 'SSL Options' when creating BigQuery connection?

#2. Our server is Windows system. Based on this instruction (https://help.qlik.com/en-US/connectors/Content/Connectors_Home/Setting-encryption-key.htm), I need to set an encrypted key. In the 'Generating an encryption key' section, it says 'The key must be a secure, random string of characters between 32 and 4096 bytes in size when encoded in UTF-8 format.'. And it look like this key is used in the steps described in 'Setting an encryption key on Qlik Sense Enterprise on Windows' section. But how to generate such an encrypted key?

We are using Qlik Sense May 2024 release. Operating system: Windows Server 2022.

Thanks

[Chip_Matejowsky · Accepted solution]

Hi @Bo_PT,

Per the Help entry Setting an encrption key, you should work with your internal IT to generate the encryption key based upon the reuirements listed.

Best Regards

[Diwakar]

Hello @Bo_PT 

Were you able to create the connection to Big Query ?

I am working on the same and would like your inputs if you were able to create connection.

Thanks 

Diwakar

[Bo_PT]

Hi, @Diwakar,

Yes, I am able to create GigQuery connections in both Qlikview and Qlik Sense.

For the question #1 in my original post, I did not use PEM certificate. PEM is SSL certificate and it is optional, not required.

For the question #2, our security team generated a key file (.json) which looked something like this:
{
type": "service_account",
"project_id": "<project_id>",
"private_key_id": "<a 41-charactor-long-string>",
"private_key": "-----BEGIN PRIVATE KEY-----\n.....<a very long string>...\n-----END PRIVATE KEY-----\n",
...
"universe_domain": "googleapis.com"
}

I used this file to set up BigQuery connection and it works.

Hope this helps.

Bo

[Diwakar]

Thanks @Bo_PT 

This helps.

Regards,

Diwakar