ETI products provide high performance data integration capabilities for data synchronization, migration and composite data services for SOA initiatives. As a complement to ETL, EAI, SOA and data warehousing technologies, ETI’s data integration platform extends the value of IT investments by providing high performance connectivity and transformations as organizations combine legacy and proprietary data sources with current technologies like SQL Server and SQL Server Integration Services.
View the SQL Server Magazine On-Demand Webcast with Stacy Miller, ETI chief architect and Dan Lindstead, industry analyst discussing SSIS and ETI High Performance Connectivity.
Download a recent white paper on ETI High Performance Connectivity for SQL Server 2005 and SSIS from the ETI Web site, written by Dan Linstead, an internationally known expert in data warehousing, BI, analytics, very large data warehousing, OLTP, performance and tuning.
The following table shows the high performance connectivity options available from ETI. For more information on ETI, visit ETI's web site at www.eti.com.
Data Source/ Destination
Released By
Data Access API
Supported Database Version
Vendor Support with SSIS?
64-bit support?
Teradata
ETI
Fast Export HPC
V2R5 and later
Yes, HPC (*)
Yes
Native
Yes, BTO (**)
No
SQL Server
Native: OLE DB, Fast load
2000 and later
DB2
Fast data load HPC
zSeries(mainframe), UDB 7.0, iSeries(AS400) and later
Yes, HPC(*)
Native: embedded SQL, Autoloader, Load
Windows 7.0 and later,AIX 5.x, 7.0 and later, AS400 4.5 and later, z/OS, UDB 7.0 and later
Oracle
Windows, UNIX
Native: embedded SQL, SQL*LOADER
7.0 and later; Windows, UNIX
ADABAS
Native: indexed, sequential; unloading data only
Version 2006 and later; Linux, Unix, Mainframe
Sybase
Version 10 and later
Informix
Native: relational
Version 7 and later
SAP
Native: ALE, IDOC, navigational
R3
IDMS
Native: navigational; unloading data only
Version 10.2, 12 and later
File databases
Native: sequential, random, dynamic
Fixed or delimited file formats: XML, VSAM, Change Data Capture(CDC), log files, etc.; Platforms: Windows AIX, Solaris, HP-UX, MVS
SAS
Native; unloading data only
9.0 and later
IMS
Native: indexed, sequential
Version 4.1 or later
WebSphere MQ, MQSeries
Native: Sequential (MQSeries Queue Message)
5.0 (UNIX, Windows) or later; 2.0 (MVS) or later; Platforms: Windows, AIX, Solaris, HP-UX, mainframe, Linux
Applications
Native: flat file
Oracle Financials, Business Objects, Cognos, BizTalk, SIEBEL, PeopleSoft, etc.
EAI Products
webMethods, Vitria, SeeBeyond, Tibco, etc.
Note: This article has been ported over from http://ssis.wik.is/. Note: If you were the owner of above article, update it to the latest information or with other appropriate information.
Ed Price MSFT edited Revision 1. Comment: Minor edits.
Maheshkumar S Tiwari edited Revision 3. Comment: Added tags