This topic describes how you can add live connections to your MySQL databases in Sisense.
For information about live connections, see Live Connect.
To add a MySQL live connection:
- Open a live model. See Creating Live Models for more information.
- In the Model Editor, click .
- In the Add Live Connection dialog box, select MySQL.
- Under the Connect tab, enter the following credentials:
- Location: The IP address of your data source.
- User Name: The user name to access data source.
- Password: The password to access your data source.
- Click Next.
- Under the Select Data tab, on the left side is a list of schemas located in your data source. Select the relevant schema. You can find the schema easily by searching for it through the search field at the top of the list to filter the schemas displayed. After selecting the schema, a list of the available tables and views are displayed.
- Select a table or view. You can find the table easily by searching for it through the search field at the top of the list to filter the tables displayed.
- Click Done. The table is added to the model.
See Publishing Live Models for information on how to publish the model and begin creating visualizations with it.
- Performing a top/bottom ranking filter on widgets requires version 8 or higher of the live connected MYSQL database. As a workaround for this you can import your data into the ElastiCube.