Ozeki Bulk Messenger

CSV | LDAP

How to connect to SQL database

Ozeki Bulk Messenger can be connected to an SQL database. It will load the contact list from the database. This is a good way to speed dial your SQL address books. In this guide we will show you how to connect the Ozeki Bulk Messenger software to an SQL database.

 insert into test (Name,PhoneNumber,EmailAddress,Age) values ('test1','12341243234','test@test.com','15'); 

 insert into test (Name,PhoneNumber,EmailAddress,Age) values ('test2','343434','test@test.com','51'); 

 insert into test (Name,PhoneNumber,EmailAddress,Age) values ('test3','25423434','test@test.com','18'); 

Step 1 - Create new address book

First you need to select 'Make an dddress book' in the Quick Start menu.

Figure 1 - Selecting 'Make an dddress book'

Step 2 - Create an SQL address book

On the next page click on the 'Create new Address book' button and select the 'Import' type.

Figure 2 - Import type address book

Figure 3 - Creating an SQL address book

Step 3 - Provide a name for your Address book

In the 'Address book name:' field you can give a name for your address book to make identification easier when adding more address books.

In the 'Database connection' section you can choose your existing database. If you have not learnt how to create a new database connection In Ozeki Bulk Messenger then you can do it here: Create a new database.

In the 'Query' field you can specify which data you would like to get from your database. You can specify other column names, however those will not appear on the 'Contacts' page.

Figure 4 - Providing addressbook details

Step 4 - Manage your contacts

Please click on the 'Contacts' button to see the details of your imported contacts.

If you click on the 'Refresh' button you can refresh your database.

WARNING: By clicking 'Refresh', the refreshing process will delete all your contacts and load the original contacts from your connected SQL database. If you edit a contact the new details will not be saved to the connected SQL database.

Figure 5 - Managing contacts

Here you can manage your imported contacts or add new ones. By clicking on the 'Details' button you can add or remove contact details and see the other table columns.

Figure 6 - Opening contact details

Here you can find the column names you specified when you created the address book.

Figure 7 - Contact details