Administrator

Configuring SQL Back-end Connections for Agentry Applications

The first time you publish an application from Agentry Editor, the publication process creates initial back-end configuration information, which you must modify using Management Cockpit. Before modifying the configuration information for a SQL database back-end connection, you need to research and gather information about the database.

Prerequisites

  • Obtain and record the back-end identifier of the SQL database system connection. This is the name or number defined in the Agentry Editor.
  • Obtain or create the user ID and password to be used to connect SAP Mobile Platform Server to the database system.
  • Obtain information about, or create and configure the necessary connection settings on the host system for, SAP Mobile Platform Server application. This may be the System Data Source Name within ODBC for a SQL Server database, or the Local Net Service Name for an Oracle database.
  • Determine whether to authenticate users during synchronization via security information provided by the database.

Context

After modifying the configuration information in Management Cockpit, you may need to perform additional configuration tasks. Certain tasks may or may not pertain to a particular implementation environment and you should perform a careful review of the application’s requirements and functionality before proceeding.

Procedure

  1. In Management Cockpit, select Start of the navigation path Applications Next navigation step  Next navigation step Configure Next navigation step Back End End of the navigation path.
  2. Under SQL-<n>, edit SQL-related settings. These configuration options are for a single SQL database system connection, and control the connection behavior between the server and a database system. There may be multiple SQL-<n> sections within the Agentry.ini file. There must be one such section for each SQL database system connection definition within the application. Replace the <n> portion of the section name with the ID value generated by the Agentry Editor for the system connection definition.
    Definitions Values Descriptions
    Allow User to Change Password Boolean value of true or false. Default: true. Whether users can change expiring passwords on the client. If Enable Authentication is false, this setting has no affect.
    Database Connection Name Text value with valid system connection name. Default: none. The TNS name (Oracle) or ODBC DSN name (such as SQL Server, or any kind of database using an ODBC driver) the server uses to connect with the database.
    Database Connection Password Text value with valid password. Default: set by installer. The password for the user ID.
    Database Connection Type Oracle or ODBC. Default: set by installer. Whether the server is connecting to the database using an ODBC or Oracle Net Service Name.
    Database Connection User ID Text value with valid user ID. The user ID the server uses to log in to the database.
    Disconnect from Database Boolean value of true or false. Default: false. Whether the server should disconnect from the database at the time specified in Disconnect Time. The value is set to true when the database performs periodic batch or other processing, and when such processing dictates that no connections should be made to the database system.
    Disconnect Time 24-hour clock value in hours and minutes. Default: 2:30. A specified time when the server disconnects from the database. This setting has no effect if Disconnect from Database is false.
    Enable Authentication Boolean value of true or false. Default: true. Whether users are authenticated against the back-end system for this system connection. At least one system connection within the application must perform user authentication.
    Enable Previous User Authentication Boolean value of true or false. Default: true. Whether previous users are authenticated against the back-end system for this system connection. This authentication occurs when a user change occurs on the client.
    Name Text value. Default: null. Any text value used to identify the system connection in log files and other areas. This should be set to a unique value.
    Prefetch Rows 1000 Number of rows to retrieve in a single batch from a database query (can be used to optimize speed).
    Query Constant File Valid file name or path and file name. Default: none. Name and location of the query constants file, relative to the server. The default for this setting depends on the type of database selected during installation:Oracle_sd.ini or SqlServer_sd.ini.
    Query Init File Valid file or path and file name to properly formatted query initialization file. Default: SqlBE.ini. Name and location for the query initialization file used by this system connection. The initialization file contains multiple sections related to various server events that use a database system connection. The file must contain all of these sections in the proper format.
    Reconnect Time 24-hour clock value in hours and minutes. Default: 4:00. The time at which the server reconnects to the database; it must be later than Disconnect Time. This setting has no effect if Disconnect from Database is false.
    Shared Connections Zero or positive integer value. Default: 0. Number of connections created by the server upon start-up. If greater than 0, a connection pool is created and data from a single client may be processed on any of these connections, including multiple different connections during a single transmission. If set to 0, each client transmission uses a single database connection from start to finish.
    Time Zone Name Valid time zone name. The time zone to which date and time values are converted when received from clients; or from which they are converted when sent to clients. This conversion is based on the application definitions. This setting is used only to specify a time zone that differs from the back-end system.
    User Database Authorization Connection Boolean value of true or false. Default: true. Whether the connection that authenticates the user is the same one that processes synchronization for that user. If false, the server uses a different connection.

Next Steps

If you must modify these files, make the changes to the configuration files in the development environment, not on SAP Mobile Platform Server, and publish a new ZIP file in Management Cockpit. Restart each server in the cluster to distribute the changes.
  • Make application-specific modifications to the SqlBe.ini configuration file.
  • Make application-specific additions or modifications to the query constants file, or create additional constants files.