United States   Change   |   All Microsoft Sites

Home

SQL Server Integration Services with Oracle Database 10g

This paper focuses on the advantages of using SQL Server Integration Services (SSIS) to extract data from heterogeneous sources and import data into Microsoft SQL Server for Business Intelligence (BI) analysis and reporting. Oracle Database 10g data is used as the primary data source.

The audience for this paper includes IT professionals, database administrators, and system architects. The reader should have a general understanding of databases and Microsoft SQL Server and Oracle Database 10g. Readers should use the referenced databases on their preferred hardware platform.

Included in This Document

  • Introduction

  • About SQL Server Integration Services (SSIS)

    • Installing Oracle Database 10g Client Software

    • Testing the Oracle Database 10g Client Installation

  • Building an ETL Solution in SSIS

    • Planning the Solution

    • Creating the Solution

    • Enhancing the Solution

  • Conclusion