Gartner analysts predict BI to be consumed by Mobile

Business intelligence and analytics leaders need to embrace four trends, including the growing popularity of business applications on mobile devices, according to analysts at Gartner.

Full article

Gartner says BI and analytics leaders should embrace the technology, market and management trends “that will transform the field within a few years”.

Gartner has identified four key BI predictions to help organisations plan for 2011 and beyond:
– By 2013, 33 per cent of BI functionality will be consumed via handheld devices
– By 2014, 30 per cent of analytic applications will use in-memory functions to add scale and computational speed. Applications will use proactive, predictive and forecasting capabilities
– By 2014, 40 per cent of spending on business analytics will go to system integrators, not software vendors
– By 2013, 15 per cent of BI deployments will combine BI, collaboration and social software into decision-making environments

SSIS Import Flat Files with Headers

Well today I did something new 😉

First a little background information.
The project is called ‘DLT Containment’, here’s a short quote from the PID:
DLT stands for Die Level Traceability – this system contains all genealogy for our LED’s from EPI Reactor run through the LED location in the end-product we ship to a customer (full traceability).

I made a SSIS package that processes the logging files…BUT…they contain headers (see below).
It’s actually based upon the T-SQL code from my previous post.

First I’ll show the Destination table design:

Nothing that difficult:
FST_Lot_ID = (believe it or not) WO NO
FST_SubLot_ID = LOT NO
FST_Date – Current datetime (smalldatetime..Grrrr)

I was struggling for quite a time on how I should do it.
After minutes (maybe an hour), I got an idea and worked on it.
Here’s the result of my brainstorm session:

Suggestions are welcome ofcourse.

The world of SQL Server without SSIS

Within the scope of my new project, I need to migrate SQL Server 2000 & 2005 to 2008 R2.
Sounds a lot of fun huh?
Well check out this code, never seen something like this before though:

The code

Actually, when you break it into pieces, it’s quite simple.
It uses two procedures in SQL Server:

EXECUTE xp_cmdshell { 'command_string' } [ , no_output ]
Example: EXEC xp_cmdshell 'dir *.txt'

EXECUTE xp_fileexist { ‘filename‘ } [, file_exists INT OUTPUT]
Example: EXEC master..xp_fileexist 'c:\boot.ini'