I have a MySQL database set up in an AWS RDS instance, to which I write data via web and phone apps. I now want to connect QlikView to same database instance for visualisation purposes, but unclear on how to do so. Pointers greatly appreciated, as I mostly find info relating to QlikSense to AWS when I search, but I'm still on QlikView.
Some background: I have QlikView running on my PC, which currently connects to locally stored MySQL via an ODBC connection. I also use Workbench from Oracle to connect to my AWS MySQL database using Standard TCP/IP and the security settings defined on AWS, such as endpoint and port along with u/n and p/w. I'm just not sure how to replicate this connection in QlikView. thanks