Ozeki NG SMS Gateway logo OZEKI NG SMS Gateway
"The World's most reliable SMS gateway software!"
info@ozeki.hu
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

MySQL table layout Contents | SearchMSSQL table layout

Home > Product Manual > User Guide > Configuration > SQL logging > Oracle table layout

SMS Gateway SMS Gateway Home

  Product Manual
  Introduction
  SMS technology
  Installation Guide
  User Guide
  Quick Start Guide
  User Interface
  Configuration
  Inbound Routing
  Outbound routing
  SQL logging
  MySQL table layout
  Oracle table layout
  MSSQL table layout
  SQL templates
  SQL log tracking
  Keywords
  Advanced traffic queries
  Source routing
  Sender address
  Content manipulation
  Charset handling
  List Management
  Client software
  Administrator's guide
  Developers Guide
  Examples and Solutions
  Appendix
  FAQ
  Feature list
  Commercial Information
  Search
 


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.

SQL Reporting in Ozeki NG SMS Gateway - Database layout (Oracle)

This page gives you the database connection information and the database layout if you want to setup SQL reporting in an Oracle database server. SQL reporting makes it possible to keep track of all incoming and outgoing messages in the system regardless of who sent it.

To be able to send and receive SMS messages from Oracle 11G XE first you need to create two database tables: "ozekimessagein" and "ozekimessageout". You can find the instructions on this process on this page. The SMS gateway will use SQL queries for sending messages.

Ozeki NG SMS Gateway needs to be connected to the mobile network. You can do this in two ways: you can attach a GSM modem to the PC with a datacable (GSM connectivity) or the SMS gateway can connect directly to the SMS center of the mobile service provider over the Internet (IP SMS connectivity).

You can configure Ozeki NG SMS Gateway with the help of the Graphical User Interface (GUI).

Configuration steps

To configure your SMS system first you need to install Oracle 11G XE to your computer. Then log into it on the web interface (Figure 1).


Figure 1 - Login

Click on SQL button (Figure 2).


Figure 2 - SQL button

Select SQL commands button (Figure 3).


Figure 3 - SQL commands

Now specify SQL commands. Enter the statements below to create the table layouts. Please click on Run after each command (Figure 4).


Figure 4 - SQL commands

CREATE TABLE outbox (
  id int,
  username varchar(30) default NULL,
  msgtype varchar(160) default NULL,
  msgid varchar(60) default NULL,
  callbackid varchar(255) default NULL,
  sender varchar(30) default NULL,
  receiver varchar(30) default NULL,
  msgsubject varchar(1024) default NULL,
  msgdata varchar(1024) default NULL,
  acceptedfordeliverytime varchar(100) default NULL,
  deliveredtonetworktime varchar(100) default NULL,
  deliveredtohandsettime varchar(100) default NULL,
  operator varchar(30) default NULL,
  route varchar(30) default NULL,
  status varchar(130) default NULL,
  errormessage varchar(1024) default NULL,
  cost varchar(10) default NULL
 )
 
 
CREATE index index_id1 ON outbox(id)
 
 
CREATE SEQUENCE X
 
 
CREATE TRIGGER outbox_auto BEFORE INSERT on outbox
for each row
when (new.id is null)
begin
   SELECT x.nextval INTO :new.id FROM DUAL;
 
 
CREATE TABLE  inbox (
  id int,
  username varchar(30) default NULL,
  msgtype varchar(160) default NULL,
  msgid varchar(60) default NULL,
  sender varchar(30) default NULL,
  receiver varchar(30) default NULL,
  msgsubject varchar(1024) default NULL,
  msgdata varchar(1024) default NULL,
  senttime varchar(100) default NULL,
  receivedtime varchar(100) default NULL,
  operator varchar(30) default NULL
);
 
 
CREATE index index_id2 ON inbox(id)
 
 
CREATE SEQUENCE Y
 
 
CREATE TRIGGER inbox_auto BEFORE INSERT on inbox
  for each row
  when (new.id is null)
  begin
   SELECT y.nextval INTO :new.id FROM DUAL;

In Ozeki NG SMS Gateway go to Server preferences in Edit menu. On Databases tab check Enable SQL logging checkbox (Figure 5). Then select the Database connection type and specify the Database connection string:

The database connection type, you should select is:

OleDb

The database connection string you should use is:

Provider=OraOLEDB.Oracle.1;Persist Security Info=False;User ID=admin;Password=qwe123


Figure 5 - Databases tab in Ozeki NG

If you have any questions please contact us at info@ozekisms.com!





Next page: MSSQL table layout
Copyright © 2000- - Ozeki Ltd | info@ozeki.hu
Home > Product Manual > User Guide > Configuration > SQL logging > Oracle table layout
Legal | Privacy policy | Terms of use
Page: 2725 | Login | 35.175.200.4