Skip to Content

Did you know that you can migrate existing projects in SAP Event Stream Processor to SAP HANA Smart Data Streaming? The process depends on which version of ESP your project was created in.

ESP 5.1 SP08 and Earlier

The ESP datatypes Date and Timestamp have been renamed to SecondDate and MsDate in streaming. If you try to run ESP datatypes in streaming, you’ll get a runtime error.

You can easily convert all of these dataypes using the streamingmigratedatetypes command-line tool found in STREAMING_HOME/bin/.

Run streamingmigratedatetypes on each of your ESP SP08 and earlier CCL project files:

STREAMING_HOME/bin/streamingmigratedatetypes -i <old-project>.ccl -o <new-project>.ccl

-i <old-project> is the old CCL file to be migrated.

-o <new-project> is an updated name for the migrated CCL file. If you don’t provide a file name for this parameter, the utility will just output the results onscreen without creating a file.

Proofread

After running the utility, make sure to carefully inspect your CCL files for any fields that have not been updated correctly, especially if the variables and fields have the same name. See the datatype tables for a full list of changes.

Custom Adapters

If you have custom adapters created with the adapter toolkit, make sure you change all DateFormat and TimestampFormat tags to SecondDateFormat and MsDateFormat, respectively.

Update Adapter Filepaths

Smart data streaming uses a sandboxed environment, so you’ll have to update the paths to any file adapters you have in use. File paths are relative to the adapters directory:

/hana/data_streaming/<SID>/adapters/<workspace>/


Note that if you need to run discovery, the filepath must be absolute.


ESP 5.1 SP09 and Later

Migrating from ESP 5.1 SP09 and later to streaming is simpler.

Update Adapter Filepaths

Since smart data streaming uses a sandboxed environment, you’ll have to update the paths to any file adapters you have in use, just like for SP08 and earlier. File paths are relative to the adapters directory:

/hana/data_streaming/<SID>/adapters/<workspace>/


Note that if you need to run discovery, the filepath must be absolute.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply