Blog: William McKnight Subscribe to this blog's RSS feed!

William McKnight

Hello and welcome to my blog!

I will periodically be sharing my thoughts and observations on information management here in the blog. I am passionate about the effective creation, management and distribution of information for the benefit of company goals, and I'm thrilled to be a part of my clients' growth plans and connect what the industry provides to those goals. I have played many roles, but the perspective I come from is benefit to the end client. I hope the entries can be of some modest benefit to that goal. Please share your thoughts and input to the topics.

About the author >

William is the president of McKnight Consulting Group, a firm focused on delivering business value and solving business challenges utilizing proven, streamlined approaches in data warehousing, master data management and business intelligence, all with a focus on data quality and scalable architectures. William functions as strategist, information architect and program manager for complex, high-volume, full life-cycle implementations worldwide. William is a Southwest Entrepreneur of the Year finalist, a frequent best-practices judge, has authored hundreds of articles and white papers, and given hundreds of international keynotes and public seminars. His team's implementations from both IT and consultant positions have won Best Practices awards. He is a former IT Vice President of a Fortune company, a former software engineer, and holds an MBA. William is author of the book 90 Days to Success in Consulting. Contact William at wmcknight@mcknightcg.com.

Editor's Note: More articles and resources are available in William's BeyeNETWORK Expert Channel. Be sure to visit today!

January 2007 Archives

This blog entry is co-authored by Mike Ferguson (link) and William McKnight and is being cross-posted on our blogs.

When you’ve decided the appropriate forays into EII (staying away from the times NOT to use EII) and you’ve selected your product, you will need to architect it into your information management environment.

The process of getting the EII tool to learn about a data source is called mapping. From this exposure to the underlying sources, you can use the EII tool to create a virtual schema, which will be used on data access. All EII applications will then see and use the single virtual schema.

The technical base of the data sources can be relational databases, packaged applications, file servers, web services and potentially numerous other data stores – operational and decision support e.g. data warehouses. Indeed, this will be a major criterion of your tool selection. EII platforms differ somewhat in the data source types supported.

Generally, one of these EII instances per environment with multiple data sources is all that is necessary. If your users already use a portal to access information systems, the EII platform can become another of the underlying data stores accessed from the portal.

Applications built on the EII platform can support SQL, XQuery for XML, ODBC, JDBC, and other APIs to access the heterogeneous data sources hidden by virtual view(s) defined in the EII platform.

The implementation of EII in an environment is often the first time that an organization will be capable of providing users with access to an integrated view of both their operational and the post-operational environments. A big decision in your EII architecture will be if you want to expose this fact to the user and for what kind of use should you make such views available. Many organizations start out by leveraging their EII investment to rapidly produce operational and regulatory reports that require data from heterogeneous sources. More mature implementations of EII, in environments that have already been able to shield users from underlying architecture elsewhere in the data access environment, should successfully be able to continue this practice.

Technorati tags: eii, Enterprise Information Integration


Posted January 25, 2007 7:26 AM
Permalink | No Comments |

My latest white paper is available at www.microsoft.com. The title is "Choosing Microsoft SQL Server 2005 for Data Warehousing" and it is about choosing Microsoft SQL Server 2005 for data warehousing. ;-)

If you're looking at building a data warehouse, or the rearchitecture of an existing data warehouse, and may consider the Microsoft solution, I go through the various components of Microsoft SQL Server 2005 and place them into a data warehouse environment.


Posted January 23, 2007 12:56 PM
Permalink | 2 Comments |

Link.

Of all the RFID uses I've heard of, this one is the most unnerving because there's no clue who is behind it. And while chips in coins is seemingly ineffective given what we think we know about reader technology, it leaves open the possibility that there is stronger reader technology out there under the radar.

Then again, it was probably a targeted operation for the individuals given the coins, perhaps by a program accepting the short-term nature of the association of person and coin and perhaps simply for detecting if the individual passed a certain, specific reader. Of course, I'm wandering off into James Bond land here, but, given the cost and trouble to do the coin tagging and plant them, I suspect it was hopeful about something someone deemed important.

Technorati tags: RFID


Posted January 22, 2007 1:12 PM
Permalink | 1 Comment |

Credit Celequest with bringing some much needed attention to the fact that much of business intelligence resides in the operational environment. They tried to popularize BAM (business activity monitoring), but eventually acknowledged it as just another form of operational business intelligence - the difference being the slight instantiation of data. Celequest then married this with the appliance model, offering an operational business intelligence appliance.

Cognos has been steadily moving in this direction for years, orienting itself to business performance management (BPM) and away from a data access tool for those multidimensional data marts hanging off of data warehouses. In doing so, Cognos has clearly extended its market. BPM is more parts operational than it is data warehouse. Celequest now gives Cognos another vehicle to extend its leadership in BPM and operational BI. The price is not revealed yet, but interestingly, it may have been Celequest’s relatively new SAAS business model that made them appealing. Overall, nice move by Cognos.

Link to more information.

Technorati tags: Cognos, Celequest


Posted January 17, 2007 8:24 AM
Permalink | No Comments |

This blog entry is co-authored by Mike Ferguson (link) and William McKnight and is being cross-posted on our blogs.

If you’re ready to take the plunge into EII, you may be surprised to find that one of your existing information management vendors is in that marketplace. It’s also a marketplace of opportunity, where new, focused vendors have emerged.

There are two main types of EII vendors in the marketplace:
1. Model-driven federated query EII vendors
2. ETL tool vendors providing EII via data integration services built using traditional graphical data flows and published as web services

Federated query EII products include
o Business Objects Data Federator
o BEA AcquaLogic Data Services
o Composite Software Information Server
o Denodo
o IBM WebSphere Federation Server (formerly WebSphere Information Integrator) and IBM Information Server
o Ipedo XIP
o Metamatrix
o Sybase Avaki
o XAware

It is also the case that several ETL data integration vendors have extended their data integration tools to support EII. These products include:
o Ab Initio
o Business Objects - Data Integrator
o IBM - WebSphere DataStage SOA Edition
o Informatica - PowerCenter
o Microsoft - SQL Server Integration Services
o Oracle - Warehouse Builder
o SAS - Data Integration Studio

Technorati tags: eii, Enterprise Information Integration


Posted January 12, 2007 8:17 AM
Permalink | No Comments |
PREV 1 2

   VISIT MY EXPERT CHANNEL

Search this blog
Categories ›
Archives ›
Recent Entries ›