Creating a MySQL DataSource

Use the Projects Tree or the Project Configuration dialogue to Create or Edit a new MySQL DataSource.

Configuring the MySQL DataSource

To setup a MySQL DataSource:

• Enter the Server Name\Instance Name (or IP Address,Port)
• Enter your Login and Password
• Enter the name of the Database to connect to or open the drop down menu and select the Database from the available list. The list is refreshed when the drop down first opens if the server and login information provided is correct

Configuring the MySQL DataView(s)

DataView have standard and custom configurations areas. This section describes how to setup SQL DataView custom area. Refer to the standard section for information about setting up Parameters, Data Pivot or Calculated Columns.

To create a new DataView, from the DataSource Configuration dialogue click the New DataView button. Refer to the section Configuring a DataView for more ways to create and edit DataViews.

To configure a MySQL DataView:

• Enter a view Name
• Type the SQL query to run on the database (ensure the syntax matches that supported by the version of MySQL that is installed on the server). Cross your fingers and press OK