DataX extracts data from the Sagitta, TAM and Infinity Agency Management Systems and converts into a SQL database. It is made up of two main components:
- DataX Server The DataX Server is comprised of an Application Server, Postgres Database Server, Data Transporters, and Data Convertors. The Application Server is an Apache/Tomcat/Java based web application that allows securely logged in administrators to configure and queue extraction jobs. The Postgres Server is an open source SQL database platform that is the target of all extractions. The Data Transporters connect thru known TCP/IP ports to specific Data Providers running on different legacy platforms. The Data Convertors receive the data from the Data Transporters and convert it to Postgres-supported data types. The entire DataX Server runs on a Linux environment and can connect to an unlimited number of Data Providers installed on multiple systems across a network.
-
Data Providers The Data Providers are Unix daemons or Windows Services that run on the agency management database servers. They listen to known TCP/IP ports for connections initiated from the DataX Server Data Transporters. The Data Providers accept commands from the Data Transporters which instruct them to read data from the native legacy databases. Some Data Providers do minor manipulations and filtering to the data and all encrypt the data before transferring it back to the DataX Server. The current Data Providers offered by DataX are pickserve (Sagitta), iserve (Infinity) and TFServ (TAM).