Components (FireDAC)

Go Up to Architecture (FireDAC)

FireDAC includes more than 60 Delphi 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
TFDManager	All	Responsible for connection definitions (see more) and connections management.
TFDConnection	All	Responsible for connection establishment (see more) with a DBMS.
TFDTransaction	All	Responsible for connection transaction management (see more).
TFDCommand	All	Responsible for executing SQL commands (see more).
TFDTableAdapter	All	Binds TFDCommand and TFDMemTable.
TFDSchemaAdapter	All	Binds several datasets into a single in-memory storage and builds a centralized change log.
TFDMemTable	All	Implements an in-memory dataset.
TFDQuery	All	Implements a dataset that can execute SQL queries (see more).
TFDStoredProc	All	Implements a dataset that can execute server-side stored procedures (see more).
TFDTable	All	Implements a dataset that works with single database tables (see more).
TFDUpdateSQL	All	Applies updates on behalf of queries or stored procedures that cannot post updates directly (see more).
TFDDataMove	All	Responsible for data movement between different data sources.
TFDScript	All	Implements a SQL script engine that can execute a series of SQL queries (see more).
TFDMetaInfoQuery	All	Implements a dataset that can execute meta-info queries (see more).
TFDEventAlerter	All	Responsible for handling the database event notifications (see more).
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
TFDPhysADSDriverLink	Win32, Win64,	Use TFDPhysADSDriverLink to link the Advantage Database Server driver (which you should set up) to an application (see more).
TFDPhysASADriverLink	Win32, Win64, OS X	Use TFDPhysASADriverLink to link the Sybase SQL Anywhere driver (which you should set up) to an application (see more).
TFDPhysDSDriverLink	Win32, Win64, OS X, iOS, Android	Use TFDPhysDataSnapDriverLink to link the Multi-Tier DataSnap driver (which you should set up) to an application (see more).
TFDPhysDB2DriverLink	Win32, Win64,	Use TFDPhysDB2DriverLink to link the IBM DB2 driver (which you should set up) to an application (see more).
TFDPhysFBDriverLink	Win32, Win64, OS X	Use TFDPhysFBDriverLink to link the Firebird driver (which you should set up) to an application (see more).
TFDPhysIBDriverLink	Win32, Win64, OS X, iOS, Android	Use TFDPhysIBDriverLink to link the Interbase driver (which you should set up) to an application (see more).
TFDPhysInfxDriverLink	Win32, Win64,	Use TFDPhysInfxDriverLink to link the Informix driver (which you should set up) to an application (see more).
TFDPhysMSAccessDriverLink	Win32, Win64	Use TFDPhysMSAccessDriverLink to link the Microsoft Access driver (which you should set up) to an application (see more).
TFDPhysMSSQLDriverLink	Win32, Win64, OS X	Use TFDPhysMSSQLDriverLink to link the Microsoft SQL Server driver (which you should set up) to an application (see more).
TFDPhysMySQLDriverLink	Win32, Win64, OS X	Use TFDPhysMySQLDriverLink to link the MySQL Server driver (which you should set up) to an application (see more).
TFDPhysODBCDriverLink	Win32, Win64, OS X	Use TFDPhysODBCDriverLink to link the ODBC bridge driver to an application (see more).
TFDPhysOracleDriverLink	Win32, Win64, OS X	Use TFDPhysOracleDriverLink to link the Oracle Database driver (which you should set up) to an application (see more).
TFDPhysPgDriverLink	Win32, Win64, OS X	Use TFDPhysPgDriverLink to link the PostgreSQL driver (which you should set up) to an application (see more).
TFDPhysSQLiteDriverLink	Win32, Win64, OS X, iOS, Android	Use TFDPhysSQLiteDriverLink to link the SQLite driver (which you should set up) to an application (see more here and here).
TFDPhysTDataDriverLink	Win32, Win64, OS X	Use TFDPhysTDataDriverLink to link the Teradata Database driver (which you should set up) to an application (see more).
TFDPhysTDBXDriverLink	Win32, Win64, OS X, iOS, Android	Use TFDPhysTDBXDriverLink to link the dbExpress v 4 bridge driver to an application (see more).
TFDPhysMongoDriverLink	Win32, Win64, OS X	Use TFDPhysMongoDriverLink to link the MongoDB driver to an application (see more).

FireDAC Monitor Link Components

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

Name	Platforms	Description
TFDMoniFlatFileClientLink	All	Use TFDMoniFlatFileClientLink to link the file tracing capabilities (which you should set up) to an application (see more).
TFDMoniRemoteClientLink	Win32, Win64	Use TFDMoniRemoteClientLink to link the FDMonitor tracing capabilities (which you should set up) to an application (see more).
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
TFDGUIxAsyncExecuteDialog	VCL, FireMonkey	This dialog shows an SQL query execution progress (see more).
TFDGUIxErrorDialog	VCL, FireMonkey	This dialog displays the FireDAC exceptions (see more).
TFDGUIxLoginDialog	VCL, FireMonkey	This dialog allows the users to enter their DB credentials (see more).
TFDGUIxScriptDialog	VCL, FireMonkey, Console	This dialog shows an SQL script execution progress (see more).
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
TFDADSBackup	Win32, Win64,	This class implements the Advantage backup database service.
TFDADSRestore	Win32, Win64,	This class implements the Advantage service, by restoring a database from a backup.
TFDADSUtility	Win32, Win64,	This class implements the Advantage table utilities.
TFDASABackup	Win32	This class implements the SQL Anywhere backup database service.
TFDASAValidate	Win32	This class implements the SQL Anywhere database validate service.
TFDIBBackup	Win32, Win64, OS X, iOS, Android	This class implements the FB/IB backup database service.
TFDIBConfig	Win32, Win64, OS X, iOS, Android	This class implements the FB/IB setting database properties service.
TFDIBInfo	Win32, Win64, OS X, iOS, Android	This class implements the FB/IB service to query the service manager.
TFDIBRestore	Win32, Win64, OS X, iOS, Android	This class implements the FB/IB service, by restoring a database from a backup.
TFDIBSecurity	Win32, Win64, OS X, iOS, Android	This class implements the FB/IB database security management service.
TFDIBValidate	Win32, Win64, OS X, iOS, Android	This class implements the FB/IB database validate and repair service.
TFDIBSDump	Win32, Win64, OS X, iOS, Android	This class implements the InterBase-only database dump service.
TFDFBNBackup	Win32, Win64, OS X	This class implements the Firebird-only backup database service.
TFDFBNRestore	Win32, Win64, OS X	This class implements the Firebird-only restore database service.
TFDFBTrace	Win32, Win64, OS X	This class implements the Firebird database trace service.
TFDMSAccessService	Win32, Win64	This class implements the Microsoft Access database. It also creates, drops, compacts, and repairs the services.
TFDOracleAdmin	Win32, Win64, OS X, iOS, Android	This class implements a service to manage an Oracle database instance.
TFDSQLiteBackup	Win32, Win64, OS X, iOS, Android	This class implements SQLite backup. It also restores and copies the database functionality (see more).
TFDSQLiteCollation	Win32, Win64, OS X, iOS, Android	This class implements the custom SQLite collation (see more).
TFDSQLiteFunction	Win32, Win64, OS X, iOS, Android	This class implements the custom SQLite function (see more).
TFDSQLiteSecurity	Win32, Win64, OS X, iOS, Android	This class allows you to manage the SQLite database encryption (see more).
TFDSQLiteValidate	Win32, Win64, OS X, iOS, Android	This class implements the SQLite database validate service (see more).
TFDSQLiteRTree	Win32, Win64, OS X, iOS, Android	This class implements the custom SQLite RTree (see more).

FireDAC ETL Components

An application uses the ETL components for data movement between different types of data sources and the data destinations.

Name	Platforms	Description
TFDBatchMove	Win32, Win64, OS X, iOS, Android, iOS Simulator	This class implements the engine to process the data movement between different data source and destinations.
TFDBatchMoveTextReader	Win32, Win64, OS X, iOS, Android, iOS Simulator	This class defines a data source reader using a text file.
TFDBatchMoveTextWriter	Win32, Win64, OS X, iOS, Android, iOS Simulator	This class defines a data target writer using a text file.
TFDBatchMoveDataSetReader	Win32, Win64, OS X, iOS, Android, iOS Simulator	This class defines a source dataset.
TFDBatchMoveDataSetWriter	Win32, Win64, OS X, iOS, Android, iOS Simulator	This class defines a destination dataset.
TFDBatchMoveSQLReader	Win32, Win64, OS X, iOS, Android, iOS Simulator	This class connects to the database that contains the data to copy.
TFDBatchMoveSQLWriter	Win32, Win64, OS X, iOS, Android, iOS Simulator	This class connects to the database where you want to copy the data.

FireDAC NoSQL Components

An application uses the NoSQL components to work with NoSQL document databases.

Name	Platforms	Description
TFDMongoDataSet	Win32, Win64, OS X	This class implements aa dataset that can be attached to a MongoDB cursor.
TFDMongoQuery	Win32, Win64, OS X	This class implements a dataset that can execute MongoDB queries.
TFDMongoPipeline	Win32, Win64, OS X	This class allows to execute a MongoDB pipeline.