Nearly all data warehouses include at least one date dimension. LeapFrogBI makes generating this important dimension extremely easy while also offering a number of time saving features such as auto dimension growth & common attribute generation. Stop wasting time creating custom scripts, and let LeapFrogBI do all of the repetitive busy work. Simple select the […]
PSA serves a vital role. However, there are also cases when we want to build something as fast as possible without worrying about a consolidation area. In this case you can create a transform that is sourced from a stage component directly. Keep in mind that PSA also serves as the place where RecordTime is […]
Monitoring a data integration process can be a time consuming task. With the new automated notification system email notifications can be sent to alert administrators of load events. A flexible configuration definition and one click deployment makes setup a cinch.
User feedback on the new interactive graph feature has been extremely positive. By popular demand, interactive graphs are now also available in component details! Also, the component selection console has been added making it extremely easily to navigate between components without exiting the details context.
LeapFrogBI now offers project navigation via interactive graph visualizations! Simply go to any component and you will be presented with a graph representing the upstream and downstream components related to the selected components. Want more detail? No problem – check the “Extended Map” option and the graph will display all related components recursively. Still not enough? […]
ETL often get so complex it is difficult to grasps all of the steps & relationships. LeapFrogBI will now autogenetic interactive component graph feature. You can easily view your project data flow and dimensional model at the click a button. Never get lost in your ETL again!
Monitoring and updating project builds just got a lot faster. Projects containing 100+ components will notice a 10 x’s or more speed improvement when navigating to the deployment page. Build storage is increased from 30 day to 90 days. These two features combined make building and deploying projects faster than ever! https://leapfrogbi.zendesk.com/entries/22794591-enhancement-build-storage-deployment-page-improvements
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.
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 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
LeapFrogBI packaged solutions solve common data integration needs by providing ready to deploy projects. Our first solutions offers organizations a weather data mart based on NOAA global summary of the day data. More packaged solutions are coming soon.