Header banner
Revain logoHome Page
Mark Clark photo
1 Level
788 Review
67 Karma

Review on Excel Database Tasks (EDT) by Mark Clark

Revainrating 4 out of 5

Easy to Use, Flexible and affordable BI Tool

I like that it is easy for me as an end user - once i've created my own table in excel then EDT makes creating ETL tasks pretty straightforward! The interface could be more intuitive or better designed with regards how one creates their tables within EDt- but all good things come at some point of time!! Overall its quite flexible tool which allows us create our very customised applications without having any coding knowledge required from users! Some minor issues we have encountered are : 1.) Not being able too use formulas while saving files2.). Saving file size sometimes becomes huge3). File sizes not always saved correctly4). Sometimes there might arise situations where certain fields cannot save properly5 ). Lackadaise support6). Certain functions do require manual intervention7).[Not enough templates available]8.[A need exists if want multiple instances running simultaneously.].

img 1 attached to Excel Database Tasks (EDT) review by Mark Clark



Pros
  • It's free
  • Easy to install, simple UI.
  • Good documentation provided by Microsoft team
  • Multiple choice options when selecting data sources/destinations etc
Cons
  • There isn't much information about various settings.
  • Poorly formatted output sheets