topic Re: DataTransfer Connection to On Premise ODBC in Connectivity & Data Prep

DataTransfer Connection to On Premise ODBC

manojkulkarni — Fri, 10 Dec 2021 21:06:16 GMT

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.

Re: DataTransfer Connection to On Premise ODBC

PadmaPriya — Mon, 26 Apr 2021 15:52:43 GMT

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

Re: DataTransfer Connection to On Premise ODBC

manojkulkarni — Tue, 27 Apr 2021 05:21:34 GMT

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

Re: DataTransfer Connection to On Premise ODBC

PadmaPriya — Tue, 27 Apr 2021 05:40:23 GMT

Hello @manojkulkarni

Please refer to below link:

ODBC Connection

Thanks,

Padma Priya

Re: DataTransfer Connection to On Premise ODBC

manojkulkarni — Tue, 27 Apr 2021 06:14:51 GMT

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

Re: DataTransfer Connection to On Premise ODBC

PadmaPriya — Tue, 27 Apr 2021 06:20:06 GMT

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

Re: DataTransfer Connection to On Premise ODBC

manojkulkarni — Tue, 27 Apr 2021 06:33:19 GMT

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)

Re: DataTransfer Connection to On Premise ODBC

PadmaPriya — Tue, 27 Apr 2021 06:37:34 GMT

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

Re: DataTransfer Connection to On Premise ODBC

manojkulkarni — Tue, 27 Apr 2021 07:56:45 GMT

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.

Re: DataTransfer Connection to On Premise ODBC

PadmaPriya — Tue, 27 Apr 2021 10:38:40 GMT

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