Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
vanderson009
Creator III
Creator III

ODBC Connection Issue

Hi Team,

I have set up the Direct Access Gateway and created a system DSN. However, I am unable to establish a data connection in Qlik Cloud using the system DSN that I successfully created on the machine where the Direct Access Gateway is installed.

attached is error which I am getting while establishing connection. 

Thanks

 
Labels (3)
1 Reply
rafaelencinas
Partner - Creator II
Partner - Creator II

I had this same issue in the past.

 

Solution 1:

- Open a specific port to Qlik Cloud connect Sap Hana Direct with Native Driver

 

Solution 2

- Connect over Linked Server

- Install SQL Server Express

- Configure Linked Server

- Create Views

- Configure Data Gateway Direct Access to see this connection.

 

Bye!

 

"Without data, you're just another person with an opinion." — W. Edwards Deming.