Direct Discovery to Google BigQuery source

Ja123__ — Fri, 10 Dec 2021 21:09:00 GMT

Hi Everyone

We are testing options for a client. From what we read, ODAG would be the most manageable and stable way to access cloud data from their on-prem Qlik Sense environment, without needing to replicate the data into a QVD layer. A specific request for the project as we compare to PowerBI. We are using standard Google BigQuery Qlik connector.

ODAG has worked but we want to build a stable alternative using DirectDiscovery as well.

It works, to an extent. What we are experiencing though, is regular 'DataBase Connection Failed'.

We read through Qlik's guide on DirectDiscovery and were hoping for this to be a solid alternative to our ODAG example.

Is there anything someone on the forum could recommend? We are starting simple:

STANDARD VARIABLE SCRIPT, followed by:

SET DirectIdentifierQuoteChar = '``';

DIRECT QUERY

DIMENSION

`brn_code` AS BranchCode
,`style_description` AS Style
,`sku_no` AS SKU
,`sales_business_unit` AS SBU
,`ops_new_split` AS OpsNewSplit
,`business_type` AS BusinessType
,`sales_type` AS SalesType
,`year` AS Year
,`month` AS Month
,`week` AS Week

MEASURE

NATIVE('CAST(`ty_sales_total` AS FLOAT64)') AS SalesTY

FROM

`XXXXXXX`.`XXXXXXX`;

topic Direct Discovery to Google BigQuery source in Connectivity & Data Prep

Direct Discovery to Google BigQuery source