Why don't MySQL column aliases show up for my data sources?
The column aliases are not showing up for your database tables, the actual column names are appearing.
Effective MySQL connector 5.1.x release, the behavior for ResultSetMetaData.getColumnName() was changed to return the actual column name rather than an alias.
The simple solution is to add an optional JDBC driver property on the Data Source screen.
MYSQL article for this topic: http://dev.mysql.com/doc/connector-j/en/connector-j-installing-upgrading-5-1.html
- iDashboards Enterprise Suite
- iDashboards Private Cloud