FIDO (The Data Retriever) vs. Microsoft Dynamics SL Quick Query
This page includes a features comparison between our web-based product, FIDO (The Data Retriever), and Quick Query, part of the latest version of Microsoft Dynamics SL.
Feature |
FIDO |
Quick Query |
Special Notes |
Web browser based (IE, Firefox, Chrome, Safari (MAC) |
 |
|
|
Does not require SL login |
|
 |
|
Cross application DB views (point/click) |
|
|
|
Record threshhold filters - by User (local & internet) |
|
|
Quick Query has limit of rows hard-coded in the view.
FIDO allows this threshold to be changed using the User Interface. |
Data Dictionary - customizable (default & override levels) |
|
|
QQ - no data dictionary |
| Use the Data Dictionary to manage field (column) names that are created in any SQL View ... including Quick Query views!! |
|
|
QQ - no data dictionary |
Flexkey Support (Columns by flex-key segment) |
|
|
Quick Query would require SQL View scripting |
Create views based on Data Dictionary |
|
|
QQ - no data dictionary |
Create views based on Tables |
|
|
|
Create views based on SQL View |
|
|
Quick Query requires that the View Editor be licensed. If you have module-based pricing, it must be purchased separately. |
Run with SL 6x, 7x, 2011 |
|
|
Quick Query is for SL2011 only |
View "notes" text |
|
|
|
Lookup Columns (Code fields & Table fields) |
|
|
|
|
|
|
Quick Query requires SQL View scripting |
Aggregates (sum,count, avg, etc.) |
|
|
Quick Query requires SQL View scripting |
Community library of shared views (Note 1) |
|
|
|
Save filter, sort and grouping parameters with a view |
|
|
Quick Query requires that the View Editor be licensed. Parameters are saved with a new view.
FIDO simply saves metadata with a sibling...no additional SQL view is required. |
Drilldown |
|
|
|
Export to Excel |
|
|
|
Filter & Sort |
|
|
|
Grouping |
|
|
|
Launch non-SL applications |
|
|
|
Launch SL applications |
|
|
|
Light User required (Note 2) |
|
|
Quick Query fulfills light user with required SL login |
Multi-company (Select or Combine, point/click) |
|
|
Quick Query requires SQL View scripting |
Security - restrict access by Company/View/Column/Row |
|
|
|
Security - restrict access by View |
|
|
|
Views included out of the box |
100+ |
100+ |
|
(1) Views can be shared thru FIDO's export/import function. Customers who are current on maintenance have access to the community sharing area where views can be shared in a social media environment.
(2) A Light User may have already been required for access to the SL database by such things as BP, SQL, Office, Excel, etc. This same Light User license may be used to access FIDO.
