MySql or protocol-compatible database (MariaDB, MemSql) can be used as a data source with SQL database connector. Tabular data schema can be determined by table name or custom SQL query or defined manually, and then you can build real-time reports (pivot tables, charts, datagrids) and perform ad-hoc queries to your MySql database with simple UI, without need to write an SQL.
There are no any limitations on the dataset size, but your MySql should be able to execute aggregate queries fast enough (in seconds; 2 minutes max). This is not a problem in case of small tables; for large datasets database filters may be applied to reduce data for the aggregation, or you may use pre-aggregated tables, or mirror your data to specialized analytical database like MemSql.
Connection String should be a valid connection string for MySqlConnector driver; for example:
The host name or network address of the MySQL Server to which to connect. Multiple hosts can be specified in a comma-delimited list.
Do not use "localhost" or LAN server name; use public IP address or server's domain name.
|Database||The case-sensitive name of the database to use.|
|Uid||The MySQL user ID.|
|Pwd||The password for the MySQL user.|