Diyotta Data Integration Suite


Since the introduction of MPP data warehouse appliances such as Netezza and Teradata, the data warehouse industry has swiftly advanced to high-performance, high-volume operations, using in-database analytics, transformations and processing. The move to Hadoop has introduced new challenges in data integration, as well.


The Diyotta Data Integration Suite gives you a manageable, completely metadata driven and easily adaptable technology platform designed to complement and leverage existing platforms, enabling them to meet your ELT-based data integration needs.

The Suite is an ingenious and unprecedented platform, purpose-built to leverage your MPP and large-scale distributed computing environments, delivering effective and efficient management of big data integration needs. Diyotta presents a unique approach to defining and running data transformation and integration processes, resulting in exponentially faster and simpler development and maintenance.


Diyotta guarantees the highest level of performance possible for the execution of data transformation and validation processes, and you benefit from the most cost-effective solution available.

Five major modules combine to support the design, development, management, monitoring and administration of data integration across your enterprise. With our exclusive metadata management capabilities, you can track data lineage end to end, as well as, perform full impact analysis from source to target.

Diyotta Studio :


• Delivers GUI collaborative development environment with check-out/check- in facility
• Includes smart expression editor for all MPP native row-level and analytical functions
• Enables re-usable designs and parameterization
• Supports multiple transformations including: joins, rollup, filter, splitter, union, and minus
• Supports different data load types: Insert, update, upsert, SCD Type2, delete
• Provides break points at all logical units
• Enables starting or resuming a debug from break point
• Allows viewing the SQL and Log on each logical unit/Break point level
• Allows viewing the processed data on each logical unit/Break point level
• Provides complete runtime statistics: start and end time, # of records processed




Diyotta Admin:

• Enables administration on projects, users, hosts and licenses
• Provides role- based security to manage projects in multi-team environment
• Extends flexibility to monitor user work and server logs
• Enables connectors to integrate source and target systems
• Supports application configuration management



Diyotta Scheduler :

• Allows scheduling both Streams and external programs/scripts
• Supports file event & task dependencies
• Enables email notifications
• Provides reusable calendars
• Provides stop, abort and resume capabilities



Diyotta Metaview :

• Allows users to view Diyotta metadata
• Provides comprehensive data lineage with ELT rules
• Enables forward and Backward data lineage at entity and attribute level
• Provides impact analysis on change requests
• Provides downloadable impact analysis reports



Diyotta Monitor :

• Rich & Intuitive GUI
• developer-friendly navigation
• Users able to monitor execution of streams and jobs
• Job/stream re-start capabilities
• Holistic view of operational statistics

The Diyotta Data Integration Suite is available as either a virtual or physical appliance.

The virtual appliance consists of reference architecture for your Diyotta server and our software distribution, including the Diyotta Data Integration Suite, metadata database and other utilities. You install this distribution on your server, built from the reference architecture.

The physical appliance consists of a prebuilt and preconfigured server along with all the software required to run the solution, including the Diyotta Data Integration Suite, the OS, the metadata database and other utilities.