Data Warehouse Automation Platform Support
Getting Started Video Series
New to the LeapFrogBI Data Warehouse Automation (DWA) Platform? You are in the right place. Follow along with our sample project, and you will be ready to build your project in no time.
Knowledge Base
Our most recent content is listed below.
New Component – Execute Process
Need to execute a batch file? Visual Basic Script? EXE? You are in luck. Use the new s9502 (Execute Process) stage component to execute any
LeapFrogBI DWA Supports SQL Server 2017
Simple as that. LeapFrogBI Data Warehouse Automation now supports SQL Server 2017. Existing clients can upgrade their projects without writing a single line of code
Precedence Field “JobNotify” Legend
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.
Calculate Workbook
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
New Feature – Precedence Graphs
Users can now view a visual representation of functional constraints via the Precedence Graph option.
Easy Access To Recent History
At times it is useful to retrace your navigation steps within a project. Now you can.
FAQ
WHICH DATABASE ENGINES CAN LEAPFROGBI DEPLOY TO?
SQL Server 2008, 2008R2, 2012, 2014, 2016, 2017. The LeapFrogBI Platform uses the SQL Server relational engine, SQL Server Integration Services, SQL Server Reporting Services, and the SQL Server Agent. The platform creates SQL Server Integration Services packages which carry out the prescribed behavior.
MY DATA IS REALLY DIRTY. CAN THE LEAPFROGBI PLATFORM HELP?
Dirty data is something we are all too familiar with. There is no magic solution to cleaning up dirty data, but the platform can certainly help you get the most benefit out of your current data. Sometime exposing data issues is the first step to solving them.
Is My Data Source Supported?
A huge array of data sources are supported. If your data is structured and accessible via ODBC, OLEDB, flat file, Excel, or API, then the platform can consume it. There are too many data sources to list them all. Contact us if you have a unique data source you want to consume, and we will test it out for you.
My data is in the cloud. Can the platform Collect it?
There are many types of cloud data sources, and we have dealt with a large number of them. In short, yes, but exactly how is a question we cannot answer without learning more about your data source. There is nearly always a way to collect your source data if the application provider allows it. Contact us, and we will dig into the details with you.
Which Internet Browsers are Supported?
Any modern internet browser will work fine. IE, Edge, Firefox, Chrome, and Safari are all good options.
HOW DO I DOWNLOAD THE APP?
You don’t. The LeapFrogBI Platform is a software-as-a-service application. There is nothing to install. All you need is an internet connection and a browser. Isn’t SaaS awesome!
How can the LeapFrogBI Platform possibly accelerate my data solution development?
Every solution is unique yet every solution has common core requirements. The LeapFrogBI Platform automates things that we do all of the time such as stage, consolidate, and load dimensions. You need to know your data in order to tell the platform what it needs to do which is what makes the LeapFrogBI Platform a tool and you a human. The platform converts these requirements into metadata which can then be used to generate corresponding assets.
HOW DOES LEAPFROGBI CONNECT TO MY DATA SOURCE? DO I NEED TO OPEN A PORT?
The LeapFrogBI Platform never connects to your data source or your destination database. Your data never leaves your secure environment. Instead, the platform generates SSIS packages which you will download into your secure environment. Once these packages are executed they will connect to your data sources and the target database using the method you select when designing your solution.