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.

1. From Management Cockpit, select Applications > Back End.
   
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.

• 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.

• Configuring the SqlBe.ini Query Initialization File for Agentry Applications
  After configuring the SQL database backend connections in Management Cockpit, you may need to make modifications to the SqlBe.ini configuration file. The SqlBe.ini is the default query initialization file that is provided by the server installer. You can modify the file for a single application, or use it as a template to create other query initialization files for applications that have multiple SQL database system connection types.
• Configuring Query Constant Files for Agentry Applications
  Query constant files are configuration files containing constant values that may be referenced by any SQL script run by SAP Mobile Platform Server. Each SQL database system connection can have its own query constant file.