This topic describes how to add a user-created MySQL data source.

Prerequisites

  • The database that you use as a data source is accessible from the Internet. If you want to deploy Quick BI on a private cloud, consult technical support personnel.
  • A user-created MySQL database is created.
  • The username and password that you use to access the user-created MySQL database are obtained.
  • The AccessKey ID and AccessKey secret used for authentication are obtained.

Background information

Quick BI Enterprise Standard allows you to access user-created data sources in group workspaces over SSH tunnels. This access mode is not supported for Quick BI of other editions.

Enable the firewall

You can access a MySQL database only after the firewall is enabled.

  1. Run the following command to open the configuration file of the firewall:
    vi /etc/sysconfig/iptables
  2. Add the following command to the configuration file:
    -A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dport 3306 -j ACCEPT
  3. Restart the iptables service after the configuration is complete.
    service iptables restart

Add a user-created MySQL data source

  1. Click the Workspace tab. In the left-side navigation pane, click Data Sources.
  2. On the Data Sources page, click Create Data Source in the upper-right corner.
  3. In the Add Data Source dialog box, click the User-created Data Sources tab and then the MySQL card.
    Add MySQL Database
  4. In the Add MySQL Database dialog box, configure the required parameters.
    Configure the data source
    Parameter Description
    Name The name of the data source. In this example, set the value to user-created data source MySQL.
    Database Address The IP Address of the database that is used as the data source.
    Port Number The port that you use to access the database. Default value: 3306.
    Database The name of the database that you want to access. In this example, set the value to mysql.
    Username The username that you use to access the database. In this example, set the value to root.
    Password The password that you use to access the database.
    User-created ECS Data Source (VPC) Optional.
    AccessKey ID The AccessKey ID that you use to purchase the instance where the database resides.
    Note This parameter appears only when you select the User-created ECS Data Source (VPC) option.
    AccessKey Secret The AccessKey secret that you use to purchase the instance where the database resides.
    Note This parameter appears only when you select the User-created ECS Data Source (VPC) option.
    Instance ID The ID of the instance.
    Note This parameter appears only when you select the User-created ECS Data Source (VPC) option.
    ECS Instance Region The region where the instance resides.
    Note This parameter appears only when you select the User-created ECS Data Source (VPC) option.
    ssh Optional.
    SSH Host The hostname or IP address of the SSH host.
    Note This parameter appears only when you select the ssh option.
    SSH Username The username that you use to access the SSH host.
    Note This parameter appears only when you select the ssh option.
    SSH Password The password that you use to access the SSH host.
    Note This parameter appears only when you select the ssh option.
    SSH Port Number The port that you use to access the SSH host. Default value: 22.
    Note This parameter appears only when you select the ssh option.
  5. Click Test Connection to test connectivity with the database.
    Test connectivity
  6. After the database passes the connectivity test, click Add.