# FireDAC - Components

FireDAC comes with a lot of non visual database components, these components could be divided into below categories : 

- FireDAC Core Components.
- FireDAC Driver Link Components.
- FireDAC Monitor Link Components.
- FireDAC UI Components.
- FireDAC Service Components.
- FireDAC ETL Components.
- FireDAC NoSQL Components.

Now we will deep dive describing the components available for each category. 

### FireDAC Core Components 
The following classes are the FireDAC core components
<table border="1" frame="hsides" rules="rows">
<tbody><tr>
<th><b>Name</b>
</th>
<th><b>Platforms</b>
</th>
<th><b>Description</b>
</th></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.Client.TFDManager" class="extiw" title="lib en:FireDAC.Comp.Client.TFDManager">TFDManager</a>
</td>
<td align="left" valign="top">All
</td>
<td align="left" valign="top">Responsible for connection definitions  and connections management.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.Client.TFDConnection" class="extiw" title="lib en:FireDAC.Comp.Client.TFDConnection">TFDConnection</a>
</td>
<td align="left" valign="top">All
</td>
<td align="left" valign="top">Responsible for connection establishment with a DBMS.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.Client.TFDTransaction" class="extiw" title="lib en:FireDAC.Comp.Client.TFDTransaction">TFDTransaction</a>
</td>
<td align="left" valign="top">All
</td>
<td align="left" valign="top">Responsible for connection transaction management.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.Client.TFDCommand" class="extiw" title="lib en:FireDAC.Comp.Client.TFDCommand">TFDCommand</a>
</td>
<td align="left" valign="top">All
</td>
<td align="left" valign="top">Responsible for executing SQL commands.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.Client.TFDTableAdapter" class="extiw" title="lib en:FireDAC.Comp.Client.TFDTableAdapter">TFDTableAdapter</a>
</td>
<td align="left" valign="top">All
</td>
<td align="left" valign="top">Binds TFDCommand and TFDMemTable.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.Client.TFDSchemaAdapter" class="extiw" title="lib en:FireDAC.Comp.Client.TFDSchemaAdapter">TFDSchemaAdapter</a>
</td>
<td align="left" valign="top">All
</td>
<td align="left" valign="top">Binds several datasets into a single in-memory storage and builds a centralized change log.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.Client.TFDMemTable" class="extiw" title="lib en:FireDAC.Comp.Client.TFDMemTable">TFDMemTable</a>
</td>
<td align="left" valign="top">All
</td>
<td align="left" valign="top">Implements an in-memory dataset.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.Client.TFDQuery" class="extiw" title="lib en:FireDAC.Comp.Client.TFDQuery">TFDQuery</a>
</td>
<td align="left" valign="top">All
</td>
<td align="left" valign="top">Implements a dataset that can execute SQL queries .
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.Client.TFDStoredProc" class="extiw" title="lib en:FireDAC.Comp.Client.TFDStoredProc">TFDStoredProc</a>
</td>
<td align="left" valign="top">All
</td>
<td align="left" valign="top">Implements a dataset that can execute server-side stored procedures.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.Client.TFDTable" class="extiw" title="lib en:FireDAC.Comp.Client.TFDTable">TFDTable</a>
</td>
<td align="left" valign="top">All
</td>
<td align="left" valign="top">Implements a dataset that works with single database tables.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.Client.TFDUpdateSQL" class="extiw" title="lib en:FireDAC.Comp.Client.TFDUpdateSQL">TFDUpdateSQL</a>
</td>
<td align="left" valign="top">All
</td>
<td align="left" valign="top">Applies updates on behalf of queries or stored procedures that cannot post updates directly.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.BatchMove.TFDBatchMove" class="extiw" title="lib en:FireDAC.Comp.BatchMove.TFDBatchMove">TFDBatchMove</a>
</td>
<td align="left" valign="top">All
</td>
<td align="left" valign="top">Responsible for data movement between different data sources.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.Script.TFDScript" class="extiw" title="lib en:FireDAC.Comp.Script.TFDScript">TFDScript</a>
</td>
<td align="left" valign="top">All
</td>
<td align="left" valign="top">Implements a SQL script engine that can execute a series of SQL queries.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.Client.TFDMetaInfoQuery" class="extiw" title="lib en:FireDAC.Comp.Client.TFDMetaInfoQuery">TFDMetaInfoQuery</a>
</td>
<td align="left" valign="top">All
</td>
<td align="left" valign="top">Implements a dataset that can execute meta-info queries.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.Client.TFDEventAlerter" class="extiw" title="lib en:FireDAC.Comp.Client.TFDEventAlerter">TFDEventAlerter</a>
</td>
<td align="left" valign="top">All
</td>
<td align="left" valign="top">Responsible for handling the database event notifications.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.SQLiteVDataSet.TFDLocalSQL" class="extiw" title="lib en:FireDAC.Phys.SQLiteVDataSet.TFDLocalSQL">TFDLocalSQL</a>
</td>
<td align="left" valign="top">All
</td>
<td align="left" valign="top">Implements the Local SQL engine, which can execute the SQL queries with TDataSet descendants as data sources.
</td></tr></tbody></table>

### Driver Link Components 
FireDAC supports various databases maintaining their inherent features. To connect with various databases, FireDAC has provided one driver link component per supported database.

<table border="1" frame="hsides" rules="rows">
<tbody><tr>
<th><b>Name</b>
</th>
<th><b>Platforms</b>
</th>
<th><b>Description</b>
</th></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.ADS.TFDPhysADSDriverLink" class="extiw" title="lib en:FireDAC.Phys.ADS.TFDPhysADSDriverLink">TFDPhysADSDriverLink</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux
</td>
<td align="left" valign="top">Use TFDPhysADSDriverLink to link the Advantage Database Server driver (which you should set up) to an application.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.ASA.TFDPhysASADriverLink" class="extiw" title="lib en:FireDAC.Phys.ASA.TFDPhysASADriverLink">TFDPhysASADriverLink</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS
</td>
<td align="left" valign="top">Use TFDPhysASADriverLink to link the Sybase SQL Anywhere driver (which you should set up) to an application.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.DS.TFDPhysDSDriverLink" class="extiw" title="lib en:FireDAC.Phys.DS.TFDPhysDSDriverLink">TFDPhysDSDriverLink</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS, iOS, Android
</td>
<td align="left" valign="top">Use TFDPhysDataSnapDriverLink to link the Multi-Tier DataSnap driver (which you should set up) to an application.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.DB2.TFDPhysDB2DriverLink" class="extiw" title="lib en:FireDAC.Phys.DB2.TFDPhysDB2DriverLink">TFDPhysDB2DriverLink</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux
</td>
<td align="left" valign="top">Use TFDPhysDB2DriverLink to link the IBM DB2 driver (which you should set up) to an application.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.FB.TFDPhysFBDriverLink" class="extiw" title="lib en:FireDAC.Phys.FB.TFDPhysFBDriverLink">TFDPhysFBDriverLink</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS
</td>
<td align="left" valign="top">Use TFDPhysFBDriverLink to link the Firebird driver (which you should set up) to an application.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.IB.TFDPhysIBDriverLink" class="extiw" title="lib en:FireDAC.Phys.IB.TFDPhysIBDriverLink">TFDPhysIBDriverLink</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS, iOS, Android
</td>
<td align="left" valign="top">Use TFDPhysIBDriverLink to link the Interbase driver (which you should set up) to an application.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.Infx.TFDPhysInfxDriverLink" class="extiw" title="lib en:FireDAC.Phys.Infx.TFDPhysInfxDriverLink">TFDPhysInfxDriverLink</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux
</td>
<td align="left" valign="top">Use TFDPhysInfxDriverLink to link the Informix driver (which you should set up) to an application.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.MSAcc.TFDPhysMSAccessDriverLink" class="extiw" title="lib en:FireDAC.Phys.MSAcc.TFDPhysMSAccessDriverLink">TFDPhysMSAccessDriverLink</a>
</td>
<td align="left" valign="top">Win32, Win64
</td>
<td align="left" valign="top">Use TFDPhysMSAccessDriverLink to link the Microsoft Access driver (which you should set up) to an application.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.MSSQL.TFDPhysMSSQLDriverLink" class="extiw" title="lib en:FireDAC.Phys.MSSQL.TFDPhysMSSQLDriverLink">TFDPhysMSSQLDriverLink</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS
</td>
<td align="left" valign="top">Use TFDPhysMSSQLDriverLink to link the Microsoft SQL Server driver (which you should set up) to an application.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.MySQL.TFDPhysMySQLDriverLink" class="extiw" title="lib en:FireDAC.Phys.MySQL.TFDPhysMySQLDriverLink">TFDPhysMySQLDriverLink</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS
</td>
<td align="left" valign="top">Use TFDPhysMySQLDriverLink to link the MySQL Server driver (which you should set up) to an application.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.ODBC.TFDPhysODBCDriverLink" class="extiw" title="lib en:FireDAC.Phys.ODBC.TFDPhysODBCDriverLink">TFDPhysODBCDriverLink</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS
</td>
<td align="left" valign="top">Use TFDPhysODBCDriverLink to link the ODBC bridge driver to an application.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.Oracle.TFDPhysOracleDriverLink" class="extiw" title="lib en:FireDAC.Phys.Oracle.TFDPhysOracleDriverLink">TFDPhysOracleDriverLink</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS
</td>
<td align="left" valign="top">Use TFDPhysOracleDriverLink to link the Oracle Database driver (which you should set up) to an application.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.PG.TFDPhysPgDriverLink" class="extiw" title="lib en:FireDAC.Phys.PG.TFDPhysPgDriverLink">TFDPhysPgDriverLink</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS
</td>
<td align="left" valign="top">Use TFDPhysPgDriverLink to link the PostgreSQL driver (which you should set up) to an application.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.SQLite.TFDPhysSQLiteDriverLink" class="extiw" title="lib en:FireDAC.Phys.SQLite.TFDPhysSQLiteDriverLink">TFDPhysSQLiteDriverLink</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS, iOS, Android
</td>
<td align="left" valign="top">Use TFDPhysSQLiteDriverLink to link the SQLite driver (which you should set up) to an application.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.TData.TFDPhysTDataDriverLink" class="extiw" title="lib en:FireDAC.Phys.TData.TFDPhysTDataDriverLink">TFDPhysTDataDriverLink</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS
</td>
<td align="left" valign="top">Use TFDPhysTDataDriverLink to link the Teradata Database driver (which you should set up) to an application.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.TDBX.TFDPhysTDBXDriverLink" class="extiw" title="lib en:FireDAC.Phys.TDBX.TFDPhysTDBXDriverLink">TFDPhysTDBXDriverLink</a>
</td>
<td align="left" valign="top">Win32, Win64, macOS, iOS, Android
</td>
<td align="left" valign="top">Use TFDPhysTDBXDriverLink to link the dbExpress v 4 bridge driver to an application.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.MongoDB.TFDPhysMongoDriverLink" class="extiw" title="lib en:FireDAC.Phys.MongoDB.TFDPhysMongoDriverLink">TFDPhysMongoDriverLink</a>
</td>
<td align="left" valign="top">Win32, Win64, macOS
</td>
<td align="left" valign="top">Use TFDPhysMongoDriverLink to link the MongoDB driver to an application.
</td></tr></tbody></table>


<h2><span class="mw-headline" id="FireDAC_Monitor_Link_Components">FireDAC Monitor Link Components</span></h2>
<p>To enforce tracing capabilities, applications can use one of the monitor components in the following table.
</p>

<table border="1" frame="hsides" rules="rows">
<tbody><tr>
<th><b>Name</b>
</th>
<th><b>Platforms</b>
</th>
<th><b>Description</b>
</th></tr>
<tr>
<td align="left" valign="top">TFDMoniFlatFileClientLink
</td>
<td align="left" valign="top">All
</td>
<td align="left" valign="top">Use TFDMoniFlatFileClientLink to link the file tracing capabilities (which you should set up) to an application .
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Moni.RemoteClient.TFDMoniRemoteClientLink" class="extiw" title="lib en:FireDAC.Moni.RemoteClient.TFDMoniRemoteClientLink">TFDMoniRemoteClientLink</a>
</td>
<td align="left" valign="top">Win32, Win64
</td>
<td align="left" valign="top">Use TFDMoniRemoteClientLink to link the <a href="/RADStudio/Sydney/en/FDMonitor" title="FDMonitor">FDMonitor</a> tracing capabilities (which you should set up) to an application .
</td></tr>
<tr>
<td align="left" valign="top">TFDMoniCustomClientLink
</td>
<td align="left" valign="top">All
</td>
<td align="left" valign="top">Use TFDMoniCustomClientLink to link custom tracing capabilities (which you should set up) to an application .
</td></tr></tbody></table>


<h2><span class="mw-headline" id="FireDAC_UI_Components">FireDAC UI Components</span></h2>

  <p>Most of the applications use TFDGUIxWaitCursor and TFDGUIxLoginDialog.
</p>

<table border="1" frame="hsides" rules="rows">
<tbody><tr>
<th><b>Name</b>
</th>
<th><b>Platforms</b>
</th>
<th><b>Description</b>
</th></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.UI.TFDGUIxAsyncExecuteDialog" class="extiw" title="lib en:FireDAC.Comp.UI.TFDGUIxAsyncExecuteDialog">TFDGUIxAsyncExecuteDialog</a>
</td>
<td align="left" valign="top"><span class="rsonly"> VCL, </span> FireMonkey
</td>
<td align="left" valign="top">This dialog shows an SQL query execution progress .
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.UI.TFDGUIxErrorDialog" class="extiw" title="lib en:FireDAC.Comp.UI.TFDGUIxErrorDialog">TFDGUIxErrorDialog</a>
</td>
<td align="left" valign="top"><span class="rsonly">VCL,</span> FireMonkey
</td>
<td align="left" valign="top">This dialog displays the FireDAC exceptions .
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.UI.TFDGUIxLoginDialog" class="extiw" title="lib en:FireDAC.Comp.UI.TFDGUIxLoginDialog">TFDGUIxLoginDialog</a>
</td>
<td align="left" valign="top"><span class="rsonly">VCL,</span> FireMonkey
</td>
<td align="left" valign="top">This dialog allows the users to enter their DB credentials.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.UI.TFDGUIxScriptDialog" class="extiw" title="lib en:FireDAC.Comp.UI.TFDGUIxScriptDialog">TFDGUIxScriptDialog</a>
</td>
<td align="left" valign="top"><span class="rsonly">VCL, </span>FireMonkey, Console
</td>
<td align="left" valign="top">This dialog shows an SQL script execution progress .
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.UI.TFDGUIxWaitCursor" class="extiw" title="lib en:FireDAC.Comp.UI.TFDGUIxWaitCursor">TFDGUIxWaitCursor</a>
</td>
<td align="left" valign="top"><span class="rsonly">VCL, </span>FireMonkey, Console
</td>
<td align="left" valign="top">This component allows the control of the wait cursor.
</td></tr></tbody></table>

### FireDAC Service Components
An application uses service components to add a specific DBMS facility support
<table border="1" frame="hsides" rules="rows">
<tbody><tr>
<th><b>Name</b>
</th>
<th><b>Platforms</b>
</th>
<th><b>Description</b>
</th></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.ADS.TFDADSBackup" class="extiw" title="lib en:FireDAC.Phys.ADS.TFDADSBackup">TFDADSBackup</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux
</td>
<td align="left" valign="top">This class implements the Advantage backup database service.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.ADS.TFDADSRestore" class="extiw" title="lib en:FireDAC.Phys.ADS.TFDADSRestore">TFDADSRestore</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux
</td>
<td align="left" valign="top">This class implements the Advantage service, by restoring a database from a backup.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.ADS.TFDADSUtility" class="extiw" title="lib en:FireDAC.Phys.ADS.TFDADSUtility">TFDADSUtility</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux
</td>
<td align="left" valign="top">This class implements the Advantage table utilities.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.ASA.TFDASABackup" class="extiw" title="lib en:FireDAC.Phys.ASA.TFDASABackup">TFDASABackup</a>
</td>
<td align="left" valign="top">Win32
</td>
<td align="left" valign="top">This class implements the SQL Anywhere backup database service.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.ASA.TFDASAValidate" class="extiw" title="lib en:FireDAC.Phys.ASA.TFDASAValidate">TFDASAValidate</a>
</td>
<td align="left" valign="top">Win32
</td>
<td align="left" valign="top">This class implements the SQL Anywhere database validate service.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.IBBase.TFDIBBackup" class="extiw" title="lib en:FireDAC.Phys.IBBase.TFDIBBackup">TFDIBBackup</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS, iOS, Android
</td>
<td align="left" valign="top">This class implements the Firebird/InterBase backup database service.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.IBBase.TFDIBConfig" class="extiw" title="lib en:FireDAC.Phys.IBBase.TFDIBConfig">TFDIBConfig</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS, iOS, Android
</td>
<td align="left" valign="top">This class implements the Firebird/InterBase setting database properties service.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.IBBase.TFDIBInfo" class="extiw" title="lib en:FireDAC.Phys.IBBase.TFDIBInfo">TFDIBInfo</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS, iOS, Android
</td>
<td align="left" valign="top">This class implements the Firebird/InterBase service to query the service manager.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.IBBase.TFDIBRestore" class="extiw" title="lib en:FireDAC.Phys.IBBase.TFDIBRestore">TFDIBRestore</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS, iOS, Android
</td>
<td align="left" valign="top">This class implements the Firebird/InterBase service, by restoring a database from a backup.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.IBBase.TFDIBSecurity" class="extiw" title="lib en:FireDAC.Phys.IBBase.TFDIBSecurity">TFDIBSecurity</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS, iOS, Android
</td>
<td align="left" valign="top">This class implements the Firebird/InterBase database security management service.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.IBBase.TFDIBValidate" class="extiw" title="lib en:FireDAC.Phys.IBBase.TFDIBValidate">TFDIBValidate</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS, iOS, Android
</td>
<td align="left" valign="top">This class implements the Firebird/InterBase database validate and repair service.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.IB.TFDIBSDump" class="extiw" title="lib en:FireDAC.Phys.IB.TFDIBSDump">TFDIBSDump</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS, iOS, Android
</td>
<td align="left" valign="top">This class implements the InterBase-only database dump service.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.FB.TFDFBNBackup" class="extiw" title="lib en:FireDAC.Phys.FB.TFDFBNBackup">TFDFBNBackup</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS
</td>
<td align="left" valign="top">This class implements the Firebird-only backup database service.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.FB.TFDFBNRestore" class="extiw" title="lib en:FireDAC.Phys.FB.TFDFBNRestore">TFDFBNRestore</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS
</td>
<td align="left" valign="top">This class implements the Firebird-only restore database service.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.FB.TFDFBTrace" class="extiw" title="lib en:FireDAC.Phys.FB.TFDFBTrace">TFDFBTrace</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS
</td>
<td align="left" valign="top">This class implements the Firebird database trace service.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.MSAcc.TFDMSAccessService" class="extiw" title="lib en:FireDAC.Phys.MSAcc.TFDMSAccessService">TFDMSAccessService</a>
</td>
<td align="left" valign="top">Win32, Win64
</td>
<td align="left" valign="top">This class implements the Microsoft Access database. It also creates, drops, compacts, and repairs the services.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.Oracle.TFDOracleAdmin" class="extiw" title="lib en:FireDAC.Phys.Oracle.TFDOracleAdmin">TFDOracleAdmin</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS, iOS, Android
</td>
<td align="left" valign="top">This class implements a service to manage an <a target="_blank" rel="nofollow noreferrer noopener" class="external text" href="https://docs.oracle.com/cd/E11882_01/server.112/e40540/startup.htm#CNCPT005">Oracle database instance</a>.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.SQLite.TFDSQLiteBackup" class="extiw" title="lib en:FireDAC.Phys.SQLite.TFDSQLiteBackup">TFDSQLiteBackup</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS, iOS, Android
</td>
<td align="left" valign="top">This class implements SQLite backup. It also restores and copies the database functionality.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.SQLite.TFDSQLiteCollation" class="extiw" title="lib en:FireDAC.Phys.SQLite.TFDSQLiteCollation">TFDSQLiteCollation</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS, iOS, Android
</td>
<td align="left" valign="top">This class implements the custom SQLite collation.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.SQLite.TFDSQLiteFunction" class="extiw" title="lib en:FireDAC.Phys.SQLite.TFDSQLiteFunction">TFDSQLiteFunction</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS, iOS, Android
</td>
<td align="left" valign="top">This class implements the custom SQLite function.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.SQLite.TFDSQLiteSecurity" class="extiw" title="lib en:FireDAC.Phys.SQLite.TFDSQLiteSecurity">TFDSQLiteSecurity</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS, iOS, Android
</td>
<td align="left" valign="top">This class allows you to manage the SQLite database encryption.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.SQLite.TFDSQLiteValidate" class="extiw" title="lib en:FireDAC.Phys.SQLite.TFDSQLiteValidate">TFDSQLiteValidate</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS, iOS, Android
</td>
<td align="left" valign="top">This class implements the SQLite database validate service.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.SQLite.TFDSQLiteRTree" class="extiw" title="lib en:FireDAC.Phys.SQLite.TFDSQLiteRTree">TFDSQLiteRTree</a>
</td>
<td align="left" valign="top">Win32, Win64, Linux, macOS, iOS, Android
</td>
<td align="left" valign="top">This class implements the custom SQLite RTree.
</td></tr></tbody></table>


<h2><span class="mw-headline" id="FireDAC_ETL_Components">FireDAC ETL Components</span></h2>
<p>An application uses the ETL components for data movement between different types of data sources and the data destinations.
</p>

<table border="1" frame="hsides" rules="rows">
<tbody><tr>
<th><b>Name</b>
</th>
<th><b>Platforms</b>
</th>
<th><b>Description</b>
</th></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.BatchMove.TFDBatchMove" class="extiw" title="lib en:FireDAC.Comp.BatchMove.TFDBatchMove">TFDBatchMove</a>
</td>
<td align="left" valign="top">Win32, Win64, macOS, iOS, Android, iOS Simulator
</td>
<td align="left" valign="top">This class implements the engine to process the data movement between different data source and destinations.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.BatchMove.Text.TFDBatchMoveTextReader" class="extiw" title="lib en:FireDAC.Comp.BatchMove.Text.TFDBatchMoveTextReader">TFDBatchMoveTextReader</a>
</td>
<td align="left" valign="top">Win32, Win64, macOS, iOS, Android, iOS Simulator
</td>
<td align="left" valign="top">This class defines a data source reader using a text file.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.BatchMove.Text.TFDBatchMoveTextWriter" class="extiw" title="lib en:FireDAC.Comp.BatchMove.Text.TFDBatchMoveTextWriter">TFDBatchMoveTextWriter</a>
</td>
<td align="left" valign="top">Win32, Win64, macOS, iOS, Android, iOS Simulator
</td>
<td align="left" valign="top">This class defines a data target writer using a text file.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.BatchMove.DataSet.TFDBatchMoveDataSetReader" class="extiw" title="lib en:FireDAC.Comp.BatchMove.DataSet.TFDBatchMoveDataSetReader">TFDBatchMoveDataSetReader</a>
</td>
<td align="left" valign="top">Win32, Win64, macOS, iOS, Android, iOS Simulator
</td>
<td align="left" valign="top">This class defines a source dataset.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.BatchMove.DataSet.TFDBatchMoveDataSetWriter" class="extiw" title="lib en:FireDAC.Comp.BatchMove.DataSet.TFDBatchMoveDataSetWriter">TFDBatchMoveDataSetWriter</a>
</td>
<td align="left" valign="top">Win32, Win64, macOS, iOS, Android, iOS Simulator
</td>
<td align="left" valign="top">This class defines a destination dataset.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.BatchMove.SQL.TFDBatchMoveSQLReader" class="extiw" title="lib en:FireDAC.Comp.BatchMove.SQL.TFDBatchMoveSQLReader">TFDBatchMoveSQLReader</a>
</td>
<td align="left" valign="top">Win32, Win64, macOS, iOS, Android, iOS Simulator
</td>
<td align="left" valign="top">This class connects to the database that contains the data to copy.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Comp.BatchMove.SQL.TFDBatchMoveSQLWriter" class="extiw" title="lib en:FireDAC.Comp.BatchMove.SQL.TFDBatchMoveSQLWriter">TFDBatchMoveSQLWriter</a>
</td>
<td align="left" valign="top">Win32, Win64, macOS, iOS, Android, iOS Simulator
</td>
<td align="left" valign="top">This class  connects to the database where you want to copy the data.
</td></tr></tbody></table>


<h2><span class="mw-headline" id="FireDAC_NoSQL_Components">FireDAC NoSQL Components</span></h2>

<p>An application uses the NoSQL components to work with NoSQL document databases.
</p>

<table border="1" frame="hsides" rules="rows">
<tbody><tr>
<th><b>Name</b>
</th>
<th><b>Platforms</b>
</th>
<th><b>Description</b>
</th></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.MongoDBDataSet.TFDMongoDataSet" class="extiw" title="lib en:FireDAC.Phys.MongoDBDataSet.TFDMongoDataSet">TFDMongoDataSet</a>
</td>
<td align="left" valign="top">Win32, Win64, macOS
</td>
<td align="left" valign="top">This class implements aa dataset that can be attached to a MongoDB cursor.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.MongoDBDataSet.TFDMongoQuery" class="extiw" title="lib en:FireDAC.Phys.MongoDBDataSet.TFDMongoQuery">TFDMongoQuery</a>
</td>
<td align="left" valign="top">Win32, Win64, macOS
</td>
<td align="left" valign="top">This class implements a dataset that can execute MongoDB queries.
</td></tr>
<tr>
<td align="left" valign="top"><a href="http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Phys.MongoDBDataSet.TFDMongoPipeline" class="extiw" title="lib en:FireDAC.Phys.MongoDBDataSet.TFDMongoPipeline">TFDMongoPipeline</a>
</td>
<td align="left" valign="top">Win32, Win64, macOS
</td>
<td align="left" valign="top">This class allows to execute a MongoDB pipeline.
</td></tr></tbody></table>

