A DATA DISCOVERY TOOL WITH EXCELLENT MS 365 INTEGRATION

List of Features: (with video links)


Standard Version (Free)   includes all the core features of D4E:


Store and Manage SQL codes - Ability to store, organize, and manage multiple SQL queries within the tool.


Run SQLs from Command Bar Menu - Business User executes SQL commands directly from menus without needing SQL expertise.


File-based Parameters - Store parameters in files for use within SQL queries, making it easy to manage data-driven queries.

 
Update Databases - Ability to perform database updates, inserts, and deletes directly from Excel through SQL queries.


Windows Security - Integration with Windows security features to ensure secure access to data and protect sensitive information.

    
Extensive Logging - Detailed logs of SQL execution, parameter handling, and task statuses for tracking and troubleshooting.


Compiled COM DLL - The application is compiled into a COM DLL Excel addin, ensuring high performance and secure functionality


Advanced Version (Paid)   includes all the core features above, plus:


Macro Recording and Execution - Record and execute macros to automate repetitive tasks and SQL operations within Excel.


Scheduling - Schedule SQL queries, macros, and other tasks to run automatically at specified times or intervals.


Parameter Prompts - Interactive prompts for users to input parameters at runtime, making SQL queries more flexible and user-friendly.


Complex SQL Replacement - Replace complex placeholders or variables in SQL statements with dynamic values during execution.


Encoding Private Data - Encrypt and store private data securely to prevent unauthorized access to sensitive information.


Excel Ribbons Icons - Custom Excel ribbon icons for quick access to key D4E features, such as running SQL commands and menus.


Excel Task Pane - An interactive task pane within Excel to display logs, run SQL, manage tasks, and interact with D4E more efficiently.


Create Mini Applications - Build custom mini applications within D4E, integrating SQL and Excel to create tailored solutions for specific tasks.


Use with Servers and Devices - Mobile devices can be used to communicate with Excel servers to return real-time SQL outputs remotely.


The main use case of the Standard Version is for an unlimited number of SQL Developers to write unlimited number of SQLs in simple agreed formats, so that select Business Users can easily run them via menus and without SQL knowledge. 


These select few Business Users may also upgrade to the Advanced Version to gain additional features that are primarily business-oriented and cost-justified.


DOWNLOADS

CONDITIONS OF USE:
This is a limited trial version of Datamart4Excel (aka D4E, Data Mart for Excel, Data Robots for Excellence). You must not use the trial version in a production environment without permission. A normal full license may revert to a trial version, if the main user license or any product license has expired or in any way become invalid. Please visit www.datamart4excel.com and contact us for pricing information to use the full version. You accept that the software program for Datamart4Excel belongs to Caratrel Consultants Pty Ltd. You may not de-compile, de-obfuscate, adapt, translate, or otherwise change Datamart4Excel into any other software program or format. You shall not use trial versions of the software or product libraries in a production environment. You shall not use Datamart4Excel and its license files for any purpose or in any manner other than its intended purpose. You shall not allow Datamart4Excel license files to be used by anyone other than its registered owner. You agree to indemnify and hold harmless Datamart4Excel and its authors, against any claim resulting from loss of any kind as a result of using Datamart4Excel.
 

DOWNLOAD HERE:  (By downloading our software, you hereby agree to the conditions of use above.)

 

 D4E Standard Version (Free).  After download, copy to local drive and rename as d4e_free.xlam

 D4E Advanced Version (Requires a license key after trial period).  After download, copy to local drive and rename as d4e_helper.xlam

 D4E Taskpane (Used with Advanced Version).  After download, copy to local drive and rename as d4e_taskpane.zip


After downloading and renaming, right-click on file > Properties > (if showing) tick Unblock + Apply > tick Read-Only > OK.  

Always run your anti-virus software to ensure the files you download are safe.


To install XLAM addins: 

Copy to the XLSTART folder.
Alternatively, copy to any local drive > Excel  > Options > Add-ins > Add-ins Manage > choose Excel Add-ins > Go > Browse > navigate and select .XLAM file

Alternatively, just click and execute without installing.


To install d4e_taskpane.dll:
Unzip file d4e_taskpane.zip to local drive.

In the unzipped folder, double-click on setup.exe
Confirm that it is in the Excel COM Add-ins Manager and ticked.

For enterprise editions, we provide the full source code of d4e_free.xlam (D4E Standard Version) for transparency and trial purposes.  Contact us for more information.