Web-based contribution interface. Through their web browsers, end-users can sign in and immediately access all the tools they need to upload, process, and preview finished data; all using an easy-to-use user interface accessible to the entire team.

Transformations Engine. Curator’s Transformations Engine processes raw source data into finished, well-formed datasets. [wpex more=”more…” less=””] The Transformations Engine is a massively-configurable processing system with features for multi-threaded calculation execution, job optimization and control, and preview processing. The Engine is designed to handle hundreds of types of possible data operations and logical permutations that correctly handle various data types.[/wpex]

Transformations Authoring. Preparing processing directives for the Transformations Engine is simple to learn with Curator’s web-based Transformations Authoring interface. [wpex more=”more…” less=””] Using the authoring tools, users can chain together data actions from simple data conversions, calculations, and reference checks, to information extraction directives like isolating email addresses and website URLs, and even to advanced capabilities like regular expression authoring. The Transformations Authoring Environment offers nearly infinite control alongside a dynamic previewing capability that shows users step by step what they can expect from their Transformation using real data.[/wpex]

Shared Project Workspaces. Assign one or more team members to Curator projects and get an unrivaled collaborative environment for ETL. [wpex more=”more…” less=””] More technical team members can author complex processing pipelines for the entire team in moments, to be shared with power users and casual users alike. Configurable workflow allow users to communicate their progress with teammates or request reviews if needed.[/wpex]

References. Load in tabular data as Lookup Files and allow end users to join various data sources to mix in meaningful context at the touch of a button. [wpex more=”more…” less=””] For more precise data definition, add formal ontologies into Curator Concept Schemes for added terminology control and the potential for connecting with Linked Data once data are exported.[/wpex]

Processing Automation. Once Transformation Sets are developed in a project, they can be set to automatically process any appropriate source data. [wpex more=”more…” less=””] Project-level automation is easy to set up and immediate to apply, and works even better when combined with Curator’s new Filesystem and Database Integrations. [/wpex]