Creating MySQL Data Connections

Prerequisites

• You have obtained the IP address and port number of the MySQL data source, and the username and password for logging in to the MySQL database. In addition, you must have the SELECT permission on the database to be connected.

Creating a MySQL Data Connection

1. Log in to the DLV console.
2. On the Data page, click the workspace drop-down list at the top of the page, select the workspace to be accessed, and click New Data Connection.
   Figure 1 Creating a data connection
   

3. In the New Data Connection dialog box, set Data Source Type to MySQL and set the related parameters.
   Figure 2 Creating a MySQL data connection
   

   Table 1 describes the MySQL data connection parameters.

   Table 1 MySQL data connection parameters

   Parameter	Description
   Name	Name of the data connection. Must contain 1 to 32 characters and contain only letters, digits, hyphens (-), and underscores (_).
   Domain Name	IP address of the database. Private zones are not supported.
   Port	Port of the database.
   Username	Username of the database. The database user must have permission to access data tables and metadata.
   Password	Password of the database user.
   Agent	Select an available connection agent.
   Database	You can select a database from the Database drop-down list.

4. Click OK.

Using MySQL Data Sources

You can configure and use the MySQL data source by referring to the instructions in Using DWS Data Sources.