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 script. By storing customization along with project metadata deployment, modifications, and ongoing maintenance are further simplified.
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 very important acronym describes the characteristics of a reliable transaction. wiki Atomicity – Transactions cannot be partially complete. Either the whole thing commits or nothing commits. This is true in […]
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 step in building a data mart is to provide metadata to LeaFrogBI in the form of a profile (SSIS package). This profile is then parsed and required information extracted. It […]
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 to the fact table. Apply any required filters and all matched records will be deleted from the target fact table.
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 these sources. Step 1: Create REST Stage Component s9501 will create a package which will collect REST API sourced data based on a configuration file’s definitions. Create a stage component […]
There is a wealth of data available via REST APIs much of which is publicly available. LeapFrogBI simplifies and automates the process of extracting data from these sources. Simply fill out a configuration file, build a stage component (s9501), and execute the LeapFrogBI created package. Stage Using Rest API
After deploying a LeapFrogBI solution, then next step is to execute the built components in the correct order. A solution which handles the required precedence conditions can now be downloaded directly from the deployment page. Precedence Solution
I get asked on occasion to quantify the efficiency that LeapFrogBI offers. Below are a few measures that were collected on a recently completed data mart project. Developers: 2 with some data warehousing experience LeapFrogBI Experience at Project Start: None Dimensions: 21 (11 exposed for reporting & 10 for ETL only) Fact Tables: 6 (1 […]