Parameter

Description

Autobind

SAP MII Workbench connector parameter that passes parameters with the same names as the input parameters for the transaction to SAP MII and includes their values.

If you do not select this checkbox, you must assign input parameters to the standard parameter names using the Xacute Query template.

DatePrefix

Prefix to the start date and end date parameters in query templates used to format the date to match the database configuration.

If you are connecting to a Microsoft SQL server database, the typical prefix is a single quote. If you are connecting to an Oracle database, an example of a prefix is GetDate('.

DateSuffix

Suffix to the start date and end date parameters in query templates used to format the date to match the database configuration.

If you are connecting to a Microsoft SQL server database, the typical suffix is a single quote. If you are connecting to an Oracle database, an example of a suffix is ','MM/DD/YYYY HH24:MI:SS').

Description

Text field for additional information about the data server.

InitCommand

Command used by the database connector that is run when a connection pool is created.

You can use it to set the database locale in Oracle.

InternalDateFormat

Date format used to construct WHERE clause conditions. Controls the construction of the WHERE clause for date comparisons for specific databases and servers.

IP

Machine name or internet protocol (IP) address from where requests are made.

For a universal data connector (UDC), the IP is where the universal data server (UDS) is installed.

For an SAP MII connector, the IP is the machine name where the SAP MII is running. For anything running on the local machine, enter localhost.

JDBCDriver

Java Database Connectivity (JDBC) driver classpath used to connect to the server.

See JDBC Drivers.

Password

Password to connect to the database.

The password field shows six asterisks even if your password has more or less characters or is blank.

Passwords are not passed between browser clients and the database. The Servers.xml file is not accessible through the Web server.

PoolMax

Maximum number of connections the pool allocates.

If a request is received and all connections are in use and allocated, the query waits for an available connection or the specified timeout period.

PoolSize

Number of connections to be established with the database when the connection pool is initialized.

Port

Socket used for communication with the server.

For the UDC, the port is a direct socket communication and is the port that is configured in the agent definition.

For the SAP MII connector, it is the HTTP port on which SAP MII is listening (NetWeaver HTTP port).

Protocol

Protocol for URL requests for the server. It is used by SAP MII and proxy connectors and is defined as HTTP or HTTPS.

QueryTimeout

Length of time that elapses before a UDC and OLEDB connector request is terminated.

For example, if the QueryTimeout value is five seconds and it takes 10 seconds to retrieve the requested data, the query request is terminated.

ServerPackage

SAP MII Java class that is instantiated for the server.

Do not change this parameter.

ServerURL

Driver-specific string that defines how to access the database.

For example, with the Microsoft SQL Server 2000 JDBC driver, the ServerURL is: jdbc:inetdae://hammer9:1433?database=MyDatabase&sql7=true. The SQL server on machine hammer9 is connected to the MyDatabase database using TCP/IP port 1433.

For additional URL parameters, see the documentation from the vendor of the JDBC driver you are using.

SimulatorInstanceName

List of tags and their values used by the simulator to store configuration information.

TimeOut

Length of time (in minutes) that elapses before an unused connection expires and its resources are released back to the server. The connection pool maintains a minimum number of connections and, if necessary, creates a new connection.

UseCount

Number of times a connection can be used before it is terminated and its resources are released back to the server.

This parameter is only required for ODBC data sources that have resource leaks when they execute many statements.

User Name

Database-specific user ID.

ValidationQuery

Query used to determine if a database connection is valid.

For example, when using Microsoft SQL Server, you can use SELECT GETDATE() or SELECT * FROM Orders WHERE OrderId=-1.

The query does not have to return rows, but it must succeed.

WaitTime

Amount of time SAP MII waits for a connection before it fails.

Writable

Indicator used by the UDC and OLEDB connectors to determine whether you can update values in the server.