Stream URI aliases simplify specifying URI connections to Sybase CEP data streams. A stream URI alias is an alternate name used in the RTD function call instead of the full stream URI path.
The URI alias also enables you to define authentication parameters (user name and password) with each URI alias, thereby eliminating the need to specify the authentication parameters in each Excel formula using the RTD function call.
Note: The passwords are fully encrypted and hidden by the URI Alias utility for security purposes.
To run the URI Alias connection manager utility, do the following:
• Open the folder where you installed the Sybase CEP RTD Adapter for Excel.
• Run the application: rtdcfg.exe.
To create a new RTD connection alias, click the New button. You are then prompted to enter the following connection settings:
• Connection Id: This is the name you give the connection alias. This is the name you use in the RTD function call to refer to the URI alias.
• Stream URI: This is the Sybase CEP URI representing the data stream. A stream URI typically takes the following form:
ccl://hostname:port/Stream/workspace-name/ project-name/stream-name
For example:
ccl://localhost:6789/Stream/Default/AlgorithmicTrading/ StreamSummary
See the section Connecting to Streams over a Network in the Sybase CEP Integration Guide for more information about how to specify Sybase CEP streams with URIs.
• User Name: This is the user name the back-end server uses to authenticate the connection. If user authentication on the Sybase CEP Server is not enabled, then you may leave this field empty. Please refer to the Sybase CEP Administration Guide for full information on how to enable and configure authentication with the Sybase CEP Server.
• Password: This is the password the back-end server uses to authenticate the connection. If user authentication on the Sybase CEP Server is not enabled, then you may leave this field empty. Please refer to the Sybase CEP Administration Guide for full information on how to enable and configure authentication with the Sybase CEP Server.
• Confirm Password: This is to confirm the user password specified above. This value must match the password that you entered in the previous field.
Note: The Password and Confirm Password fields are encrypted for security purposes.
To edit an existing RTD connection alias, highlight the connection you wish to edit and click the Edit button. Then you may change any of the connection settings as described above. Click OK to save the RTD connection alias settings, or Cancel to abort the changes.
To delete an RTD connection alias, highlight the connection you wish to delete and click the Delete button. You will be prompted to confirm the deletion. Click Yes to complete the deletion, or No to abort.