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.
Some of our most recent content is listed below. Find exactly what you need by searching on key terms or browse the full library.
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.
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.