Over the past few weeks Alan & I have had the pleasure of working with a small team to build an AR data mart. The goal was simple. Provide the business sponsors with the ability to monitor and trend outstanding aged AR over time. We built a periodic snapshot fact table with four conformed and […]
Monthly Archives: September 2013
LeapFrogBI makes collecting data from an ODBC (Open Database Connectivity) data sources a simple process. Profile your source and stage your profiled data. Establish a connection using ODBC direct, ADO.Net to ODBC, or a linked server. Drivers are widely available to data sources such as MySQL, SQLite, Hive, and many more.
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 […]