Datasheet

Chapter 1: SSIS Solution Architecture
10
Overall Solution Architecture
The reality is that creating a perfectly efficient enterprise data ecosystem is impossible. But there are
certainly levels of efficiency that can be gained when your SSIS solution is planned and implemented
thoughtfully. Figure 1 - 4 contrasts Figure 1 - 1 by showing a city ’ s central power station, organized and
efficient.
Be Careful About Tool Selection
In some client environments, an ETL tool may be chosen without consideration for the
availability of industry skills, support, or even the learning curve. Even though the tool
could perform “magic,” it usually doesn’t come with a pocket magician — just the
magic of emptying your corporate wallet. In many cases, thousands of dollars have
been spent on an ETL tool that takes too long to master, implement, and support.
Beyond the standard functionality questions you should ask about a tool, be sure to
also consider the following:
Your internal skill sets
The trend of industry use of the tool
How easy it is to learn
The ease of supporting the tool
❏
❏
❏
❏
Figure 1-4
c01.indd 10c01.indd 10 9/24/09 11:26:32 AM9/24/09 11:26:32 AM