Oracle table layout
On this page you can see a connection to an Oracle database layout. You can use the CREATE TABLE statements in the examples below. Generate reports of all SQL queries. You can set this option in your SMS Gateway. SQL queries are generated by incoming and outgoing messages.
You can use almost every kind of database server to log messages. In this example the message flow can be logged by modifying your Oracle 11g database. All messages sent from and received by your Ozeki SMS Gateway will be logged.
Connect Ozeki SMS Gateway to the mobile network to send and receive SMS messages. You can use a GSM modem or a IP SMS connectivity. The most popular hardware option is a mobile phone or a GSM modem attached to your computer. Or you can use popular software options which connects through an IP SMS service provider over the internet. For example SMPP, CIMD2 or UCP/EMI are service provider connections.
How to configure your Oracle 11g server
Click the 'SQL workshop' button to manage the database server (Figure 2), which is a perfect choice for creating tables.
Select 'SQL commands' button (Figure 3), so you can provide any statement you wish.
Now you can simply provide the SQL statements, so you can CREATE the required tables. See how to create them on Figure 4, below. Copy and paste the codes as you can see on Figure 5. Please click 'Run' to execute the statements.Here you can find the statements to create your tables:
Paste the SQL statements and click 'Run' to create the tables (Figure 5).
Now please jump back to the browser GUI of Ozeki SMS Gateway, so you can provide the database connection string. Please modify the appropriate parameters to fit your Oracle Database (Figure 6).
Every modification of the tables will be logged by Ozeki SMS Gateway after you have set it similarly as you can see on Figure 7. Just select 'Edit/Server preferences' from the top menu and select 'Databases' tabpage and 'Logging database settings' sub-tabpage. Finally add the modified connection string. You can also modify SQL statements as well.