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. Read Part 1, on DB2 Databases here:TechTip: Database Setup - IBM DB2 Database.
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.
SQL Server Database
Order Entry Database
The order entry system for our project will reside in the SQL Server database, which is a smaller database than the accounts receivable database and contains minimal information. Figure 4.6 shows the ERD for the order entry database.