Setting up JDBC Database Access for a MySQL Server

Voicent Communications offers the ability to go directly to a database and grab phone numbers, cell phone numbers, emails, first names, and last names. Allowing you to create a campaign almost instantly.

To set up this feature, open the software you purchased from us and navigate to the “Broadcast” -> “Select Database” option.

On the resulting form, input.

Connection String: jdbc:mysql://localhost/database_name

*Where database_name would be the name of your database

Driver: com.mysql.jdbc.Driver

Driver JAR file: C:\mysql-connector.jar

*Make sure this mysql-connector is correct for the MySQL version you are using

User: username
Password: password
SQL Statement
select first_name, last_name, phone, id from contacts where already_called=0
Name of Phone Column: phone_number

*Where phone_number is the name of the phone column

ID Column: ID
First Name Column: first_name
Last Name Column: last_name
Name Column: full_name

*Make sure that the columns you enter are valid MySQL columns and that the phone column is not empty as that is the only required field.