The field [dbo].[Precedence].[JobNotify] in theÂ LeapFrogBIÂ console databaseÂ is used by the poll job to determine which email to send and when to send it.Â The package named â€œBI_Nofity.dtsxâ€ (step 2 of the poll agent job) consumes and sets these values.Â Here’s what the values represent.
When using several of the LeapFrogBI component types, configuration information is stored in Excel. This architecture is used in cases where it is not feasible to upload or input data into a web browser efficiently. Examples include; multi file stage, and rest API collection. Excel workbooks include the option to automatically “Calculate Workbook” when the […]
Data warehousing success depends on properly designed ETL. In this short video we walk though the foundation design pattern step-by-step.
LeapFrogBI provides developers a metadata driven approach for efficiently building a data warehouse using dimensional modeling design technique. Prior to beginning development a target dimensional model must be designed. The Dimensional Modeling Video Series provides viewers with the skills needed to successfully design an effective dimensional model.
After you deploy a LeapFrogBI project, you will need a way to monitor the load process. The LeapFrogBI monitoring solution provides monitoring and much more in the form of a pre-built SQL Server Reporting Services project. Like all other LeapFrogBI generated assets there is no post deployment dependency on LeapFrogBI. The monitoring solution may be […]
LeapFrogBI supports a number of physical architecture options. Developers can select an architecture and configure each project as desired. Keep in mind that LeapFrogBI creates in-database (ELT) processing whenever possible. This means the database engine will be doing the heavy lifting regardless of the location of SSIS and package execution. When selecting a target architecture strive […]
LeapFrogBI deploys to several target systems; SQL Sever 2008, SQL Server 2008R2, SQL Server 2012, and SQL Server 2014 (coming soon). Traditionally, migrating from one version of SQL Server to another meant that every package would need to be migrated which could be a very time consuming task. LeapFrogBI makes this process painless. Simply change the […]
One of the most powerful features that LeapFrogBI offers is the ability to visually describe a project in the form of an interactive graph. Users have the ability to view a project cross section, data model, or the entire project data flow with the click of a button. Best of all, these graphs are automatically […]
LeapFrogBI makes collecting data from an ODBC Data Source a simple process. Profile your source and stage your profiled data. Parameterize your profile query to setup dynamic extraction criteria. Lots of Options Both SQL Server 2008R2 and SQL Server 2012 LeapFrogBI projects provide ODBC support. SQL Server Integration Services 2008R2 offers ODBC connectivity through an […]
Data warehouses provide organizations with a knowledgebase that is relied upon by decision makers. ETL (extract, transform, load) is the process that is responsible for ensuring the data warehouse is reliable, accurate, and up to date. This post presents a design pattern that forms the foundation for ETL processes. What are the goals? Before jumping […]
LeapFrogBI projects include the option to enable automated notifications per lifecycle based on load process events; start, complete, and failure. To setup the solution simply navigate to the precedence page in the deploy menu, expand the Notification section, and fill out the configuration options. The precedence solution’s poll job controls the notification process by executing bi_notify.dtsx.
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 […]