Adapter Configuration Settings

The adapter configuration settings are maintained inside the Windows Registry. The Sybase CEP RTD Adapter for Excel Registry key is located at HKEY_LOCAL_MACHINE\Software\C8\Excel\RTD. Decribes configuration parameter values you can set at this registry key, including BufferSize, DefaultStreamUri, LogFile, and LogLevel.

The Sybase CEP RTD Adapter for Excel Registry key is located:

For a 32-bit window, in

HKEY_LOCAL_MACHINE\Software\SybaseC8\Excel\RTD\

For a 64-bit window, in

HKEY_LOCAL_MACHINE\Software\Wow6432Node\SybaseC8\Excel\RTD\

Note: The Excel adapter only recognizes the registry key equivalent to win32 in all Windows platforms. Use regedit to edit the win64 registry key to make it the same as win32.

At this registry key, you can set and manage the following configuration parameter values:

• BufferSize: This is the maximum number of data stream output rows retained in the RTD adapter buffer. The default is to retain 100 rows.

• DefaultStreamUri: This is the default stream URI to use if none is specified in the RTD formula/function call.

• LogFile: Specifies the log file if logging is desired.

The default value is,

LogFile=%TEMP%\SybaseC8-Excel-RTD.log.

The global Window environment variable TEMP points to different locations on different platforms.

In a 32-bit Window,

%TEMP%= C:\Windows\Temp

In a 64-bit Window,

%TEMP%= C:\Windows\Temp\1

• LogLevel: Specifies the level of detail of the logging. Valid levels are OFF, FATAL, ERROR, WARN, INFO, DEBUG, ALL. For example, if the level is set to "WARN", then messages about warnings, errors, and fatal errors are logged. "Information" and "Debug" messages are not written to the log file. LogLevel is only useful if LogFile is set to specify a valid file name.

There is a second set of registry key values under the Key: StreamUriAlias. The value(s) of these keys represent aliases for Stream URIs, which you can reference in the RTD function call rather than specifying the full stream URI. The Sybase CEP RTD Adapter for Excel contains a separate utility (rtdcfg.exe) for specifying and managing these URI aliases. Manage the URI aliases from the utility program rather than editing the registry keys directly. Currently, rtdcfg.exe is only available in 32-bit Windows; it will support 64-bit Windows in R4.