Databases

Table 1-4 shows the repository, source, and destination databases supported by ETL Server.

Table 1-4: Sybase ETL Server database support

Database

Version

Repository

Source

Destination

Stage

Sybase Adaptive Server Enterprise

15.0.2 ESD #6, 15.0.1 ESD #4, 12.5.4, and 12.5.4 ESD #8

No

Yes

No

Yes

Sybase SQL Anywhere Server

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

11.0, 10.0.1

Yes

Yes

No

Yes

Sybase IQ

12.7 ESD #2 to ESD #5, and 15.0

No

Yes

Yes

Yes

IBM DB2 UDB

9.1 and 8.2

No

Yes

No

No

Microsoft Access

2007

Yes

Yes

No

No

Microsoft SQL Server

2000, 2005 SP2

Yes

Yes

No

No

MySQL

5

No

Yes

No

No

Oracle

10g, 11g

No

Yes

No

No

SQLite

NoteUse SQLite only in a test environment.

3.3.5

No

Yes

No

No

NoteAccessing a repository using the OLE DB interface is not supported.