Creating a MySQL DataSource

Use the Sources Manager 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)

You can create DataViews from multiple files under the same Text File DataSource. 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