AnyData2Vertica (A2V)

Load data from a wide range of sources into your own Vertica account.

Product Overview

AnyData2Vertica (A2V) is Adamant's self-developed single-JAR data loading and management platform. Users log in with their own Vertica credentials, and system permissions map directly to database GRANTs. A2V can pull data from files, REST APIs, S3/HDFS, Kafka, MongoDB, SQL Server/Oracle/MySQL/PostgreSQL, and even another Vertica instance, then transform and write it into tables the user is authorized to access. Beyond data loading, A2V includes a data catalog, data browser, SQL workbench, DDL/GRANT management, step-by-step pipelines, scheduling and monitoring, execution history, notifications, asynchronous export, a read-only MCP channel, and an AI assistant—so data preparation is completed on a single platform.

Core Features

Multi-Source Data Loading

Supports CSV/TXT/TSV/XLSX/JSON/Parquet/ORC, REST APIs, Kafka, MongoDB, S3/HDFS, and JDBC sources such as Vertica, PostgreSQL, MySQL, SQL Server, and Oracle—flexibly combined to meet your needs.

Step-by-Step Pipeline v2

Build DAG pipelines with SOURCE → TRANSFORM/SQL/IF/FOREACH → TARGET steps, supporting dry runs, single-step validation, retries, timeouts, and repair to keep complex loading flows clear and controllable.

Data Catalog & Data Browser

Browse schemas, tables, views, columns, statistics, projections, and DDL, and preview external source columns and data through a tree interface to quickly locate loading targets.

SQL Workbench

Provides syntax highlighting, autocomplete, EXPLAIN, result charts, query history, and CSV/XLSX/JSON/TSV result export—no need to switch tools for daily queries.

Scheduling & Monitoring

A Cron editor supports multiple time periods, minutes, and weekdays with effective date ranges; it can also watch folders or object storage for new files and automatically trigger loads.

Permissions & Security

Login uses database credentials, feature permissions are controlled by Vertica roles, environments/resources/pipelines can all have ACLs, and source passwords are encrypted with AES-256-GCM.

Execution History & Notifications

Filter execution records by pipeline, status, node, and time range, inspect results and logs for each step, and stay on top of failed jobs through the notification center.

MCP & AI Assistant

Provides a read-only JSON-RPC MCP channel for external AI agents to query the catalog, execution history, and read-only SQL; the AI assistant supports SQL explanation, optimization, text-to-SQL, and error diagnosis.

Use Cases

Heterogeneous Data Integration into Vertica

Integrate data from files, relational databases, NoSQL, message queues, and object storage into Vertica to build a consistent analytics foundation.

Self-Service Data Loading

Business and analytics users complete loading on their own with existing Vertica permissions, without waiting for a DBA, shortening data preparation time.

Scheduled Data Preparation

Trigger pipelines with Cron schedules or file watches so reports, dashboards, and analytical models always use the latest data.

Data Governance & Audit

Track every load through environment/resource/pipeline ACLs, execution history, and per-step logs to meet audit and compliance requirements.

AI-Assisted Data Engineering

Use the AI assistant to generate and optimize SQL, diagnose loading errors, and get loading strategy recommendations—lowering the barrier to data engineering.