DataTransfer Connection to On Premise ODBC

[manojkulkarni]

Hi All,

How do we connect On premise ODBC DSN using DataTransfer ? Can any one send me the details or if any documents available to configure and establish connectivity.

[PadmaPriya]

Hello @manojkulkarni 

To connect ODBC DSN using Data Transfer please refer to below articles mentioned:

Uploading on-premises data with Qlik DataTransfer 

Troubleshooting Qlik DataTransfer 

Let us know if you have any further queries.

Thanks,

Padma Priya

Senior Technical Support Engineer-Qlik Support

[manojkulkarni]

We don't have details steps for ODBC connection. I am getting following error "Connector connect error:Could not create connection." 

I have DSN created for Excel workbook and try to create connection for the same using DataConnector - ODBC. 

Please advise

[PadmaPriya]

Hello @manojkulkarni 

Please refer to below link:

ODBC Connection 

Thanks,

Padma Priya

[manojkulkarni]

I have followed the same steps provided in the link, i am getting below. What could be the reason ? 

 "Connector connect error:Could not create connection." 

[PadmaPriya]

it's most likely being blocked by security software blocking EXE file execution. This can usually be verified with the Windows Event logs (application logs).

[manojkulkarni]

didn't see any events in Windows logger but could find some from Qlik Logs.

What could be the issue for below error, i did search but no clue on it 

20210427T115528.553+0530 localhost 3.19.2 Global ERROR Error: Connection ID 0 couldn't be found.
at Object.getConnection (C:\Program Files\Qlik\DataTransfer\DataUploadService\index.js:214:145866)
at async getDatasetById (C:\Program Files\Qlik\DataTransfer\DataUploadService\index.js:471:93176)
at async createConnection (C:\Program Files\Qlik\DataTransfer\DataUploadService\index.js:471:89581)

[PadmaPriya · Accepted solution]

Please refer to below article, seems to be a possible cause of this error is that password for the connection has already been provided when creating the DSN in ODBC Data Source Administrator. Some ODBC driver allows saving connection credentials in DSNs, so that applications using the DSN don't need to provide password again.

https://support.qlik.com/articles/000053199

[manojkulkarni · Accepted solution]

Thanks for your support. It resolved connection issue. 

After successful connection, I am trying to upload data to SaaS but getting the below error message

Reload Failed: Connection 'ODBC_Test' not found.

[PadmaPriya]

Thanks for your reply.

I am glad that the initial issue is solved for you.

Reload Failed: Connection 'ODBC_Test' not found.

The issue is related to Windows' ODBC DSN setup on the machine where reload fails. 
Below are some basic steps to troubleshoot this issue in Windows ODBC administrator tools. 

Please check if ports are enabled and also refer to below article:

https://support.qlik.com/articles/000005615

Thanks,

Padma Priya

Senior Technical Support Engineer-Qlik Support