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
