- Quick start guide
- System requirements
- Installation guide
- Mobile networks
- User guide
- Developers guide
- Service providers
- OZX server
- Short code
- SMPP client
- SMPP server
- User authentication
- Reporting database
- Report into SQL Txt
- Failed queries
- Multipart SMS
- Report MSSQL fast
- Powershell script
- Performance tuning
- SMS routing
- Sender ID
- Error detection
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