Components (FireDAC)

From Appmethod Topics
Jump to: navigation, search

Go Up to Architecture (FireDAC)


FireDAC includes more than 60 Object Pascal nonvisual components.

FireDAC Core Components

The following classes are the FireDAC core components (most of the applications use TFDConnection, and a few use TFDQuery).

Name Platforms Description
TADMANAGER.png TFDManager All Responsible for connection definitions (see more) and connections management.
TADCONNECTION.png TFDConnection All Responsible for connection establishment (see more) with a DBMS.
TADTRANSACTION.png TFDTransaction All Responsible for connection transaction management (see more).
TADCOMMAND.png TFDCommand All Responsible for executing SQL commands (see more).
TADTABLEADAPTER.png TFDTableAdapter All Binds TFDCommand and TFDMemTable.
TADSCHEMAADAPTER.png TFDSchemaAdapter All Binds several datasets into a single in-memory storage and builds a centralized change log.
TADMEMTABLE.png TFDMemTable All Implements an in-memory dataset.
TADQUERY.png TFDQuery All Implements a dataset that can execute SQL queries (see more).
TADSTOREDPROC.png TFDStoredProc All Implements a dataset that can execute server-side stored procedures (see more).
TADTABLE.png TFDTable All Implements a dataset that works with single database tables (see more).
TADUPDATESQL.png TFDUpdateSQL All Applies updates on behalf of queries or stored procedures that cannot post updates directly (see more).
TADDATAMOVE.png TFDDataMove All Responsible for data movement between different data sources.
TADSCRIPT.png TFDScript All Implements a SQL script engine that can execute a series of SQL queries (see more).
TADMETAINFOQUERY.png TFDMetaInfoQuery All Implements a dataset that can execute meta-info queries (see more).
TADEVENTALERTER.png TFDEventAlerter All Responsible for handling the database event notifications (see more).
TADLOCALSQL.png TFDLocalSQL All Implements the Local SQL engine, which can execute the SQL queries with TDataSet descendants as data sources (see more).

FireDAC Driver Link Components

Most of the applications use one link component per supported database. The FireDAC driver link components are described in the following table.

Name Platforms Description
TADPHYSADSDRIVERLINK.png TFDPhysADSDriverLink Win32, Win64, Linux32, Linux64 Use TFDPhysADSDriverLink to link the Advantage Database Server driver (which you should set up) to an application (see more).
TADPHYSASADRIVERLINK.png TFDPhysASADriverLink Win32, Win64, Linux32, Linux64, MacOS Use TFDPhysASADriverLink to link the Sybase SQL Anywhere driver (which you should set up) to an application (see more).
TADPHYSDATASNAPDRIVERLINK.png TFDPhysDSDriverLink Win32, Win64, Linux32, Linux64, MacOS, iOS, Android Use TFDPhysDataSnapDriverLink to link the Multi-Tier DataSnap driver (which you should set up) to an application (see more).
TADPHYSDB2DRIVERLINK.png TFDPhysDB2DriverLink Win32, Win64, Linux32, Linux64 Use TFDPhysDB2DriverLink to link the IBM DB2 driver (which you should set up) to an application (see more).
TADPHYSFBDRIVERLINK.png TFDPhysFBDriverLink Win32, Win64, Linux32, Linux64, MacOS Use TFDPhysFBDriverLink to link the Firebird driver (which you should set up) to an application (see more).
TADPHYSIBDRIVERLINK.png TFDPhysIBDriverLink Win32, Win64, Linux32, Linux64, MacOS, iOS, Android Use TFDPhysIBDriverLink to link the Interbase driver (which you should set up) to an application (see more).
TFDPHYSINFXDRIVERLINK.bmp TFDPhysInfxDriverLink Win32, Win64, Linux32, Linux64 Use TFDPhysInfxDriverLink to link the Informix driver (which you should set up) to an application (see more).
TADPHYSMSACCESSDRIVERLINK.png TFDPhysMSAccessDriverLink Win32, Win64 Use TFDPhysMSAccessDriverLink to link the Microsoft Access driver (which you should set up) to an application (see more).
TADPHYSMSSQLDRIVERLINK.png TFDPhysMSSQLDriverLink Win32, Win64, Linux32, Linux64, MacOS Use TFDPhysMSSQLDriverLink to link the Microsoft SQL Server driver (which you should set up) to an application (see more).
TADPHYSMYSQLDRIVERLINK.png TFDPhysMySQLDriverLink Win32, Win64, Linux32, Linux64, MacOS Use TFDPhysMySQLDriverLink to link the MySQL Server driver (which you should set up) to an application (see more).
TADPHYSODBCDRIVERLINK.png TFDPhysODBCDriverLink Win32, Win64, Linux32, Linux64, MacOS Use TFDPhysODBCDriverLink to link the ODBC bridge driver to an application (see more).
TADPHYSORACLEDRIVERLINK.png TFDPhysOracleDriverLink Win32, Win64, Linux32, Linux64, MacOS Use TFDPhysOracleDriverLink to link the Oracle Database driver (which you should set up) to an application (see more).
TADPHYSPGDRIVERLINK.png TFDPhysPgDriverLink Win32, Win64, Linux32, Linux64, MacOS Use TFDPhysPgDriverLink to link the PostgreSQL driver (which you should set up) to an application (see more).
TADPHYSSQLITEDRIVERLINK.png TFDPhysSQLiteDriverLink Win32, Win64, Linux32, Linux64, MacOS, iOS, Android Use TFDPhysSQLiteDriverLink to link the SQLite driver (which you should set up) to an application (see more here and here).
TADPHYSDBXDRIVERLINK.png TFDPhysTDBXDriverLink Win32, Win64, MacOS, iOS, Android Use TFDPhysTDBXDriverLink to link the dbExpress v 4 bridge driver to an application (see more).
Name Platforms Description
TADPHYSADSDRIVERLINK.png TFDPhysADSDriverLink Win32, Win64, Linux32, Linux64 Use TFDPhysADSDriverLink to link the Advantage Database Server driver (which you should set up) to an application (see more).
TADPHYSASADRIVERLINK.png TFDPhysASADriverLink Win32, Win64, Linux32, Linux64, MacOS Use TFDPhysASADriverLink to link the Sybase SQL Anywhere driver (which you should set up) to an application (see more).
TADPHYSDB2DRIVERLINK.png TFDPhysDB2DriverLink Win32, Win64, Linux32, Linux64 Use TFDPhysDB2DriverLink to link the IBM DB2 driver (which you should set up) to an application (see more).
TADPHYSFBDRIVERLINK.png TFDPhysFBDriverLink Win32, Win64, Linux32, Linux64, MacOS Use TFDPhysFBDriverLink to link the Firebird driver (which you should set up) to an application (see more).
TADPHYSIBDRIVERLINK.png TFDPhysIBDriverLink Win32, Win64, Linux32, Linux64, MacOS, iOS, Android Use TFDPhysIBDriverLink to link the Interbase driver (which you should set up) to an application (see more).
TADPHYSMSACCESSDRIVERLINK.png TFDPhysMSAccessDriverLink Win32, Win64 Use TFDPhysMSAccessDriverLink to link the Microsoft Access driver (which you should set up) to an application (see more).
TADPHYSMSSQLDRIVERLINK.png TFDPhysMSSQLDriverLink Win32, Win64, Linux32, Linux64, MacOS Use TFDPhysMSSQLDriverLink to link the Microsoft SQL Server driver (which you should set up) to an application (see more).
TADPHYSMYSQLDRIVERLINK.png TFDPhysMySQLDriverLink Win32, Win64, Linux32, Linux64, MacOS Use TFDPhysMySQLDriverLink to link the MySQL Server driver (which you should set up) to an application (see more).
TADPHYSODBCDRIVERLINK.png TFDPhysODBCDriverLink Win32, Win64, Linux32, Linux64, MacOS Use TFDPhysODBCDriverLink to link the ODBC bridge driver to an application (see more).
TADPHYSORACLEDRIVERLINK.png TFDPhysOracleDriverLink Win32, Win64, Linux32, Linux64, MacOS Use TFDPhysOracleDriverLink to link the Oracle Database driver (which you should set up) to an application (see more).
TADPHYSPGDRIVERLINK.png TFDPhysPgDriverLink Win32, Win64, Linux32, Linux64, MacOS Use TFDPhysPgDriverLink to link the PostgreSQL driver (which you should set up) to an application (see more).
TADPHYSSQLITEDRIVERLINK.png TFDPhysSQLiteDriverLink Win32, Win64, Linux32, Linux64, MacOS, iOS, Android Use TFDPhysSQLiteDriverLink to link the SQLite driver (which you should set up) to an application (see more here and here).

FireDAC Monitor Link Components

To enforce tracing capabilities, applications can use one of the monitor components in the following table.

Name Platforms Description
TADMONIFLATFILECLIENTLINK.pngTFDMoniFlatFileClientLink All Use TADMoniFlatFileClientLink to link the file tracing capabilities (which you should set up) to an application (see more).
TADMONIREMOTECLIENTLINK.png TFDMoniRemoteClientLink Win32, Win64 Use TFDMoniRemoteClientLink to link the FDMonitor tracing capabilities (which you should set up) to an application (see more).
TADMONICUSTOMCLIENTLINK.png TFDMoniCustomClientLink All Use TFDMoniCustomClientLink to link custom tracing capabilities (which you should set up) to an application (see more).

FireDAC UI Components

Most of the applications use TFDGUIxWaitCursor and TFDGUIxLoginDialog.

Name Platforms Description
TADGUIXASYNCEXECUTEDIALOG.png TFDGUIxAsyncExecuteDialog VCL, FireMonkey This dialog shows an SQL query execution progress (see more).
TADGUIXERRORDIALOG.png TFDGUIxErrorDialog VCL, FireMonkey This dialog displays the FireDAC exceptions (see more).
TADGUIXLOGINDIALOG.png TFDGUIxLoginDialog VCL, FireMonkey This dialog allows the users to enter their DB credentials (see more).
TADGUIXSCRIPTDIALOG.png TFDGUIxScriptDialog VCL, FireMonkey, Console This dialog shows an SQL script execution progress (see more).
TADGUIXWAITCURSOR.png TFDGUIxWaitCursor VCL, FireMonkey, Console This component allows the control of the wait cursor.

FireDAC Service Components

An application uses service components to add a specific DBMS facility support.

Name Platforms Description
TADADSBACKUP.png TFDADSBackup Win32, Win64, Linux32, Linux64 This class implements the Advantage backup database service.
TADADSRESTORE.png TFDADSRestore Win32, Win64, Linux32, Linux64 This class implements the Advantage service, by restoring a database from a backup.
TADADSUTILITY.png TFDADSUtility Win32, Win64, Linux32, Linux64 This class implements the Advantage table utilities.
TADASABACKUP.png TFDASABackup Win32 This class implements the SQL Anywhere backup database service.
TADASAVALIDATE.png TFDASAValidate Win32 This class implements the SQL Anywhere database validate service.
TADIBBACKUP.png TFDIBBackup Win32, Win64, Linux32, Linux64, MacOS, iOS, Android This class implements the FB/IB backup database service.
TADIBCONFIG.png TFDIBConfig Win32, Win64, Linux32, Linux64, MacOS, iOS, Android This class implements the FB/IB setting database properties service.
TADIBRESTORE.png TFDIBRestore Win32, Win64, Linux32, Linux64, MacOS, iOS, Android This class implements the FB/IB service, by restoring a database from a backup.
TADIBSECURITY.png TFDIBSecurity Win32, Win64, Linux32, Linux64, MacOS, iOS, Android This class implements the FB/IB database security management service.
TADIBVALIDATE.png TFDIBValidate Win32, Win64, Linux32, Linux64, MacOS, iOS, Android This class implements the FB/IB database validate and repair service.
TADIBSDUMP.png TFDIBSDump Win32, Win64, Linux32, Linux64, MacOS, iOS, Android This class implements the InterBase-only database dump service.
TADFBNBACKUP.png TFDFBNBackup Win32, Win64, Linux32, Linux64, MacOS This class implements the Firebird-only backup database service.
TADFBNRESTORE.png TFDFBNRestore Win32, Win64, Linux32, Linux64, MacOS This class implements the Firebird-only restore database service.
TADFBTRACE.png TFDFBTrace Win32, Win64, Linux32, Linux64, MacOS This class implements the Firebird database trace service.
TADMSACCESSSERVICE.png TFDMSAccessService Win32, Win64 This class implements the Microsoft Access database. It also creates, drops, compacts, and repairs the services.
TADSQLITEBACKUP.png TFDSQLiteBackup Win32, Win64, Linux32, Linux64, MacOS, iOS, Android This class implements SQLite backup. It also restores and copies the database functionality (see more).
TADSQLITECOLLATION.png TFDSQLiteCollation Win32, Win64, Linux32, Linux64, MacOS, iOS, Android This class implements the custom SQLite collation (see more).
TADSQLITEFUNCTION.png TFDSQLiteFunction Win32, Win64, Linux32, Linux64, MacOS, iOS, Android This class implements the custom SQLite function (see more).
TADSQLITESECURITY.png TFDSQLiteSecurity Win32, Win64, Linux32, Linux64, MacOS, iOS, Android This class allows you to manage the SQLite database encryption (see more).
TADSQLITEVALIDATE.png TFDSQLiteValidate Win32, Win64, Linux32, Linux64, MacOS, iOS, Android This class implements the SQLite database validate service (see more).
TADSQLITERTREE.png TFDSQLiteRTree Win32, Win64, Linux32, Linux64, MacOS, iOS, Android This class implements the custom SQLite RTree (see more).