DADE Plugins

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.

This architecture enables the Query Wizard to be used with SQL based TDataSet descendants.