This documentation page assumes that you already have a SeekTable account. You can create free account by signing up.

MySql connection for pivot table reports

MySql or protocol-compatible database (like MariaDB) can be used as a data source with SQL-compatible database connector.

Connection String should be a valid connection string for MySqlConnector driver; for example:

Server=hostName;Port=3306;Database=db;Uid=user;Pwd=password;ConvertZeroDateTime=True;
Server 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.
ConvertZeroDateTime if true ignore empty or zero date time values.
UseCompression if true compresses packets sent between SeekTable and MySql server (if the server supports compression).