I have a question regarding database use in Qlik Sense. I connect to the database using ODBC, setting up a SQLite3 link. In Qlik Sense I use this link to make a new connection and everything works seems to work fine. However when I go to 'Select Data' it only shows empty tables. I've tried most things and after some time I could use the data in the tables using this method:
LIB CONNECT TO 'EBS';
SELECT * FROM Article;
After pressing 'Load Data' I go to app-overview and open a new worksheet. When I press 'Edit' and go to 'Fields' on the left, I can use the Article table data.
My question: Is this the way it should work? I'v followed this tutorial An Introduction to Qlik and SQLite – Tech Trek the last picture from the tutorial shows table data when you select one. I do have the tables, but nothing shows when I select one. Also it says Database undefined - Owner undefined. Any suggestions?
First of all, As I heard there are some issues with ODBC connection in Qlik Sense 3.0. What I know about SQLite3, Please prefer OLE DB connection for connectivity. then you can get the physical tables. Please check first on premise that your connection OLE DB is working fine if yes then Use Qlik Sense.
Note: Please check your user permissions on the database.
Please mark the appropriate replies as CORRECT / HELPFUL so our team and other members know that your question(s) has been answered to your satisfaction.