I recently downloaded Qlik Sense and am trying to develop my first dashboard. I first want to connect to a Database. I don't know whether
1. I should do it in the QMC since its the first database connection that I am trying to make or
2. I can directly go to Qlik Sense an in the Data Load Editor, "Create new connection".
I tried both the above steps:
1. In the first one, I can't see any "Add" button where I can give a new Database connection
2. I tried the second one as well. I went to Qlik Sense>> Data Load Editor>> Create new connection>> OLE DB >> Selected the "Microsoft OLE DB Provider for SQL Server" (depending on the DB) >> Entered the Data Source info followed by the Specific user name and password>> Clicked on "Test connection". But it says connection failed. I even tried saving the Data source name but it says "You do not have access to the data source" though I am able to access it through Qlik View using the same credentials.