Yes, you can.
The software can be configured to
to any database server that has an OleDb or ODBC driver. For example, you
can use MSSQL, Oracle, MySQL, Postgres, Access, etc., to store information
about sent and received messages.
If a message is received or sent by the SMS gateway, it will use an
SQL Insert statement to insert a new record into the database. The
SQL statement will contain the sender number, the recipient number,
the message text and the timestamp. You can configure this SQL statement
to include other fields, such as sending user, message type, etc.
The database that collects the traffic information can be used to make
various reports using SQL queries.
Yes, you can enable accounting and credit limits on the configuration
form of each user/application.
If you enable accounting for a
given user, you can define daily, weekly, monthly and yearly credit limits.
If this option is enabled, the user cannot send more then the number of
messages specified in the limit. The accounting feature will create a report
at the end of each month that shows how many messages were sent in that
month by the user.
The credit limit
handling feature is included in Ozeki NG - SMS Gateway v2.1.0. (and newer
It is handled the following way: every user has a configuration form that allows
accounting and credit limit settings. On the configuration form you select an
accounting period (daily, weekly, monthly, yearly, or all time) and you can
assign a credit limit for the given period. In addition to setting credit
limits, you can define costs for each message route. (for example, messages sent
through Vodafone can be configured to deduct 1.2 credits, and messages sent
through T-Mobile can be configured to deduct 1 credit from the balance of
the user.) On the user configuration form it is also possible to get usage
summary and usage details reports that show the traffic history of the user.
These reports can be used for invoicing.