Centerprise 3.0 has increased connectivity over previous versions. With the inclusion of ODBC connectivity, the possibilities are almost limitless. Please refer to the table
below to see if your data source is supported by Centerprise 3.0. Note that the ODBC portion of the matrix are just the drivers that have been tested by Astera.
Data Sources Supported by Centerprise Data Integrator
The machine must have .NET Framework 3.5 or higher installed. |
|
Files |
|
CSV |
Files with records and fields separated by a delimiter. This delimiter may
be a comma, semicolon, tab, or any other custom character. |
|
Fixed Length |
Files with fixed field and/or record lengths. These files are most often from
legacy systems. |
|
Microsoft Excel |
Version '97 and later. |
|
XML |
XML as source only |
| Direct Database Connections |
| Data Provider |
Database |
| DB2 |
DB2 V9.1 for Linux, UNIX, and Windows |
| |
DB2 UDB v7.1, v7.2, v8.1, v8.2 for Linux, UNIX, and Windows |
| |
DB2 UDB v7.x, DB2 UDB v8.1 for z/OS via DRDA |
| |
DB2 UDB V5R4 for iSeries |
| |
DB2 UDB V5R1, V5R2, V5R3, V5R4 for iSeries |
| |
|
| Oracle |
Oracle 10g R1, R2 (10.1, 10.2) |
| |
Oracle 9i R1, R2 (9.0.1, 9.2) |
| |
Oracle 8i R2, R3 (8.1.6, 8.1.7) |
| |
|
| SQL Server |
MS SQL Server 2008 |
| |
MS SQL Server 2005 |
| |
MS SQL Server 2000 Enterprise Edition (64-bit) |
| |
MS SQL Server 2000 Desktop Engine (MSDE 2000) |
| |
MS SQL Server 2000 |
| |
|
| Sybase |
Sybase Adaptive Server Enterprise 11.0, 12.0, 12.5, 12.5.1, 12.5.2, 12.5.3, 12.5.4, 15.0 |
| |
Sybase Adaptive Server 11.5 and 11.9 |
| MS Access |
MS Access 97 and beyond |
|
MySQL |
MySQL 5.x |
|
ODBC Connections |
|
Centerprise has the capability to connect to all ODBC connections by nature.
The following are the drivers that have been tested for use with Centerprise 3 |
|
Quickbooks |
Server Edition 2009 (more info) |
|
Informix |
Version 3.0 (more info) |
|
Progress DBMS |
Version 5.3.0074 (more info) |
|
PostgreSQL |
Version 8.03.01 or later (more info) |
|
Ingres |
Version 3.5 (more info) |
|
Paradox |
Version 4.00.6404.00 (more info) |
|
dBase |
Version 4.00.6304.00 (more info) |
|
Pervasive SQL |
Version 9.50.77.02 (more info) |
|
MIMER |
Version 9.03.08.03 (more info) |
|
Sybase ASA |
Version 11 (more
info) |
|
All other ODBC drivers should work with Centerprise, but have not been tested and
are not officially supported. For information on configuring an ODBC driver
for use with Centerprise, look here. |
