%META:TOPICPARENT{name="UdaWikiWebIndex"}% =Data Migration & Integration Configuration = %TOC% == Microsoft SQL Server Integration Tools == * [[MsSqlOn64bitWin|An important note for all 64-bit Windows environments]] === Data Transformation Services (DTS) === * [[ConfigDTSOPLOLEDB|Using Microsoft SQL Server DTS Import with the OpenLink OLE DB Provider for ODBC Data Sources]] * [[ConfigDTSMSDASQL|Using Microsoft SQL Server DTS Import with the Microsoft OLE DB Provider for ODBC Drivers]] === Linked Servers === * [[ConfigLinkedServers2005OPLOLEDB|Using Microsoft SQL Server 2005 Linked Servers with the OpenLink OLE DB Provider for ODBC Data Sources]] * [[ConfigLinkedServers2005MSDASQL|Using Microsoft SQL Server 2005 Linked Servers with the Microsoft OLE DB Provider for ODBC Drivers]] * [[ConfigLinkedServers2000OPLOLEDB|Using Microsoft SQL Server 2000 Linked Server with the OpenLink OLE DB Provider for ODBC Data Sources]] * [[ConfigLinkedServers2000MSDASQL|Using Microsoft SQL Server 2000 Linked Server with the Microsoft OLE DB Provider for ODBC Drivers]] * [[ConfigLinkedServersConnectionPooling|Configuring Connection Pooling with Microsoft SQL Server Linked Server]] === SQL Server Integration Services (SSIS) === * [[ConfigSSISOPL|Using Microsoft SQL Server 2005 Business Intelligence Development Studio with OpenLink Drivers]] * [[ConfigSSISOPLOLEDB|Using SSIS Import with the OpenLink OLE DB Provider for ODBC Data Sources]] * [[ConfigSSISMSDASQL|Using SSIS Import with the Microsoft OLE DB Provider for ODBC Drivers]] ==Oracle Integration Tools== === Database Gateway for ODBC (DG4ODBC) === * [[ConfigHSODBCr9|Using Oracle dg4odbc with an OpenLink ODBC data source]] === Heterogeneous Services Generic Connectivity (HSODBC) === * [[ConfigHSODBCr9|Using Oracle Heterogeneous Services (Oracle 9i and later) with an OpenLink ODBC data source]] * [[ConfigHSODBCr8onHP|Using Oracle Heterogeneous Services on HP-UX (Release 8i and up) with an OpenLink ODBC data source]] * [[ConfigHSODBCr817|Using Oracle Heterogeneous Services (Release 8.1.7 and below) with an OpenLink ODBC data source]]