How do I connect MySQL to Sisense?
This is my first time using Sisense, I was asked as part of the interview process to get myself familiar with Sisense platform so I signed up for a free trial to use Sisense. I'm wondering if I can c...
Forum Discussion
Hi AnnaQuocNguyen ,
Sisense offers a built-in mysql connector. You do not have to install anything for it. Just create a new elasticube , press + Data en select MySQL as connector. Do check if its enabled if you do not see this option:
To configure connectors via the Configuration Manager:
Access the Configuration Manager through the System Management section of the Admin page.
Click Configuration.
Click Manage Connectors.
Enable or disable connectors by toggling the switch to Enabled or Disabled.
Click Save.
If for some reason it doesn't work, you can download/install the driver from CData. More on this can be found here: https://documentation.sisense.com/docs/connecting-to-jdbc-connectors-using-cdata-drivers
Hi,
Thank you for your response. I followed all the steps and I still could not connect MySQL as you can see from the first screenshot I provided, even though when I test the connection it says connection successful as you can see from the second screenshot. Is there anything that I may be missing out on?
