How to install an Autoreply Database User

Autoreply Database Users are the perfect solution for generating any message depending on the incoming message. These messages are generated from a database. Here you will see how to install and configure an Autoreply Database User from Ozeki SMS Gateway.

Start installing and configuring the Autoreply Database User by navigating to the 'Management' console. Click 'Add' on the top right corner of the right-side panel, which is called 'Users/Applications' (Figure 1). An alternative way is by clicking 'Users and applications/Add user or application' from the top menu bar.

click add button on the user/application panel
Figure 1 - Click 'Add' button on the 'Users/Applications' panel

The next page contains of two panels.

The left-hand panel consists of a list of already installed users and applications. While the right-side panel shows the possible users and applications you can install with a detailed description next to them. Please search Autoreply Database User and click the blue 'install' button (Figure 2).

click the blue install button next to the autoreply database user
Figure 2 - Click the blue 'install' button next to the Autoreply Database User

The installation is very simple, you just have to provide a unique username and click 'OK' (Figure 3).

provide a unique username for your autoreply database user
Figure 3 - Provide a unique username for your Autoreply Database User

On the 'Configuration' panel will find yourself on the 'General' tab page where you can use your Autoreply Database User exactly like an Autoreply Easy User. Leave the 'General' tab page unchanged and go to the 'Logging' tab page (Figure 4).

set the logging details on the logging tab and click ok
Figure 4 - Set the logging details on the 'Logging' tab and click 'Ok'

Navigate to the 'Advanced' tab to change the phone number and the login credentials of the Autoreply Database User. You can 'Allow routing table override' and 'Enable accounting for this user' in the lower sections. (Figure 5) Each user has account has a credit limit. One SMS is one credit.

look at the advanced tab for further options
Figure 5 - Look at the 'Advanced' tab for further options

By looking at the left side panel and clicking 'Database setup', you can connect Autoreply Database User to your database with a simple connection string (Figure 6). See how to build connection strings for each database driver. You can build up this connection to a wide variety of databases for example Microsoft SQL, Oracle, MySQL, Sybase, etc...

provide connection string of your database driver
Figure 6 - Provide connection string of your database driver

You should also set the path to your SQL query script as well. You can learn more about the structure of the script file as well and figure out that it is a simple txt file. The script file filters incoming messages and runs SELECT statements to generate outgoing message. (Figure 7) This is the basic and most important function of the Autoreply Database User.

provide location to your sql query script
Figure 7 - Provide location to your SQL query script

More information