Ozeki 10 SMS Gateway
User authentication User authentication | Report into CSV Report into CSV

How to use a database to save all SMS messages

This guide explains how to setup a Microsoft SQL Database server to save all SMS messages going through the system. This setup makes it possible for you to create reports, write bills or to calculate the cost of operating your SMS gateway system.

Firstly open the Reporting from the Edit menu in the navigation bar (Figure 1).


Figure 1 - Open Reporting menu

In the Reporting menu click on the Create new SMS Reporter button and than select MS SQL type database (Figure 2).


Figure 2 - Create new MSSQL reporter

Now enter the connection details like Server, Port, Database, UserID and Password. And enter the Connection name. Finally click on the OK button (Figure 3).


Figure 3 - Specify connection details

In the Events tab you can see the logging of the latest server events. As you can see on the Figure 4 the database connection is established.


Figure 4 - Database connection established

On the Table layout tab you can find the corresponding query to ctreate the table for the reporting. Copy it from here (Figure 5).


Figure 5 - Copy table layout

On the SQL tab you can execute SQL queries in the database connection. Paste here the create table query and execute it (Figure 6).


Figure 6 - Execute create table query

From the Admin user you can send test SMS message. Provide the recipient address, the message and click on the OK button (Figure 7).


Figure 7 - Send test message

Finally in the MS SQL Reporter you can query the messages from the database and you will see there is a new message in the table (Figure 8).


Figure 8 - Query messages from database

 
Copyright © 2000- - Ozeki Ltd | info@ozeki.hu
Home > Service providers > Reporting database
Legal | Privacy | Terms of use | 62
34.232.51.240 | 92.118.27.157 | Login