Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Not able to view tables for SAPABAP1 user in Qlik Sense via ODBC

Dear All,

I am able to see all tables for all owners but not able to see tables for SAPABAP1 user as owner via ODBC. I have granted ABAP_READ and ABAP_SYS_REPO  to user for Qlik Sense.


I tried OLEDB but it is taking hell lot of time and even after 2 Hrs not able to view anything only wait / in progress circle is there.


Any help thanks in advance.


Regards

2 Replies
Anonymous
Not applicable
Author

Have you managed to solve this issue? I have run into the same problem and perhaps we can exchange experience.

Anonymous
Not applicable
Author

Hi Sorry for delay in response, I was not able to view tables but able to manage via script. I you know the table names and simple select statement you can do that.

Click on "Data Load Editor"

and write the connections and select commands in the end of the std script.


LIB CONNECT TO '<ODBC_Connection_NAME>';

SQL SELECT *

FROM SAPABAP1.KNA1;

SQL SELECT *

FROM SAPABAP1.BSAD;

SQL SELECT *

FROM SAPABAP1.BSID;

Now click on load data, then you are able to get above tables available for working in click sense.


Do let me know if it helped you.