Database support

Table 2 shows the repository, source, and destination databases supported by Sybase IQ ETL 4.5 Server.

Table 2: Sybase IQ ETL Server database support

Database

Version

Repository

Source

Destination

Sybase Adaptive Server® Enterprise

15.0.2 ESD #2, 15.0.1 ESD #3, 12.5.4, and 12.5.4 ESD #8

No

Yes

No

Sybase SQL Anywhere® Server

NoteAs of version 10.0, Adaptive Server® Anywhere has been renamed SQL Anywhere.

10.0.1, 9

Yes

Yes

No

Sybase IQ

12.7 ESD #2 to ESD #4

Yes

Yes

Yes

IBM DB2 UDB

9.1, 8.2.1

No

Yes

No

Microsoft Access

2000, 2003

Yes

Yes

No

Microsoft SQL Server

2005 SP2

Yes

Yes

No

MySQL

5

No

Yes

No

Oracle

10g, 11g

No

Yes

No

SQLite

NoteUse SQLite only in a test environment.

3.3.5

No

Yes

No

NoteSybase IQ ETL 4.5 does not support access to the repository using the OLE DB interface.