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
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
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.
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
[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 210: Example SQL Database
subscriber_id | service_type | street_address |
|---|---|---|
1234 | basic | 10 Main Street |
6889 | premium | 15 School Street |