Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to create a Pipeline between an On Prem Server and Snowflake using Qlik Cloud Data Integration.
When preparing the Onboard Landing I'm getting the below errors in the Logs:
00052616: 2023-12-19T10:29:31 [METADATA_MANAGE ]E: RetCode: SQL_ERROR SqlState: 01000 NativeError: 0 Message: [unixODBC][Driver Manager]Can't open lib 'SnowflakeDSIIDriver' : file not found [1022502] (ar_odbc_conn.c:584)00052616: 2023-12-19T10:29:31 [METADATA_MANAGE ]E: Cannot connect to Cloud server [1022501] (cloud_imp.c:4445)00052616: 2023-12-19T10:29:31 [METADATA_MANAGE ]E: Failed while preparing stream component 'EP_5MBC6itJAfH_fXACJvkW2g'. [1022501] (metadatamanager.c:855)00052616: 2023-12-19T10:29:31 [METADATA_MANAGE ]E: Cannot create the target utility component [1022501] (metadatamanager.c:760)00052616: 2023-12-19T10:29:31 [TASK_MANAGER ]E: Creating Metadata Manager's utility components failed [1022501] (replicationtask.c:3896)00052616: 2023-12-19T10:29:31 [TASK_MANAGER ]W: Task 'TASK_iBQTeRpRGafCnhxePLfAMg' encountered a fatal error (repository.c:6064)
Hello, it appears the drivers have not been installed on the data movement gateway.
Message: [unixODBC][Driver Manager]Can't open lib 'SnowflakeDSIIDriver' : file not found [1022502]
Please ensure the drivers for source and targets are installed by running the driver mgmt utility.
Eg. for installing Snowflake on your gateway machine (ensure python is installed on the server) and follow the below directions -
The help docs show how to run the utility on the gateway - https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/DataIntegration/TargetCo...