Although your license determines which version of Sybase ETL you install, Sybase ETL Small Business Edition 4.2 ships with a documentation set common to all Sybase ETL products. If you use the Sybase ETL SBE online help system, for example, you may see references to features available only for the Sybase Data Integration product suite.
Refer to the matrix in Table 1 to identify the features available in Sybase ETL Small Business Edition 4.2.
Feature |
Sybase ETL 4.2 (in DI Suite 1.1) |
Sybase ETL Small Business Edition 4.2 (eShop) |
|---|---|---|
Platforms |
||
– Windows x86: 2003, XP |
Included |
Included |
– Windows x64: 2003, XP |
Included |
Included |
– Linux x86 |
Included RH 4.0 & SLES 9 (SP2) |
Not Included |
– Linux x64 |
Included RH 4.0 & SLES 9 (SP2) |
Not Included |
– Solaris SPARC: 9, 10 |
Included |
Not Included |
– IBM AIX: 5.3 |
Included |
Not Included |
Repository |
Sybase ASE, Oracle, IBM DB2, MySQL, Microsoft SQL Server, Microsoft Access |
Microsoft Access |
ODBC Data Sources |
Included |
Included |
Native Connectivity to Oracle, Sybase, DB/2 Sources |
Included |
Included |
Native Connectivity to Oracle, Sybase, DB/2 Targets |
Included |
Included |
Flat File Sources |
Included |
Included |
Support of FTP/HTTP Sources |
Included |
Included |
XML Data Sources |
Included |
Included |
XML Data Targets |
Included |
Included |
ODBC Data Targets |
Included |
Included |
Flat File Targets |
Included |
Included |
Live Data Simulation |
Included |
Included |
Performance Analysis Support |
Included |
Included |
Unicode Support |
Included |
Included |
Batch Scheduling |
Included |
Included |
Simultaneous Project Support |
Included |
Included |
Copy/Paste between Projects |
Included |
Included |
Scheduler Integration |
Included |
Included |
Multi Project Job Control |
Included |
Included |
Multi User Support |
Included |
Not Included |
Multi Repository Support |
Included |
Not Included |
Parallel GRID Engine Support |
Included |
Not Included |
External Parameter Sets |
Included |
Not Included |
Migration Support (DB -> DB) |
Included as source and target: Sybase ASE, IBM DB2, Oracle, Microsoft SQL Server, and Microsoft Access |
Included: Sybase ASE, IBM DB2, Oracle, Microsoft SQL Server, Microsoft Access |
Migration Support (DB -> IQ) Uses DB Bulk for IQ |
Included as source: Sybase ASE, Oracle, IBM DB2, Microsoft SQL Server, Sybase IQ, Microsoft Access Target: Sybase IQ |
Not Included |
Project Components |
||
– DB Data Provider Full Load |
Included |
Included |
– DB Data Provider Index Load |
Included |
Included |
– Text Data Provider |
Included |
Included |
– XML via SQL Data Provider |
Included |
Included |
– XML via XSLT Data Provider |
Included |
Included |
– Data Calculator JavaScript |
Included |
Included |
– Character Mapper |
Included |
Included |
– Data Lookup |
Included |
Included |
– Data Mapper |
Included |
Included |
– Data Splitter JavaScript |
Included |
Included |
– Data Transposer |
Included |
Included |
– DB Lookup |
Included |
Included |
– DB Lookup Dynamic |
Included |
Included |
– DB Staging |
Included |
Included |
– Executor JavaScript |
Included |
Included |
– DB Data Sink Insert |
Included: Sybase ASE, Sybase IQ, IBM DB2, Oracle, Microsoft SQL Server, Microsoft Access +ODBC |
Included: Sybase ASE, Sybase IQ, IBm DB2, Oracle, Microsoft SQL Server, Microsoft Access +ODBC |
– DB Data Sink Update |
Included: Sybase ASE, Sybase IQ, IBM DB2, Oracle, Microsoft SQL Server, Microsoft Access +ODBC |
Included: Sybase ASE, Sybase IQ, IBM DB2, Oracle, Microsoft SQL Server, Microsoft Access +ODBC |
– DB Data Sink Delete |
Included: Sybase ASE, Sybase IQ, IBM DB2, Oracle, Microsoft SQL Server, Microsoft Access +ODBC |
Included: Sybase ASE, Sybase IQ, IBM DB2, Oracle, Microsoft SQL Server, Microsoft Access +ODBC |
– DB Data Sink Synchronize(Intelligent Update) |
Included: Sybase ASE, Sybase IQ, IBM DB2, Oracle, Microsoft SQL Server, Microsoft Access +ODBC |
Included: Sybase ASE, Sybase IQ, IBM DB2, Oracle, Microsoft SQL Server, Microsoft Access +ODBC |
– DB Data Sink Merge(Slowly Changing Dimensions) |
Included: Sybase ASE, Sybase IQ, IBM DB2, Oracle, Microsoft SQL Server, Microsoft Access +ODBC |
Included: Sybase ASE, Sybase IQ, IBM DB2, Oracle, Microsoft SQL Server, Microsoft Access +ODBC |
– Text Data Sink |
Included |
Included |
– DB Bulk Load Sybase IQ |
Included |
Not Included |
– XML Data Sink |
Included |
Included |
Job Components |
Not Included |
Not Included |
– Start |
Included |
Included |
– Project |
Included |
Included |
– Synchronizer |
Included |
Included |
– Multi-Project |
Included |
Included |
– Finish |
Included |
Included |
– Error |
Included |
Included |
