If you are working with spatial data types, then it won’t be long before you learn that SSIS does not directly support geography or geometry SQL Server data types. However, LeapFrogBI does have the tools needed to make integrating spatial
Tips & Tricks
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.
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
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
There are many ways to deal with records that have been deleted from a source system. The first decision is to determine if the deletion needs to be reflected in the target model. Then we need to figure out how
LeapFrogBI’s dimension templates are designed to handle a number of use cases. Below is a list of currently available templates, along with a short description of their capabilities & characteristics.
Cliff’s Notes Version – Use D1003 as your default dimension
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
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
At times we need to select from two or more sources and stage the selected source. As an example, you may want to collect all historical records from an archive on the initial load, and collect only new records from
It is less than ideal, but at time we need to collect data that is stored in Excel. Working with Excel can be a little tricky. This post assumes that you have Excel data that is in a standard tabular