Azure Storage Container as Target to write parquet files

[vinodn1989]

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.'

[john_wang · Accepted solution]

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.