Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

emckinley
New Contributor II

Qlik Sense 3.1.2 and Netsuite ODBC

The ODBC works and connects if you test the connection via ODBC Data Source Administrator.  The error occurs when trying to either create a ODBC connection or use the existing connection that are in applications.

Problem:

Loading the data you get this error on the Data Load progress page:

Connector connect error: ***

The error occurred here:

?

Environment:

The ODBC connection works fine on our production 2.2.4 version

The ODBC data connection stopped working after upgrading from 2.2.4 to 3.1.2 in our development environment which was the same version as production initially.

Editing the connection and entering the credentials, the error is "ErrorCode:11043"...


Has anyone had this issue with the latest version and Netsuite?

1 Solution

Accepted Solutions
emckinley
New Contributor II

Re: Qlik Sense 3.1.2 and Netsuite ODBC

We saw in the latest release (3.2.4) that Qlik "fixed" the issue with Netsuite ODBC so everything is right with the world.  After sending many messages that something was wrong they finally owned up to it and fixed the issue...

12 Replies
Not applicable

Re: Qlik Sense 3.1.2 and Netsuite ODBC

We have the same issue. We have also tried it with 3.1.4.

emckinley
New Contributor II

Re: Qlik Sense 3.1.2 and Netsuite ODBC

I've tried putting in a support "ticket" but the only response we got from our vendor and Qlik is that somehow "we" have to get Netsuite to upgrade their ODBC connector.  Qlik's position is that it's their problem, not theirs...They knew this was a problem and should have documented it in the upgrade documentation so we wouldn't have upgraded.

Workaround: I'm developing a data mart using SSIS and will connect to Netsuite in that manner.

karthiks_dwbi
Contributor II

Re: Qlik Sense 3.1.2 and Netsuite ODBC

Try giving full rights to the driver files for the Qlik service user and try it.

Not applicable

Re: Qlik Sense 3.1.2 and Netsuite ODBC

I just tried it with v3.2 desktop and it worked.

tinaco110
Contributor III

Re: Qlik Sense 3.1.2 and Netsuite ODBC

Hi All,

We were experiencing this error using Qlik Sense Desktop version 3.1 SR3 while trying to connect to a different database vendor; it turned to be the account password has special characters, like the @ sign, it worked fine after changing the account password using just alphabetical and numerical characters (no special characters).

If you are experiencing this error, try to avoid special characters in your login credentials (account and password)

Hope this helps,

emckinley
New Contributor II

Re: Qlik Sense 3.1.2 and Netsuite ODBC

I changed my Netsuite password to use caps and no special characters...we still have the problem...  That was a good suggestion we didn't think of doing...

jlasov87
New Contributor

Re: Qlik Sense 3.1.2 and Netsuite ODBC

Sorry about your ODBC issues. The problem with ODBC is the amount of IT support it takes to manage. AN AWESOME alternative is using saved searches that will live connect with your Qlik instance. Check out Tactical Connect - the alternative we use.

Not applicable

Re: Qlik Sense 3.1.2 and Netsuite ODBC

The ODBC issue is resolved in 3.2

Not applicable

Re: Qlik Sense 3.1.2 and Netsuite ODBC

We have worked with our customers who use NetSuite and Qlik and built a NetSuite connector for Qlik Sense to take advantage of not only NetSuite but Open Air if you happen to use this module as well. Feel free to download it and try it out: Crunch Data

Community Browser