- Ozeki 10
- Bulk Messenger
- Quick Start
- Online manual
- Product Information
- Address book
- Custom data
- Cluster Software
- Developer tools
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.
Below is a quick overview of how this solution works. First you need to create a database table: for example the "test" table in MS SQL.
CREATE TABLE test (
Once you have the configuration completed, you can insert records in the "test" database table using an SQL INSERT statement. Ozeki Bulk Messenger will read these records using an SQL SELECT statement and add them to your Address book.
insert into test (Name,PhoneNumber,EmailAddress,Age) values ('test1','12341243234','firstname.lastname@example.org','15');
insert into test (Name,PhoneNumber,EmailAddress,Age) values ('test2','343434','email@example.com','51');
insert into test (Name,PhoneNumber,EmailAddress,Age) values ('test3','25423434','firstname.lastname@example.org','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 bookThe please select the 'SQL' 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