I have established a DSN Less connection from Azure DataFactory to Denodo, however I am unable to set queryTimeout parameter and due to this long running jobs are failing after default timeout i.e. 15mins.
Can anyone help me here to understand how can I add/mentioned queryTimeout 0 to DSN-Less connection string?
Is there a way to utilize ConnSettings= parameter for this scenario?
"DRIVER={DenodoODBC Unicode(x64)};UID=@{linkedService().userName};PWD=@{linkedService().password};SERVER=@{linkedService().server};DATABASE=@{linkedService().dbName};PORT=@{linkedService().port};SSLmode=prefer;service=;krbsrvname=HTTP;UserAgent=<user agent>;ReadOnly=0;Protocol=7.4-1;FakeOidIndex=0;ShowOidColumn=0;RowVersioning=0;ShowSystemTables=0;ConnSettings=set+i18n+to+us%5fpst%3b;Fetch=100;Socket=4096;UnknownSizes=0;MaxVarcharSize=255;MaxLongVarcharSize=8190;Debug=0;CommLog=0;Optimizer=0;Ksqo=0;UseDeclareFetch=1;TextAsLongVarchar=1;UnknownsAsLongVarchar=0;BoolsAsChar=0;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePrefixes=dd_;LFConversion=1;UpdatableCursors=0;DisallowPremature=0;TrueIsMinus1=0;BI=0;ByteaAsLongVarBinary=0;UseServerSidePrepare=0;LowerCaseIdentifier=0;PreferLibpq=1;GssAuthUseGSS=0;XaOpt=3;UseKerberos=0"
Thanks in advance.
Best Regards,
Sourav
