MySQL
MySQL is a popular open-source relational database management system. With Lumenore’s MySQL Connector, you can retrieve data from your MySQL database and create custom reports. Simply specify the data you need by entering an SQL query. For more details about the MySQL API, visit their official site (http://dev.mysql.com/doc/refman/5.0/en/c-api.html).
Whitelisting
Before connecting to a MySQL database, you need to whitelist a set of IP addresses on your database server for the specific port you wish to use. To view the complete list of IP addresses, refer to Whitelisting IP Addresses for Database Connectors.
Steps to connect with MySQL Database
- Click Self Service.
- Click Lumenore Connect.
-
Click Create New.
-
Click MySQL.
-
Fill in the required information
- Click Test Connection.
-
Upon the successful connection, a success message screen will appear. Click Next.
-
Click the check box(es) to Select Tables.
- Click the check box(es) to select columns.
- Click preview.
- Click Next.
Note: Once you have chosen the tables needed to meet the KPI / Dashboard requirements, you can create the business model and dashboard. Instructions are available in the Self-Service section of the Lumenore User Manual.
