Connecting to MySQL

Note: This topic describes how to import data using the online Sisense Web Application. To import data through the desktop ElastiCube Manager, click Connecting to MySQL Using the ElastiCube Manager.

Sisense enables easy and quick access to databases, tables and views contained with MySQL databases.

Note: For the list of connectors available on Linux, click here.

To import data from your MySQL database:

  1. In the Data page, open an ElastiCube or create a new ElastiCube.
  2. In the Model Editor, click . The Add Data dialog box is displayed.
  3. Click MySQL. The MySQL Connect area is displayed.
  4. Enter the following details:
  5. (Optional) Select Use SSL if you are connecting to an SSL server. Enter the relevant information to configure verification between the client and the MySQL server over SSL:
  6. Click . A list of tables in the database are displayed. All tables and views associated with the database will appear in a new window.
  7. From the Tables list, select the relevant table or view you want to work with. You can click next to the relevant table or view to see a preview of the data inside it. When you select the table or view, two new options are displayed at the bottom of the list, Import Relationships and Add Custom Import SQL.
  8. (Optional) By default, existing relationships between tables are automatically replicated in the ElastiCube. You can disable this by toggling the Import Relationships switch.
  9. (Optional) Click + to customize the data you want to import with SQL. See Importing Data with Custom Queries for more information.
  10. After you have selected all the relevant tables, click Done. The tables are added to your schema in Sisense.