Connecting to BigQuery using ODBC in Qlikview

519 views Asked by At

I have the latest BigQuery ODBC driver installed and setup according to the instruction here

I was able to follow the tutorial and access the data in MS Excel.

However in Qlikview I was unable to see any tables when using the same ODBC connection.

1

There are 1 answers

0
Johnson On BEST ANSWER

The ODBC driver is functional. What I didn't notice was that I didn't have any dataset created under the BigQuery test project, hence no table was available.

It is still possible to utilize QlikView to access the public data set by adding the query strings in the scripts after the ODBC CONNECT line.

QlikView Edit Script screen