Setup Amazon SimpleDB
making and accepting
calls using a Database

In this chapter you can learn about how to make and accept calls using an Amazon SimpleDB database server with your Ozeki Phone System XE. In this guide you can get information about the installation steps, the database connection string, the database connection type and the database table layout for Amazon SimpleDB database server.

During the configuration you should choose the following database connection type:

Odbc

You should use the next database connection string:

Access Key=your_access_key;Secret Access Key=your_secret_access_key

The database connection string has to be modified to match your database.

The connection string and the connection type should be entered on the SQL OzML API configuration form.


Figure 5 - Specifying the connection string for the Amazon SimpleDB database

Figure 6 shows the SQL queries that will be used if there is an incoming call.


Figure 6 - SQL queries for making outgoing calls

Under the Incoming calls tab, you need to provide the SQL queries that will be used when there is an incoming call. Figure 7 shows the SQL query that you need to use.


Figure 7 - SQL queries for accepting incoming calls

After the OzML SQL API has been configured in the Ozeki Phone System XE, you need to create the database tables for OzML SQL API. Use the following table layout:

  • ozmlin table
Name Type
id int(10) (primary key, auto increment)
callerid varchar(40)
scriptid int(10)
duration int(10)
status varchar(40)
recordurl varchar(150)
starttime datetime
  • ozmlout table
Name Type
id int(10) (primary key, auto increment)
dialednumber varchar(40)
status varchar(40)
duration int(10)
scriptid int(10)
recordurl varchar(150)
starttime datetime
  • ozmlscript table
Name Type
scriptid int(10) (primary key, auto increment)
ozml varchar(10000)

If you have any questions or need assistance, please contact us at info@ozekiphone.com.

Dig deeper!
People who read this also read...

More information