In the Sybase CEP Excel Adapter example worksheet, the RTD function calls are coded to use two URI connection aliases: "ATInTrades" and "ATSummary". You must create these URI connection aliases prior to running the Sybase CEP Excel Adapter example. Steps require you to start the Sybase CEP RTD Connection utility, create the two URI connection aliases using the New button, and configure the URI connection aliases.
In the Sybase CEP Excel Adapter example worksheet, the RTD function calls are coded to use two URI connection aliases: "ATInTrades" and "ATSummary". You must create these URI connection aliases prior to running the Sybase CEP Excel Adapter example.
1. Start the Sybase CEP RTD Connection utility (rtdcfg.exe).
2. Create these two URI connection aliases using the New button. If you have not configured authentication on the Sybase CEP Server, then the URI connection alias configurations are:
• Connection Id: ATInTrades
• Stream URI: ccl://hostname[:port]/Stream/workspace-name/AlgorithmicTrading/StreamInTrades
• Username: <leave blank>
• Connection Id: ATSummary
• Stream URI: ccl://hostname[:port]/Stream/workspace-name/AlgorithmicTrading/StreamSummary
• Username: <leave blank>
If you use the default Sybase CEP installation settings, and are running the Sybase CEP Excel Adapter example on the same machine as the Sybase CEP Server, the two URIs are:
ccl://localhost:6789/Stream/Default/AlgorithmicTrading/StreamInTrades
ccl://localhost:6789/Stream/Default/AlgorithmicTrading/StreamSummary
Please note that if you have enabled authentication to your Sybase CEP Server, then you need to add a username and password to the URI connection alias with the proper rights to read the streams from the AlgorithmicTrading example.