Connecting to a MySQL database

  1. Install MySQL. In this example, MySQL Connector/J 5.1.23 is used.
  2. Add a new database driver.
    1. Open the Site Preferences dialog box and go to the Database Configurations tab.
    2. Click Configure Database Drivers and then Add to open the Add New Database Driver dialog box.
  3. In theAdd New Database Driver dialog box, specify:
    Driver Class: com.mysql.jdbc.Driver
    URL Format: jdbc:mysql://server:port3306/database?profileSQL=true
    Driver File Path: C:/Program Files/MySQL/MySQL Connector J/mysql-connector-java-5.1.23-bin.jar
    Note: Driver File Path is the location where you placed the JDBC driver file.
  4. Create a new database connection.
    1. Open the Site Preferences dialog box and go to the Database Configurations tab.
    2. Click New to open the Add New Database Connection dialog box.
    3. Specify:
      • mysql_sakiraConnection Name:
      • Database: mysql
      • ConnectionDatabase URL: jdbc:mysql://hostname:3306/sakila?profileSQL=true
      • User Name: root
      • Password: This is the root password.
      • Schema: sakira

        You must manually specify sakira or the name of the database to use.

  5. Update the Database Schema Configurator GUI.
    1. Open the Database Schema Configurator and open mysql_sakira.
    2. Specify:
      • Database Connection: mysql_sakila
      • Click Import and select one, some, or all of the tables.
      • Save the configuration.
  6. Configure a database: Inbound protocol
    1. Open the Network Configurator and configure a database -inbound thread protocol.
    2. Specify:
      • Database Connection: mysql_sakila
      • Table Schema: actor, or one of the imported tables.
      • Read Action: SQL Statement: SELECT * FROM sakila.actor;
      • Scope: Each row as a record
      • Max Row per Read:1000
      • Scheduling: Scan Interval: 30