Interactive CallBimlScript

Kevin Feasel

2017-07-10

Biml

Ben Weissman introduces a feature coming to BimlExpress:

So far, there wasn’t much you could do but either replicate a lot of logic, parse the XML returned, use countless annotations or have many many different versions of your callee.

All of these options aren’t too appealing, right?

But: help is here! In addition to the known CallBimlScript, you can now use: CallBimlScriptWithOutput! It allows you to make use of a dynamic object to be returned by the CallBimlScript (in addition to the Biml code) which effectively means: you can return any kind of information back to the caller.

I can see this being useful for debugging and for centralizing flow logic a little bit better.  Click through for a sample script.

Related Posts

Using Biml With Oracle

Shannon Lowder shows us that you can write Biml to connect to an Oracle database as well: Next, I wanted to build a package from Biml. A package that uses a connection to my Oracle instance.  Defining connections to Oracle in Biml is similar to every other connection you’ve ever defined in Biml (lines 3-12). […]

Read More

Grouping Sets Of Tables In Biml ETL Loads

Kevin Feasel

2017-09-11

Biml

Ben Weissman puts together clusters of tables for data loads: The table meta.containers could technically also be a temporary table. We’ve decided against that so you can see what’s happening behind the scenes. Let’s focus on the meta.tables table for now. It has three columns: – TableName – guess what we’ll store in there – […]

Read More

Categories

July 2017
MTWTFSS
« Jun Aug »
 12
3456789
10111213141516
17181920212223
24252627282930
31