Help us improve your experience.

Let us know what you think.

Do you have time for a two-minute survey?

Navigation  Back up to About Overview 
  
[+] Expand All
[-] Collapse All

Using SQL Accessors

This section explains the following:

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

gsmmap.gen file (Oracle or JDBC)
[SQLDatabase]
ModuleType=Database
DatabaseAccessorMethodName=SQL Accessor
KeyForAuthorization=MSISDN
gsmmap.gen file (LDAP)
[LDAPDatabase]
ModuleType=Database
DatabaseAccessorMethodName=LDAP Accessor
KeyForAuthorization=MSISDN

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

Oracle Example: sqlaccessor.gen file

[Settings]
MethodName=SQL Accessor
Connect=my_user_name/password@servicename
SQL=SELECT service_type FROM table1 WHERE subscriber_id=@KeyToRecord

JDBC Example: sqlaccessor_jdbc.gen file

[Settings]
MethodName=SQL Accessor
Driver=com/provider/jdbc/sqlserver/SQLServerDriver
ConnectDelimiter=;
Connect=DSN=jdbc:provider:driver1:dsn_name;UID=db_username;PWD=db_password
SQL=SELECT service_type FROM table1 WHERE subscriber_id=@KeyToRecord

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 218: Example SQL Database

subscriber_id

service_type

street_address

1234

basic

10 Main Street

6889

premium

15 School Street

Modified: 2017-09-27