DADE includes DataView classes that support Delphi’s BDE, ADO, and IBExpress data access components. Additional plug-ins can be created to support products that contain SQL based TDataSet descendants.
Below is a list available DADE Plug-ins.
| Plugin Name | Description |
| daADO by Digital Metaphors |
Included with ReportBuilder. DataView classes that support the Delphi ADO data access components. |
| daIBExpress by Digital Metaphors |
Included with ReportBuilder. DataView classes that support the Delphi Interbase Express data access components. |
| daDBExpress by Digital Metaphors |
Included with ReportBuilder. DataView classes that support the Delphi dbExpress data access components. |
| daDBBDE by Digital Metaphors |
Included with ReportBuilder. Dataview classes that support the Borland Database Engine (BDE). |
| daODAC by Digital Metaphors |
Freeware. DataView classes that support ODAC (Oracle Data Access Components). Click here to download. |
| daElevateDB by Digital Metaphors |
Freeware. DataView classes that support ElevateDB. Download daElevateDBB |
| daADS (Advantage) by Jim North | Freeware. Dataview classes that support Advantage. Created by Jim North and included with ReportBuilder Pro. |
| daASTA by ASTA Technology Group |
Freeware. Dataview classes that support ASTA. Created by AST Technology Group.Download daASTA. |
| daFlashFiler by Stefan Paege |
Freeware. Dataview classes that support Flash Filer 2. Created by Stefan Paege.Download daFlashFiler. |
| daDOA by Digital Metaphors | Included with ReportBuilder. DataView classes that support Direct Oracle Access components. |
| daIBO by Paul Gallagher | Included with ReportBuilder. DataView classes that support Interbase Objects. |
| daDBISAM by Jon Lloyd Duerdoth | Included with ReportBuilder. DataView classes that support DBISAM. |
| dbADO by Anders Nolberger | Freeware. DataView classes that provide direct access to ADO – no TDataset required. Download dbADO. Contact Anders Nolberger with any questions. |
| daDBOvernet by Craig Symons | Freeware. DataView classes that support DBOvernet. Created by Craig Symons.Download daDBOvernet. Contact Craig Symons with any questions. |
| daAdonis by Walter Fordham | Freeware. DataView classes that support Adonis. Created by Walter Fordham. Download daADonis. Contact Walter Fordham with any questions. |
| daDiamond by Walter Fordham | Freeware. DataView classes that support Diamond Access. Created by Walter Fordham. Download daDiamond. Contact Walter Fordham with any questions. |
| daFIBPlus by Marques Sobrinho | Freeware. DataView classes that support the FIBPlus Interbase components. Created by Armando Marques Sobrinho. Download daFIBPlus. |
| daMIDAS by Hartono Setiono | Freeware. DataView classes that support Delphi’s MIDAS. Download daMidas. Contact Hartono Setiono with any questions. |
| daMySQLDac by Dan Armstrong | Freeware. DataView classes that support the MySQLDac components. Created by Dan Armstrong. Download daMySQLDac. Contact Dan Armstrong with any questions. |
| daNDB by Liodden Data | Freeware. DataView classes that support NativeDB for SQLAnywhere. NativeDB for SQL Anywhere is a set of data access components that provides native connectivity to SQL Anywhere databases. Download daNDB. For more information check out www.nativedb.com. |
| daODBCExpress by Steffen Friismose | Freeware. DataView classes that support ODBCExpress. ODBCExpress is a set of data access components that provide ODBC connectivity. Download daODBCExpress. For more information about ODBCExpress check out www.odbcexpress.com. |
| daTitanAccess by Jason Sweby | Freeware. DataView classes that support Titan for MS Access. Created by Jason Sweby. Download daTitanAccess. Contact Jason Sweby with any questions. |
| daTitanSQLA by Jason Sweby | Freeware. DataView classes that support Titan for SQAnywhere. Created by Jason Sweby. Download daTitanSQLA. Contact Jason Sweby with any questions. |
| daNexusDB by Nexus Database Systems | Freeware. DataView classes that support NexusDB. Created by Nexus Database Systems. Download daNexusDB. Contact the NexusDB thirdparty newsgroup with any questions. |
| daZeosLib by Xolphin | Freeware. DataView classes that support ZeosLib components. ZeosLib components provide access to MS SQL Server, MySQL, Interbase, Firebird, and PostgreSQL databases. Created by Xolphin. Download daZeosLib. Contact Maarten Bremer with any questions. |
| dakbmMW by Components 4 Developers | DataView classes that support kbmMW application server. kbmMW bundles a DADE plug-in which allows for a kbmMW application server to act as one or more virtual databases. For more information click here. |
| daAbsoluteDB by Component Ace | Freeware. DataView classes that support Absolute Database. Download daAbsoluteDB. |
Overview
ReportBuilder’s Data Access Development Environment (DADE) contains QueryWizard and QueryDesigner tools that enable developers and End-Users to create and modify SQL queries. The DADE architecture allows developers to define custom DataView classes for the purpose of using the Query tools with any SQL based TDataSet descendant. A DataView class is responsible for creating the data access objects required to connect a report to data. A typical DataView will contain one or more DataPipelines, DataSources, and DataSets.
In addition to creating the data access objects required to connect a report to data, a DataView can also provide functionality to enable the end-user to “design” the data view. One method of delivering this functionality is a data wizard.
TdaQueryDataView is an abstract ancestor for query based DataViews that use the ReportBuilder Query Wizard. An example of a descendant is TdaBDEQueryDataView which contains a BDE based TQuery component. The job of the Query Wizard is to interact with the end-user and build an SQL statement. The DataView communicates with the Query Wizard to provide information such as lists of available table names, field names, etc. Thus the Query Wizard never references any database objects, but instead relies on functionality provided by the query data view.
End-User <--> Query Wizard <--> Query DataView
This architecture enables the Query Wizard to be used with SQL based TDataSet descendants.