Azure Storage Container as Target to write parquet files

vinodn1989 — Wed, 21 May 2025 18:23:01 GMT

Encountering a persistent issue while trying to write data from SQL Server to Azure Blob Storage in Parquet format using Qlik Replicate. I'm authenticating via an Azure Enterprise Application, but I'm hitting a permissions-related error.

Source: SQL Server
Target: Azure Blob Storage (Container - raw)
Format: Parquet
Tool: Qlik Replicate
Authentication: Service Principal (Enterprise App in Azure AD)
Connection Method in Qlik: OAuth2 (with Client ID, Secret, Tenant ID)

Note:

Already added storage blob contributor and reader roles to the application in the storage for the account.

Error:

SYS-E-HTTPFAIL, Failed to connect to Data lake store name 'arthachicagoadb'..
SYS,GENERAL_EXCEPTION,Failed to connect to Data lake store name 'arthachicagoadb'.,JAVA_EXCEPTION, message: 'io.swagger.client.ApiException: This request is not authorized to perform this operation using this permission.'

Re: Azure Storage Container as Target to write parquet files

john_wang — Sat, 24 May 2025 04:34:43 GMT

Hello @vinodn1989 ,

This is a permissions/authentication error. The request is failing because the credentials or token being used does not have sufficient permission to perform the operation. It's an error out of Qlik Replicate, please work with your DBA to get it solved.

BTW, from the error message:

SYS-E-HTTPFAIL, Failed to connect to Data lake store name 'arthachicagoadb'..

the URL should be like arthachicagoadb.blob.core.windows.net?

Hope this helps.

John.

topic Re: Azure Storage Container as Target to write parquet files in Qlik Replicate

Azure Storage Container as Target to write parquet files

Re: Azure Storage Container as Target to write parquet files