Data Pipeline Keywords

Keywords are especially useful when configuring feeds in BPM Connect. They increase the portability and durability of your SQL code by eliminating the hard-coding of key surface area values. Use of keywords is especially useful when trying to make your code resilient to breakage in scenarios where feeds are being renamed and/or injected across instances.

Keyword support in the BPM Connect 114 Pack has been greatly enhanced and improved. Keywords now use a special character identifier of "!". This solves many of the problems of the original keyword functionality.

The following key words are supported across all tabs in the data pipeline ***

• !feed_name = This returns the name of the current feed
• !dst_apset = This returns the appset name as defined in the surface area of the feed
• !dst_app = This returns the application name as defined in the surface area of the feed
• !dst_srv = This returns the server name as defined in the surface area of the feed
• !stg_db = This returns the stage database name as defined in the surface area of the feed
• !stg_srv = This returns the stage server name as defined in the surface area of the feed
• !src_dsn = This returns the source DSN name defined in the surface area of the feed

The Step2-DataMap tab has some additional specialty key words that can be used:

• !currentpass = This returns the current pass table
• !firstpass = this returns the first pass of the data map
• !priorpass = this returns reference to the prior pass below the current pass
• !mapsource = This returns the source of the data map, usually the SRC table

*** NOTE: At time of this post, only Step1, Step2, and Step3 are supported. Future releases will incorporate the rest of the data pipeline tabs