Excel Database Tasks (EDT)

Excel Database Tasks (EDT) is a software solution offered by Lean Software Limited that aims to assist users in building efficient data edit/processing solutions using Microsoft Excel and SQL Server, Oracle, or MySQL. According to the vendor, EDT is designed for businesses of various sizes and caters to professionals in different industries, including business analysts, data analysts, database administrators, financial analysts, and supply chain professionals.

Key Features

Build powerful data edit/processing Solutions: According to the vendor, EDT allows users to leverage the power of SQL queries to build data edit and processing solutions using Microsoft Excel and SQL Server, Oracle, or MySQL. Users can manipulate and transform data within Excel by utilizing data processing functionalities such as filtering, sorting, aggregating, and joining data sets.

Create Efficient Data Validation / Import solutions: The vendor claims that EDT provides users with the ability to create efficient data validation and import solutions. Users can define validation rules and criteria to ensure data accuracy and integrity. The solution supports seamless integration of data from various sources, including files (CSV or Excel) and SQL queries, into Excel for further processing.

Process Files, Content of Files (CSV or Excel): EDT enables users to process files and the content of files, including CSV and Excel files. Users can extract data from files, manipulate it using SQL queries, and load the transformed data back into Excel. According to the vendor, this feature eliminates the need for manual data extraction and manipulation, potentially streamlining data processing tasks involving external files.

Process Data From an SQL Query or even the windows clipboard: The vendor states that EDT allows users to directly process data from SQL queries or even the Windows clipboard. Users can execute SQL queries within Excel, retrieve data from databases, and perform various data processing tasks. This feature aims to enhance flexibility and efficiency by potentially eliminating the need for manual data extraction and importing.

Direct-to-table or Stored Procedure Processing techniques: According to the vendor, EDT supports direct-to-table processing techniques, enabling users to edit and process data directly within database tables from Excel. Users can also leverage stored procedures for structured and efficient data manipulation. This feature aims to eliminate the need for data export/import, potentially ensuring real-time data processing.

Create faster network Excel Reporting solutions: The vendor claims that EDT empowers users to create faster network Excel reporting solutions. Users can retrieve data from databases using SQL queries and generate dynamic reports in Excel. This feature aims to enhance reporting capabilities by providing real-time data access and potentially eliminating manual data extraction and consolidation.

Schedule data processing tasks: EDT offers the ability to schedule data processing tasks for automation, according to the vendor. Users can set up automated processes to run at specified intervals, potentially ensuring timely and accurate data processing. This feature aims to reduce manual effort and improve efficiency by potentially automating repetitive data processing tasks.