Contents | Search

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

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!