Operation

Description

Profile/Discover

Discover Data In Pattern, fuzzy, and dictionary searches through DBs, files, or „dark data“ documents. Perform traditional DB profiling and ER diagramming on connected tables. Automatic classification of data into groups and assignment to transformation, protection, and other rules.

Design/Create

Create and change It handles orders in various ways: a visual workflow palette, end-to-end assistants, GUI dialogs, batchable 4GL scripts, and even a metadata API, all modeled and outlined in the GUI's syntax-aware editor... and even edit your flow and task scripts in any external text editor.

Connections

Manage your Databases (including RDBs, LDIF, CSV, XML, COBOL, and other files) in the Eclipse Project Explorer, Data Source Explorer, and Remote Systems Explorer. Also supported are mainframe index files, unstructured data file formats, ASN.1-compliant CDRs, multiple legacy/proprietary formats, as well as Big Data and cloud/SaaS platforms; see the full list here.

Job Assistant

Automate the generation of your ETL or standalone Extract, Transform, or Load jobs, plus Slowly Changing Dimensions, Change Data Capture, Pivoting, Subsetting, Masking, Migration/Replication, and Test Data Generation. Population of jobs. 

ETL

High-performance single or combined ETL operations in Voracity, that is to say:

1. Extracts from ODBC (surgical) or IRI FACT (Bulk Parallel)
2. Optimized and combined IRI CoSort–Data transformations
3. ODBC (surgical) or DB Utility (pre-sorted bulk-Charging processes)

If you have individual sources >10TB, Voracity can also handle many CoSort (SortCL) transformation, reformatting, and masking jobs seamlessly in Hadoop MapReduce2, Spark, Spark Streaming, Storm, or Tez over the VGrid-Gateway run on your (Cloudera, HortonWorks, MapR, or generic Apache) distribution.

ELT

High performance „E“ and pre-sorted „L“. Design/Management „T“ in Voracity (above) or integrated SQL operations

BI & Analytics

Use the embedded BI or data processing options in Voracity, i.e.:

1. Generation of Detailed and summary reports in the same pass with ETL, among others.
2. Ingestion from KNIME via our Voracity data source node or indexing of Splunk via Voracity App, Add-on, or Universal Forwarder
3. Pass displayable subsets to another visualization tool such as Cognos, Power BI, Qlik, R, Spotfire, Tableau, and many others, to shorten the time to insight on their platform, where Voracity has done the heavy lifting for them

Learn why the Industry Guru Dr. Barry Devlin Voracity, referred to as a production analytics platform.

Masking (Protection)

Encrypt, edit, pseudonymize, hash, randomize, tokenize, or otherwise de-identify PII seamlessly, i.e. data masking during runtime in the same job script and I/O pass with all ETL, cleansing, migration, and analysis/reporting functionalities listed on this page. The true „magic“ and value of Voracity is precisely this type of task consolidation.

Scrubbing/cleaning

Improve the Data quality with a variety of data scrubbing and standardization techniques.

Migration & Replication

Capturing, filtering, subsetting, remapping, and/or copying data from old to new data stores

Team-Sharing

Update, check-in, manage, and exchange metadata and orders in GIT, CVS, SVN, DataSwitch, MIMB, Quest (Erwin / AnalytiX DS) Mapping Manager, etc.

Repositories

Save, Share, and Reuse DDFMetadata, master data dictionaries, business glossaries, setup files (lookup), rules, flow and job scripts.

Data views

View and work directly with your source and target data in files and tables using custom editor and cell views.

Scheme

Use static, dynamic, or converted schemas about target mapping and table creation options.

Persecution

Free Eclipse plugins support the manual, and the AnalytiX DS Mapping Manager supports visual analysis, data staging, and impact analysis. Track and compare You metadevices and other resources (scripts, rules, templates) in Version Control Hubs.

Job Fragments

Storing, referencing, and reusing order and metadata subsets in standalone, portable DDF files, rule libraries, and other open artifacts.

Pivoting

Transpose Convert rows to columns and columns to rows to efficiently denormalize or normalize your data using a simple wizard.

Change Data Capture

Compare Identify, report, and transfer files or tables for updates to smaller real-time ETLs using an intuitive job wizard.

Slowly Changing Dimensions

Report using values from "fuzzy" reference logic, provided they meet criteria other than identical criteria in all common types, via a wizard.

Windowed-Aggregate

Perform aggregation within specific row ranges for fair cost accounting and other applications.

Rules

Definition, storage, and reuse of field-level business rules for data transformation, protection, and test data generation.

Prototype & Test

Generate and download secure, realistic, and reference-correct Test data in file or table targets - without actual data - for an entire EDW in Voracity's built-in IRI RowGen-assistants. Or use the built-in DB Subset Assistant from Voracity, to filter and mask referentially correct DB test sets. Or look at the output of ETL and other workflow tasks with real data or immediately with simulated test data in the same format.