Data Migration & Integration Configuration

Microsoft SQL Server Integration Tools

• An important note for all 64-bit Windows environments

Data Transformation Services (DTS)

• Using Microsoft SQL Server DTS Import with the OpenLink OLE DB Provider for ODBC Data Sources
  
• Using Microsoft SQL Server DTS Import with the Microsoft OLE DB Provider for ODBC Drivers

Linked Servers

• Using Microsoft SQL Server 2005 Linked Servers with the OpenLink OLE DB Provider for ODBC Data Sources
  
• Using Microsoft SQL Server 2005 Linked Servers with the Microsoft OLE DB Provider for ODBC Drivers
  
• Using Microsoft SQL Server 2000 Linked Server with the OpenLink OLE DB Provider for ODBC Data Sources
  
• Using Microsoft SQL Server 2000 Linked Server with the Microsoft OLE DB Provider for ODBC Drivers
  
• Configuring Connection Pooling with Microsoft SQL Server Linked Server

SQL Server Integration Services (SSIS)

• Using Microsoft SQL Server 2005 Business Intelligence Development Studio with OpenLink Drivers
  
• Using SSIS Import with the OpenLink OLE DB Provider for ODBC Data Sources
  
• Using SSIS Import with the Microsoft OLE DB Provider for ODBC Drivers

Oracle Integration Tools

Database Gateway for ODBC (DG4ODBC)

• Using Oracle dg4odbc with an OpenLink ODBC data source

Heterogeneous Services Generic Connectivity (HSODBC)

• Using Oracle Heterogeneous Services (Oracle 9i and later) with an OpenLink ODBC data source
  
• Using Oracle Heterogeneous Services on HP-UX (Release 8i and up) with an OpenLink ODBC data source
  
• Using Oracle Heterogeneous Services (Release 8.1.7 and below) with an OpenLink ODBC data source