Paul te Braak


Paul te Braak is the principle consultant of abaX Data and has over a decade of experience in delivering reporting and business intelligence solutions across a variety of verticals.  This experience includes systems auditing, planning and business simulation models that predict activity through heuristic rules imbedded into the model.  He holds several qualifications including MCT, CA, MIT, MComm.

http://www.paultebraak.wordpress.com http://paultebraak.wordpress.com/feed/

Blog posts RSS

BIML VII – Extracting Data Using ODBC Destinations 27 Nov 2014
In previous posts we looked at using Biml to extract data from our database tables to flat files and raw files. While these destinations can be handy, the majority of extracts that I use are to staging tables in a relational engine. This post looks at the Biml required to send our data to ODBC ...

BIML VI – Using Include to Separate BIML Components into Files 26 Nov 2014
In a previous post, we looked at using the XML clause in SQL Server to generate Biml’s XML. The basis of that post was that our package had a pro forma template and we could just substitute code into placeholders. For example, the foundation snippet (below) could just be used and we could ...

BIML V – Precedence Constraints 24 Nov 2014
In prior posts, precedence constraints have been managed through the package setting for ConstraintMode. This assumes either a parallel execution (ie ConstraintMode=“Parallel“) or sequential execution (ie ConstraintMode=“Linear“). The ConstraintMode is a mandatory property ...

BIML IV– Extracting All Tables to Raw Files 10 Nov 2014
Perhaps the first task of any (DW/ DM) project is to extract data – after all it’s the E in the ETL isn’t it? I know there’s a lot more that goes on here but it’s the most boring job I can think of doing and one which inevitably has to be done. In a […]

BIML III – Extracting Database Tables to Raw Files 09 Nov 2014
In a previous post, we looked at extracting a table to a flat file. Personally, I am not a huge fan of flat file output because you lose so much metadata when a table with all its data types are dumped into text. To preserve this information, I would much rather use a raw file […]