Ozeki NG SMS Gateway logo OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"
info@ozekisms.com
Tel.: 00 36 52 532 731
SMS Gateway to send SMS via GSM modem or IP SMS connection Overview SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Quick start SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Download SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Manual SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection How to buy SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection FAQ SMS Gateway to send SMS via GSM modem or IP SMS connection SMS Gateway to send SMS via GSM modem or IP SMS connection Contact Us SMS Gateway to send SMS via GSM modem or IP SMS connection
OZEKI NG SMS Gateway - Product Guide

Birthday greeting - MySQL Contents | SearchInstant brochure - MMS autoreply

Home > Product Manual > Examples and Solutions > Birthday greeting - Oracle

SMS Gateway SMS Gateway Home

  Product Manual
  Introduction
  SMS technology
  Installation Guide
  User Guide
  Developers Guide
  Examples and Solutions
  Telephone networks
  SMS Pin game
  E-mail to SMS alert
  2 way SMS to Email gateway
  SMS Order System
  Least Cost Routing
  SMS Load Balancing
  Asterisk PBX SMS
  SQL SMS Gateway
  SMS Service Provider
  Service Provider
  SMS PIN code query
  SMS Counter game
  SMS newsgroup
  Distributed SMS
  SMS Menu
  Google maps
  Forwarding
  Birthday greeting - SQL Express
  Birthday greeting - MySQL
  Birthday greeting - Oracle
  Instant brochure - MMS autoreply
  Alphabet letter game
  SMS sport betting service
  E-mail about outgoing SMS messages
  SMS Information Menu
  Email to SMS feature
  Reminder example
  Bulk SMS Client
  Bulk SMS to a given phone number range
  Filtering phone numbers
  Ozeki Phone Sytem PBX SMS
  Autoreply voucher example
  Appendix
  FAQ
  Feature list
  Commercial Information
  Search
  Cookie policy
 


Automated phone calls?
Ozeki Phone System XE VoIP PBX software is an advanced PBX built for automated voice calls and 2 way SMS messaging. It has outstanding APIs for software developers. It can be used for:

Phone calls from SQL
Phone calls from HTTP
Voice and SMS applications

Callcenter developers
If you are working on telephone solutions, please check out the Ozeki VoIP SIP SDK.
It can be used to create VoIP client and server software.

Contact Us!
If you wish to get further information, do not hesitate to contact us!

E-mail: info@ozekisms.com

If you have a technical question, please submit a support request on-line.

Birthday greeting SMS service with Oracle and Ozeki NG SMS Gateway software

This page provides you detailed setup instructions on how to send birthday SMS greetings from Oracle database with Ozeki NG SMS Gateway.

First of all you need to configure Ozeki NG SMS Gateway software to be able to send SMS messages from your PC. You can find step-by-step guide at: Quick start guide. The Ozeki SMS software is able to connect to the mobile network either with a GSM modem connection or IP SMS connection.

After you have configured your Ozeki NG SMS Gateway software and you can also install a service provider connection to connect the SMS software to the mobile network, you need to configure your Oracle database. Please find the configuration guide at: How to send SMS from Oracle.

If you have configured your system you can start to setup the birthday greeting SMS service with Oracle and Ozeki NG SMS Gateway software.

Configuration guide

So it is assumed that you have already installed Ozeki NG SMS Gateway software and Oracle database with all its components.

These are the main steps of the configuration of birthday greeting SMS service:

  1. Start SQL Developer (it is a component of Oracle database)
  2. Create the connection to database
  3. Create database table
  4. Create a sequence to move the ID
  5. Create a trigger to move the ID
  6. Load data into the database
  7. Install and configure a Database user in Ozeki NG SMS Gateway

To configure birthday greeting SMS service, start SQL Developer program of Oracle database in Start menu.

Add a new connection to the database by right clicking on Connections and click on New Connection (Figure 1).


Figure 1 - Add new connection

Specify the parameters in the appeared window (Figure 2):
Connection Name: You can provide any name you wish (in our example it is "ozeki connection").
Username: the username you use to access to the database
Password: the password you use to access to the database

In SID field you need to enter the name that has been provided to the database when it is installed (installation name of the database).
Finally click on Connect.


Figure 2 - Specify parameters for connection

On Figure 3 you can see that the connection has been created.


Figure 3 - Created connection

Now create a database table. In the empty field you can type the SQL statements that will create the required database table (Figure 4). To execute the SQL query click on the green arrow.


Figure 4 - SQL statement

On Figure 5 you can see the created database table.


Figure 5 - Created table

Create a sequence to move the primary key (ID) of the table (Figure 6).


Figure 6 - Create a sequence

On Figure 7 you can see the created sequence.


Figure 7 - Created sequence

You also need to create a trigger (Figure 8). This trigger uses the created sequence and moves the primary key (ID) of the table.


Figure 8 - Create a trigger

You can see the created trigger (Figure 9).


Figure 9 - Created trigger

On Figure 10 you can also see the created trigger among the triggers of birthday table.


Figure 10 - Created trigger among the triggers of birthday table

Now you can enter data into the table (Figure 11) in the following way:

INSERT INTO birthday (customername, customerphone, birthdate) VALUES
('Elizabeth','+36301234567',DATE'2010-09-22');


Figure 11 - Enter data

Start Ozeki NG SMS Gateway service (Figure 12).


Figure 12 - Start Ozeki NG SMS Gateway

Log into Ozeki NG SMS Gateway (Figure 13).


Figure 13 - Login

Install a Database user by clicking on Add new user or application (Figure 14).


Figure 14 - Add new user or application

Select Database user interface and click on Install next to it (Figure 15).


Figure 15 - Install Database user

Provide a name for the Database user - in our example it is "birthday_dbuser" (Figure 16).


Figure 16 - Provide a name

Finally configure the installed Database user. On Database connection tab you need to specify the follows:
Connection string type: OleDb
Connection string:

Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=ozeki;Password=root;


Figure 17 - Configuration of Database user

On SQL for sending tab you also need to specify the SQL statements.

Polling tab on SQL for sending panel:

SELECT id, '', customerphone, CONCAT(CONCAT(CONCAT(CONCAT('Hello ',customername),
'! The day of your birthday is: '), birthdate), ' Congratulations!')
FROM birthday
WHERE (EXTRACT(MONTH FROM CURRENT_DATE)=EXTRACT(MONTH FROM birthdate))
AND (EXTRACT(DAY FROM CURRENT_DATE)=EXTRACT(DAY FROM birthdate))
AND ((lastnotified is null) or (not(EXTRACT(YEAR FROM CURRENT_DATE))=(EXTRACT(YEAR
FROM lastnotified))))


Figure 18 - Polling tab

Sending tab on SQL for sending panel:

UPDATE birthday SET status='sending', lastnotified=current_date WHERE id='$id'


Figure 19 - Sending tab

Sent tab on SQL for sending panel:

UPDATE birthday SET status='sent', lastnotified=current_date WHERE id='$id'


Figure 20 - Sent tab

Notsent tab on SQL for sending panel:

UPDATE birthday SET status='notsent', lastnotified=current_date WHERE id='$id'


Figure 21 - Not sent tab

Delivered tab on SQL for sending panel:

UPDATE birthday SET status='delivered', lastnotified=current_date WHERE id='$id'


Figure 22 - Delivered

Undelivered tab on SQL for sending panel:

UPDATE birthday SET status='undelivered', lastnotified=current_date WHERE id='$id'


Figure 23 - Undelivered

On Figure 24 you can see that Ozeki NG SMS Gateway has sent out the test messages after I followed the configuration steps above.


Figure 24 - Sent messages in Ozeki NG SMS Gateway

On Figure 25 you can also see that the status of the birthday greetings has also been modified to "sent" in the database.


Figure 25 - Status is sent

Dig deeper!
People who read this also read...

Quick start guide
GSM modem connection
IP SMS connection
Service provider connections
How to send SMS from Oracle
Birthday greeting - SQL Express
Birthday greeting - MySQL





Next page: Instant brochure - MMS autoreply
Copyright © 2000 - 2017 Ozeki Informatics Ltd.
All rights reserved

Software PBX for Windows | VoIP SDK   |   Legal information   |   Privacy policy   |   Terms of use
Please, address your inquiries to info@ozekisms.com