Add Custom Scripts to Components
Users can now add custom scripts to components. For example, add indexes or update statistics using t-sql scripts. Built components will include the provided custom
Quick Review–ACID
One of the foundation concepts that all database workers should keep in the back (or maybe front) of their mind is ACID. This small and
Bulk Profile Upload
LeapFrogBI is a SaaS metadata driven ETL platform. At no time does LeapFrogBI connect directly to either the source or the destination systems. Therefore, the first
Fact Record Delete Component
The new f9001 component automates deletion of records from a fact table. Simply select the fact table to effect and a source to inner join
Stage Using REST API as Data Source
There is a wealth of data available via REST API much of which is publicly available. LeapFrogBI simplifies and automates the process of extracting data from
LeapFrogBI Success Story
I get asked on occasion to quantify the efficiency that the LeapFrogBI data warehouse automation platform offers. Below are a few measures that were collected
Before Development Begins…
It probably goes without saying that BI and data warehouse projects can be very complex. Taking a bottom up & agile approach breaks the larger
Multiple File Stage Made Simple
The Multi-File Stage s9600 template provides a simple method to stage many files with the same structure. The following steps describe how to setup this component.
FTP File/s Stage – s9500
The FTP File Stage s9500 template provides a simple method to collect one or more files from an FTP server. The following steps describe how to
Working With Data Sources That Do Not Track Changes
Data sources come in all shapes and sizes. Some include all of the features needed to easily integrate into load processes. Others can cause all