We will be building solutions to common problems, which use several different database sources. To provide real-life examples, we will work through actual problems using different databases and SSIS to solve several common problems. We will do this by deliberately using different database types to work in a collaborative environment.

By Tom Snyder

Editor’s Note: This article is excerpted from chapter 4 of Extract, Transform, and Load with SQL Server Integration Services--with Microsoft SQL Server, Oracle, and IBM DB2, by Thomas Snyder and Vedish Shah.

In Figure 4.1, you can see that we will be using the IBM DB2 database as our source system of record (SSoR or SOR). Database communications will be made to the SQL Server database using Web services, XML, and database-to-database operations. We will also be creating Excel spreadsheets from our database and sending extract, transform, and load (ETL) updates to our Oracle data warehouse.

Program to Prepare, Certify and Position Latinos for the Future through Tech Ed and Job Skills

By IBM Corporation

The Hispanic Heritage Foundation (HHF) announced today its collaboration with IBM which includes leveraging IBM SkillsBuild – a free education program that helps students and adult learners develop valuable new skills and access career opportunities in technology fields – by providing digital content, personalized mentoring, and the experiential learning they need to gain technical, critical thinking, and creative problem-solving skills. The program will be offered for FREE to HHF Network, is completely digital, and includes IBM-branded digital credentials that are recognized by the market to create direct pathways to tech jobs.  The effort will be open to high school students, college students, young professionals, and adult learners.