Show: Object Pascal C++
Display Preferences

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
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.
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.
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.
Personal tools
In other languages