You select the grain (Year, Quarter, Month, Day, Hour, Minute), the start and end date, and whether or not to use a smart key as the surrogate. You can even use relative dates to help with situations where you want
We have all seen the job postings. “Immediate hire… ETL developer with 10 years’ experience.” Regardless of fast changing technologies there will be a need for data integration for the foreseeable future. Even the largest of big data repositories can’t
Some of the most challenging data warehousing situations come in the form of external data mashups. Because the term “data mashup” has taken on a number of meanings over the past few years, I’ll clarify how the term is used
The LeapFrogBI platform is constantly being improved thanks largely to user feedback. Here’s a quick recap of the top 10 enhancements of 2014 that you don’t want to miss!
You will soon notice that your builds are completing
Have you ever had the need to rollback your project to a point prior to the last load process? Well, it is easier than ever to do so with the Snapshot Rollback feature. Turn the feature on, and always know
LeapFrogBI streamlines the creation, maintenance and sharing of a data dictionary. Simply provide a text description for components and fields online, and the rest is automated!
Component and field descriptions will be stored in the target database as extended properties.
SQL Server 2014 has arrived with a very nice set of new functionality. LeapFrogBI projects can now be deployed to SQL Server 2014 by simply selecting your target platform. Already have a project set to deploy to an earlier version
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
LeapFrogBI’s out of the box reporting just got better. Precedence reports make load execution monitoring available to anyone with a web browser. Jump straight to job history and get details on any process. No coding required. Be sure to deploy
Several LeapFrogBI processes use Excel to define configuration details such as FTP, HTTP, and MFS. In some versions of windows, the Excel application is set to execute as the “Launching User”. This causes a problem when using SQL Server Agent