4Sight Data Transformation
4Sight Data Transformation provides faster and more efficient uploading of information into the data warehouse allowing business users better access to data on a daily, rather than weekly or monthly, basis. This proven mechanism of data loading offers a less time-consuming and less labor-intensive way of uploading data which can result in improved productivity for your IT team. The 4Sight data transformation components offer a common data platform across your entire insurance organization allowing you to use resources more efficiently and improve the success of your internal IT and business initiatives. Let 4Sight connect your various data systems into one single area for reporting, analyzing and trending of data.

Data Integration Feature Details

Modern, Standards-based Architecture

	Extensible architecture- Easy to develop and plug in custom connectors
	SAP connector available
	100% Java with broad, cross-platform support
	Complete separation of user interface, data, and metadata
	Fully integrated with the Pentaho BI Suite providing advanced scheduling, security, reporting, and analysis

Enterprise-Class ETL
	Transforms data from -> being optimized for transaction to -> being optimized for reporting and analysis
	synchronizes the data coming from different databases
	data cleanses to remove errors
	Meta-data, model-driven approach - Tell it WHAT to do and not HOW to do it
	Complex transformations with zero code
	Graphically design data transformations and jobs
	Repository-based
	Structured management of models, connections, logs and more Easy re-use of queries and transformation components
	Broad out-of-the-box data source support including packaged applications, over 30 open source and proprietary database platforms, flat files, Excel documents, and more
	Extensible architecture makes custom plug-in and connector development a breeze Repository-based providing easy re-use of transformation components, multi-developer collaboration, and structured management of models, connections, logs, and more
	Enterprise class performance and scalability with support for massively parallel processing (MPP) through clustered execution of transformations
	Fully integrated with the Pentaho BI Suite providing advanced scheduling, security, reporting, and analysis
	Integrated debugger to streamline troubleshooting of data integration processes
Other Common Uses
	Data warehouse population with built-in support for slowly changing dimensions, junk dimensions and much, much more.
	Export of database(s) to text-file(s) or other databases
	Import of data into databases, ranging from text-files to excel sheets
	Data migration between database applications
	Exploration of data in existing databases (tables, views, etc.)
	Information enrichment by looking up data in various information stores
	Data cleansing by applying complex conditions in data transformations
	Application integration