Hello
I am a business consultant. I have been using Qlik View for 15 years. I have done various tests over the past few years with qlik sense desktop. I have now started using Qlik Sense Business (which is Saas type).
I have problems connecting ODBC with a SQL Server through Qlik Sense Data transfer , problems that do not exists if I use View or Sense Desktop.
In Sql Server Express 19 on local I have System Data base and two test data base (LENOVOTEST and School)
![VANNI_0-1615887715996.png VANNI_0-1615887715996.png](/t5/image/serverpage/image-id/51214i60135C6FF73603FF/image-size/medium?v=v2&px=400)
I have activated a ODBC DSN named LENOVO with the latest driver.
![VANNI_2-1615889158887.png VANNI_2-1615889158887.png](/t5/image/serverpage/image-id/51219i12D734CBF01992DC/image-size/medium?v=v2&px=400)
When I use ODB connection with Qlik View I can access to all DB's and tables of each DB
![VANNI_1-1615888263583.png VANNI_1-1615888263583.png](/t5/image/serverpage/image-id/51217iBA2FBB6515FAAE24/image-size/medium?v=v2&px=400)
When I use ODBC from Qlik Sense Desktop I can access to all DB's and all tables of each DB
I can find the database LENOVOTEST and I can select the owner (dbo) and then select the table
![VANNI_4-1615889414995.png VANNI_4-1615889414995.png](/t5/image/serverpage/image-id/51222iA61FCB0C89E03C15/image-size/medium?v=v2&px=400)
Now, when I tried to use Data Transfer to upload table with ODBC SQL it is possible only for the tables in systems SQL DB (i.e. master , model, msdb, tempdb)
![VANNI_5-1615890373115.png VANNI_5-1615890373115.png](/t5/image/serverpage/image-id/51223i6E9B811F1724F87B/image-size/medium?v=v2&px=400)
because when you select a different table it is impossible to enter the owner for the reason that this part remain inactive, the box remains under intensified
![VANNI_6-1615890665865.png VANNI_6-1615890665865.png](/t5/image/serverpage/image-id/51224iEC9B2B4F5C883BE8/image-size/medium?v=v2&px=400)
I tried in two different PC environment and I obtained the same result.
Has anyone already had this problem and can help me to solve it?
Many Thanks
Vanni Pancaldi