Guide for SQL developers

This paper provides information for software developers about how to configure an SQL-SMS connection in the Ozeki NG Gateway to send and receive SMS messages using a database server (All major database servers are supported: Oracle, MSSQL, MySQL, Sybase, Informatix, etc.) If you set up this functionality, you will be able to send an SMS message by simply executing an SQL Insert statement in your database server. This paper gives you all the necessary information to achieve this. You can learn how to add an SQL user in the configuration file and how to configure sending and receiving. We also provide links to explanations of different database server connection settings.

The Ozeki NG SMS Gateway supports database connectivity. Database connectivity allows you to send or receive SMS messages using simple SQL queries. The way this works is illustrated in Figure 1.

If you want to send and receive SMS messages through a database server, you need an SQL type user in the OZEKI NG SMS Gateway.

The SQL user is a virtual user in the SMS Gateway that can communicate with a specified SQL server. The Ozeki NG SMS Gateway supports Oracle, MS SQL, MySql, Postgres, Sybase and any other relation database server that has an ADO or an ODBC driver.

To add an SQL user, you have to configure database connectivity. To do this, you need to specify the SQL user directives and include the insert scripts in the configuration file.

Download Guide for SQL developers

Related PDF Manuals Guide:
Oracle TimesTen In-Memory Database SQL Reference Guide
SQL Server 2005 Installation and Configuration Guide
Oracle Database Listener Security Guide
SAP Security Guide: MySQL MaxDB
Tutorial for MySQL An Introduction to Java Programming
Microsoft SQL Server Performance Auditing User’s Guide
Oracle Database Upgrade Guide
Oracle HTML DB Installation Guide