Centerprise Integration Server
Centerprise Integration Server provides a multithreaded parallel data transformation and integration server that makes full use of multi-core and multiprocessor hardware to deliver exceptional performance and scalability. Key features:
- Native support for SQL Server, Oracle, DB2, Sybase, and Access databases and popular file formats such as delimited, fixed length, and Excel
- Comprehensive database functionality including bulk inserts, batch updates, parallel database writes
- Transaction management support
- Highly parallel processing engine with the capability to efficiently process high volume data.
- Full-featured task scheduler
- Server monitoring and management module
- 100% managed .Net code
Connectivity
Centerprise Integration Server 2.0 supports many popular databases and file format including:
- Microsoft SQL Server
- Oracle
- DB2
- Sybase
- Microsoft Access
- Fixed length files
- Delimited files
- Excel files
For a complete list of database platforms and versions, click here.
Performance and Scalability
Centerprise is designed from the ground up as a multithreaded parallel engine. Parallelism is used throughout the product to achieve major performance gains. By taking advantage of today’s multi-core and multiprocessing hardware, this architecture delivers performance and scalability necessary to process increasingly high data volumes.
Scheduling
Centerprise Integration Server’s job scheduler provides flexibility to schedule integration jobs by:
- Hour, Day, Week, or Month
- Frequency: Every Tuesday and Thursday at 9 AM, First Monday or Every Month, etc.
- Jobs can be scheduled or rescheduled on any registered server using Server Manager
Server Management
Sever Management Console provides features to manage multiple servers including starting, terminating, scheduling, and rescheduling jobs. Server Manager features include:
- View status of jobs currently running or scheduled to run
- View detailed information about jobs completed including summary and detailed data profile, error information, etc.
- Terminate job(s) that are running