THE DATA DOWNLOAD

Topics: Tool Selection, Informatica, Blog, Informatica PowerCenter

By: Tom Nats

With SQL Server 2012, Microsoft has included a much needed ODBC driver for Linux.

Topics: Tool Selection, Informatica, Blog, Informatica PowerCenter

Business Intelligence Review of 2013

By:  Steve Dine and David Crolene

Each year, we reflect upon the business intelligence (BI) and data integration (DI) industry and provide a Business Intelligence Review of the noteworthy trends that we encounter in the trenches.  Our Business Intelligence Review emanates from five sources: our customers, industry conferences, articles, social media, and BI software vendors.  This years Business Intelligence Review has proved to be an interesting one, on many fronts.  Here are our observations for 2012 and our expectations about 2013.

Topics: Tool Selection, Informatica, Blog, Informatica PowerCenter

By Tom Nats, Sr ETL Developer - Datasource Consulting

In Informatica 9.5 and prior, if you are running a workflow or a set of workflows continuously, you will fill up your repository very quickly. To avoid this, set this at at the integration service or at the session level under custom property.

Topics: Tool Selection, Data Virtualization, Blog

Data organizations are increasingly looking to data virtualization as an efficient approach to address many of the data integration challenges they face, providing broader access to departmental data assets in a simpler way than ever.

Composite Software, Cisco’s data virtualization platform, is one of the preferred data virtualization options available in the industry today.

Topics: Tool Selection, Business Intelligence, Program Management, Blog

Over the last 10 years, the Business Intelligence (BI) and Analytics software landscape has experienced two major trends. The first trend included a number of acquisitions consolidating some of the largest players. 2007 was the peak of this trend starting with Oracle’s purchase of Hyperion ($3.3 B), followed by SAP acquiring Business Objects (BO) ($6.78 B), and then ending the year with IBM’s acquisition of Cognos ($4.9 B). Before consumption, Hyperion, Cognos, and BO had positioned themselves as visionaries and leaders in the space, and the behemoths took notice and action.

The second major trend saw the rise of a newer class of tools like Tableau, Birst and Qlik, boosting higher quality visualizations, self-service, speed to delivery, and ease of use. Architecturally, these tools are leaner and require a smaller footprint. They have eliminated many of the burdensome tasks to install and configure, in turn eliminating much of the need for IT intervention. The emergence of these new tools has significantly eroded the legacy vendors’ stronghold on the market, dropping their share to 70% of sales in 2013, as depicted below, and even further in recent years.

Topics: Tool Selection, Business Intelligence, Program Management, Blog

In part one of the two part series, we looked at the shift in the BI and analytics technology market from traditional tools to emerging technologies. We then briefly discussed how the new wave of BI and analytics technology often fails to meet all enterprise BI requirements. In part 2, we will discuss how an organization should adopt traditional techniques to govern leading edge technologies.