sisula, short for "simple substitution language", is a language for producing text output from XML input.
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
Example Added ToUniversalTime function. Jun 28, 2018
code
metadata Added some extra robustness in the case the same job is running twice. May 2, 2016
sisulets
.gitattributes
Example.bat
LICENSE
README.md Update README.md Sep 15, 2015
Sisulate.bat Added BIML generation code for anchor/attribute loading. Apr 28, 2017
Sisulator.js
biml.directive
format.directive Optional BULK INSERT with formatfile Nov 5, 2014
source.directive
target.directive Configurations are stored Oct 7, 2014
workflow.directive Configurations are stored Oct 7, 2014

README.md

sisula

sisula, short for "simple substitution language", is a language for producing text output from XML input.

The current version is built in JScript and should run using the Windows Scripting Host in any Windows version from the last decade. There are no special requirements or dependencies.

ETL

The ETL branch contains an SQL driven ELT framework for data warehouse automation. This framework can be used with SQL Server and is particularly useful for Anchor Modeling. There is a playlist of video tutorials on how to use it available here: https://www.youtube.com/playlist?list=PLG6-3kKEOyYlWEaEFzhcARtjqHU6zn1cH

Sisulator

The sisulator takes an XML file as input and converts this into a JSON-compatible object according to a mapping ruleset. It will then process a number of sisulets as specified in the given directive, which recieve the object as input. The sisulets are parsed and the sisula language substituted to JScript using regular expressions, after which the JScript is evaluated and the output stored.

History

sisula was introduced in Anchor Modeling in order to replace XSLT for producing text output, and a first JavaScript version of the Sisulator is built into its modeling tool. This version is derived from that work.