Transform Data with Edilitics | Features & Steps

Edilitics is a state-of-the-art data analytics platform that empowers enterprises to execute sophisticated data transformations with precision and adaptability. Our Transform module allows seamless modification and enhancement of datasets, supporting both no-code operations and custom-coded transformations. Whether your data resides within the same system or across different platforms, Edilitics provides the advanced tools needed to optimize your data for in-depth analysis and strategic decision-making.


Implementing Data Transformation in Edilitics

Ensure you have the following:

  • You have established at least one source and one destination integration. The source and destination can be the same or distinct.

  • You have subscribed to a plan that includes the Transform module.

Steps to Configure Data Transformation

Access the Transform Module

Navigate to the Transform section within the Edilitics platform's sidebar.

Initiate a New Transformation Workflow

Click the New Transformation button to begin configuring your data transformation workflow.

Select Source and Destination Integrations

Identify your data source from the available integrations, then select the destination where the transformed data will be loaded.

Notes:

  • Source and destination integrations can be distinct or identical. Only integrations compatible for use as destinations will be displayed.

  • If the source and destination are distinct, all source data will be automatically mapped to data types supported by the destination.

Perform Data Operations

Select the Base Table

Choose a base table for your transformation. This is the dataset that will undergo modifications.

View Sample Data

A simple random sample of up to 5,000 rows from your source dataset is temporarily stored in an encrypted format during the transformation flow creation. Once saved, all sample data is immediately deleted. If you exit without saving, the sample may remain encrypted for up to 24 hours before secure deletion.

Edilitics adheres to industry-standard encryption protocols to ensure the confidentiality of your data.

Note: During transformation configuration, operations are performed only on a sample of up to 5,000 rows, ensuring the source data remains unaffected. As a result, some discrepancies may appear between the sample and the full dataset. The actual data is transformed only after the workflow is saved and executed.

No-Code Operations

Utilize the extensive array of no-code transformation operations available in Edilitics. These operations are designed for ease of use, enabling you to modify and enhance your data without needing to write code.

Implement Custom Code Transformations

For more advanced use cases:

  • Use the built-in code editor to write and execute custom transformations.
  • Edilitics automatically verifies, tests, and executes your scripts within the transformation flow.

Hybrid Workflows (Combining No-Code & Code-Based Operations)

  • Edilitics supports seamless integration of both no-code operations and custom scripts within a single workflow.
  • There is no limit to the number of operations in a transformation, allowing for highly customized workflows.

Define Transformation Title and Description

  • Assign a clear and unique title to your transformation workflow for easy identification.

  • Provide a brief description outlining the purpose of the transformation.

Schedule Transformation Runs

One-Time Execution

  • The transformation runs once and can be manually triggered again if needed.

Daily Automation

  • The workflow runs automatically at a specified time each day.

Custom Cron Scheduling

  • Use cron expressions for precise control over scheduling.

Example: "0 0 * * 1,4" โ€“ Runs at midnight on Mondays and Thursdays.

๐Ÿ‘‰ Tip: If you are unfamiliar with cron expressions, consider using an online cron generator for easy scheduling.

Finalizing & Running Your Transformation

Once all configurations are complete:

  • Review your workflow settings for accuracy.

  • Click Save to start the transformation process.

After the first run:

  • The transformation will follow the scheduled execution pattern unless manually adjusted.

Monitoring & Managing Data Transformations

Detailed Run History

Edilitics provides a comprehensive log of transformation executions, including:

  • Success rates and failures
  • Execution times and performance metrics
  • User interactions (pause, resume, update, trigger)
  • Table-level details for granular insights and troubleshooting.

View Transformation Configuration

Easily access:

  • All tables involved
  • Applied operations and filters
  • Scheduled execution details

This centralized interface simplifies workflow management.

On-Demand Triggering

  • Users can manually trigger an unscheduled transformation run if needed.
  • Once complete, the workflow resumes its predefined schedule.

Pause & Resume Workflows

  • Pause transformations to prevent execution during maintenance or troubleshooting.
  • Resume workflows seamlessly when needed, ensuring data continuity.

Granular Sharing & Collaboration

  • Transformation workflows can be shared with workspace members.
  • Permissions:
    • Shared users can view, monitor, and trigger transformations.
    • Shared users CANNOT edit, delete, or distribute workflows, ensuring security.

Managing Transformation Workflows Throughout Their Lifecycle

Editing Transformation Workflows

Edilitics allows users to modify transformation workflows at any time, provided the workflow is not currently running.

Editable Actions:

  • New operations can only be added after the last saved operation.

  • Operations can be deleted, but with cascading effects.

Restrictions:

  • Existing operations cannot be modified once saved.

  • New operations cannot be inserted between existing steps. If a change is needed in the middle of the workflow, the user must delete all subsequent operations from that point onward and reconfigure them.

  • Deleting an operation removes all subsequent operations.

Example: If a workflow contains 10 operations, deleting the 5th operation will also delete operations 6 through 10. These steps must be reconfigured from scratch.

This ensures workflow consistency, prevents dependency conflicts, and maintains the integrity of transformation logic.

Update Titles & Descriptions

  • Keep workflows easily identifiable by modifying their title or description.

Modify Schedules

  • Adjust transformation schedules directly from the Home Screen for flexibility.

Edilitics provides an intuitive yet powerful transformation framework, allowing teams to modify, manage, and optimize data workflows with ease. Whether using no-code automation or custom coding, Edilitics ensures efficiency, scalability, and full control over your data transformations.

Need Assistance? Edilitics Support is Here for You!

Our dedicated support team is ready to assist you. If you have any questions or need help using Edilitics, please don't hesitate to contact us at support@edilitics.com. We're committed to ensuring your success!

Don't just manage data, unlock its potential.

Choose Edilitics and gain a powerful advantage in today's data-driven world.