Components show

Name:
MSSQLDataWriter

Description:
Receives data through connected input port or reads it from input file, connects to MSSQL database using bcp utility and loads data records into specified database table. Rejected records along with information about error are sent out through optional output port if connected. It works faster than DBOutputTable.

CloverETL Enterprise Server

CloverETL Server brings enterprise features to CloverETL Engine. It is full-fledge server application with rich WEB based administrative interface which leverages existing CloverETL Engine.

CloverETL Server features highlight:

  • parallel execution of transformations
  • clustering for greater scalability & fail-over
  • supports multi-user interaction
  • performance tuned for the fastest transformation execution
  • thread pooling for better CPU resources utilization
  • pool of graphs/transformations for faster graph start-up time and continuous data processing
  • graph run scheduling capabilities - similar to CRON
  • event listener allowing to fire action based on graph run/finish/failure/timeout; file appearance/change; message arrival
  • full logging of graphs executions with tracking history
  • WebServices style of API for managing execution of graphs (allows for rapid implementation of any WebService)

CloverETL Server deployment options

CloverETL Server deployment schema

Other features:

  • runs in app.container (Tomcat, JBoss, WebSphere, GlassFish, ..etc..) on any platform with JVM (Unix, Windows, Linux, AS/400 and many more)
  • can be fully embedded into other applications
  • all communication is carried through HTTP/S protocol - easy integration into existing net infrastructure
  • pooled connections to databases for better performance
  • security module which supports user roles and groups
  • co-operates with third-party source code management systems and metadata repositories

CloverCloud - CloverETL Servers running in cluster

Load balancing performed by cluster's Master node: External load balancing - via HTTP load balancer:

CloverETL Server architecture

CloverETL Server schema

Server Demo

See live demo of CloverETL Server.