This documentation page assumes that you already have a SeekTable account.

How to configure MySql data source

  1. Click on "Connect to Database" item at "Cubes" view, or just open this link (ensure that you're logged in).
  2. Select "SQL-compatible database" in Data Source Type selector: SQL database connection settings
  3. Switch Database Connector to "MySql, MariaDB, MemSQL" option.
  4. Fill all required fields:
    Cube Name
    short title that describes this data source
    Connection String
    Valid connection string for MySqlConnector driver. Example:
    Server=hostName;Port=3306;Database=db;Uid=user;Pwd=password;ConvertZeroDateTime=True;
    Select Query
    determines tabular data (columns) that can be used as dimensions or measures in a pivot table reports. In simplest case this might be something like SELECT * FROM some_table; you can specify more complex query of course (with JOINs, WHERE).
  5. Keep Infer dimensions and measures by columns checked (until you want to define dimensions and measures by yourself) and click on "Save" button.

If everything is fine you should see a new cube dashboard with the list of available dimensions. In case of connection error you'll see an orange box with the error message.

Dimensions setup

Dimension name should refer to the column returned by specified Select Query:

Cube dimensions form
Type
"Field": dimension value is a table column or result of SQL expression (provided as first "Parameter").
"Expression": custom formula that uses another dimensions as arguments (specified in "Parameters").
Name
Unique dimension identifier. For Type=Field this is column name specifier (possibly with table alias prefix).
Label
User-friendly dimension title displayed on UI (optional).
Format
Custom format string (.NET String.Format) for dimension values (optional). Examples:
  • for number values: ${0:0.##} → $10.25
  • for date values: {0:yyyy-MM-dd} → 2017-05-25
Parameters
For Type=Field: you can specify custom SQL expression for this dimension.
For Type=Expression: you can specify custom formula (1-st parameter) and dimension names for the arguments (2-nd, 3-rd etc parameter).