Help us improve your experience.

Let us know what you think.

Do you have time for a two-minute survey?

Using SQL Accessors

 

This section explains the following:

Configuring gsmmap.gen for Key Field Identification

Configuring gsmmap.gen for Key Field Identification

The choice of IMSI or MSISDN as the key field is identified in the gsmmap.gen file with the KeyForAuthorization field. (KeyForAuthorization can be MSISDN or IMSI.) In the following examples, MSISDN is identified as the key field.

Examples

Examples

Configuring sqlaccessor.gen or sqlaccessor_jdbc.gen for Key Field Identification

Configuring sqlaccessor.gen or sqlaccessor_jdbc.gen for Key Field Identification

For SQL databases, the SELECT statement in the [Settings] section of the sqlaccessor.gen file or the sqlaccessor_jdbc.gen file identifies the database column name of the key field. In the following example, subscriber_id is identified as the column containing the key field.

Note

Oracle front-end applications are not supported on a Linux platform. The sqlaccessor.so and sqlaccessor.gen files are specific to Oracle plug-ins and must not be installed on a Linux platform. You must instead use the sqlaccessor_jdbc.gen file.

Examples

Examples

Oracle Example: sqlaccessor.gen file

JDBC Example: sqlaccessor_jdbc.gen file

The corresponding database must contain a column name (as specified in the SELECT statement) containing the key field. In the following example, the column name of subscriber_id contains MSISDN values that serve as record keys.

Table 211: Example SQL Database

subscriber_id

service_type

street_address

1234

basic

10 Main Street

6889

premium

15 School Street