Databases (FireDAC)

Go Up to Architecture (FireDAC)

FireDAC supports a wide range of Database Management Systems (DBMS).

Native Connections

For additional information, including support for other platforms, click the links in the "Name" column.

Name	Server and client version	Platforms	Required libraries (Client)	Driver link component, Driver implementation unit	DriverID parameter
Advantage Database Server	Server and client v 8.0 and higher	Win32	ace32.dll	TFDPhysADSDriverLink, FireDAC.Phys.ADS	ADS
		Win64	ace64.dll
Sybase SQL Anywhere (*)	Server and client v 5.0.0 and higher	Win32	Adaptive Server Anywhere ODBC driver (x86) to connect to v 5-7 SQL Anywhere N ODBC driver (x86)	TFDPhysASADriverLink, FireDAC.Phys.ASA	ASA
		Win64	Adaptive Server Anywhere ODBC driver (x64) to connect to v 5-7 SQL Anywhere N ODBC driver (x64)
		MacOS	UnixODBC (libodbc.dylib) x86 ODBC driver manager library. SQL Anywhere (libdbodbcNN.so) x86 ODBC driver.
IBM DB2 Server	Server and client v 8.1 and higher	Win32	IBM DATA SERVER driver for ODBC IBM DB2 ODBC driver IBM DB2 driver for ODBC (x86)	TFDPhysDB2DriverLink, FireDAC.Phys.DB2	DB2
		Win64	IBM DATA SERVER driver for ODBC IBM DB2 ODBC driver IBM DB2 driver for ODBC (x64)
DataSnap Server	DataSnap server built with RAD Studio 2007 and higher. DataSnap client built with RAD Studio XE2 Enterprise and higher	Win32	DataSnap dbExpress driver is statically linked. No additional libraries required.	TFDPhysDSDriverLink, FireDAC.Phys.DS	DataSnap
		Win64
		MacOS
		iOSDevice32 iOSDevice64
		Android
Firebird	Firebird and fbclient.dll v 1.5 and higher	Win32	fbclient.dll (x86) to connect to Firebird server fbembed.dll (x86) to connect to Firebird Embedded server	TFDPhysFBDriverLink, FireDAC.Phys.FB	FB
		Win64	fbclient.dll (x64) to connect to Firebird server fbembed.dll (x64) to connect to Firebird Embedded server
		MacOS	libfbclient.dylib (x86)
InterBase Server	Interbase v 6 and higher	Win32	gds32.dll	TFDPhysIBDriverLink, FireDAC.Phys.IB	IB
		Win64	ibclient64.dll
		MacOS iOS Simulator	libgsds.dylib
		iOSDevice32 iOSDevice64	libibtogo.a
		Android	libibtogo.a
InterBase Lite / InterBase ToGo	Interbase v 6 and higher	Win32	ibtogo.dll	TFDPhysIBDriverLink, FireDAC.Phys.IB	IBLite
		Win64	ibtogo64.dll
		MacOS	libibtogo.dylib
		iOSDevice32 iOSDevice64	libibtogo.a
		Android	libibtogo.a
Informix	Server v 8 and higher. Informix Client SDK v 3.5 and higher.	Win32	IBM INFORMIX ODBC driver	TFDPhysInfxDriverLink, FireDAC.Phys.Infx	Infx
		Win64	IBM INFORMIX ODBC driver (64-bit)
Microsoft Access Database	Microsoft Access 2000 ODBC driver v 4 from MDAC 2.8 and higher Microsoft Access 2007 ODBC driver v 12 and higher	Win32	Microsoft Access Driver (*.mdb) x86 ODBC driver version 3 or later (Microsoft JET ODBC driver) for 95-2003 databases Microsoft Access Driver (*.mdb, *.accdb) x86 ODBC driver version 12 or later for 95-2010 databases	TFDPhysMSAccessDriverLink, FireDAC.Phys.MSAcc	MSAcc
		Win64	Microsoft Access Driver (*.mdb, *.accdb) x64 ODBC driver version 12 or later for 95-2010 databases
Microsoft SQL Server	Microsoft SQL Server 2000, ODBC driver from MDAC 2.8 Microsoft SQL Server 2005 and higher, SQL Native Client 2005 and higher Microsoft SQL Azure, SQL Native Client 2008 and higher Microsoft LocalDB, SQL Native Client 2012 and higher	Win32	ODBC driver from MDAC 2.8 SQL Native Client 2005 and higher SQL Native Client 2008 and higher SQL Native Client 2012 and higher	TFDPhysMSSQLDriverLink, FireDAC.Phys.MSSQL	MSSQL
		Win64	ODBC driver from MDAC 2.8 SQL Native Client 2005 and higher SQL Native Client 2008 and higher SQL Native Client 2012 and higher
		MacOS	libodbc.dylib libtdsodbc.so
MySQL Server	Server and client 3.21 and higher	Win32	libmysql.dll (x86) to connect to MySQL server libmysqld.dll (x86) to connect to MySQL embedded server	TFDPhysMySQLDriverLink, FireDAC.Phys.MySQL	MySQL
		Win64	libmysql.dll (x64) to connect to MySQL server libmysqld.dll (x64) to connect to MySQL embedded server
		MacOS	libmysqlclient.dylib
Oracle Server	Server and client 8.0.3 and higher	Win32	Fat Oracle Client (x86) Thin Oracle Instant Client (x86): oci.dll, oraocci11.dll, oraociei11.dll, orasql11.dll	TFDPhysOracleDriverLink, FireDAC.Phys.Oracle	Ora
		Win64	Fat Oracle Client (x64) Thin Oracle Instant Client (x64): oci.dll, oraocci11.dll, oraociei11.dll, orasql11.dll
		MacOS	libclntsh.dylib (x86)
PostgreSQL	Server v 7.4 and higher	Win32	libpq.dll (x86)	TFDPhysPGDriverLink, FireDAC.Phys.PG	PG
		Win64	libpq.dll (x64)
		MacOS	libpq.dylib (x86)
SQLite database	SQLite database version 3.0 and later.	Win32	sqlite3_x86.obj sqlite3.dll (x86) v 3 and higher	TFDPhysSQLiteDriverLink, FireDAC.Phys.SQLite	SQLite
		Win64	sqlite3_x64.obj sqlite3.dll (x64)v 3 and higher
		MacOS	libsqlite3.dylib
		iOSDevice32 iOSDevice64	libsqlite3.dylib
		Android	sqlite.so
Teradata Database	Server and client version 13 and higher.	Win32	Teradata ODBC Driver for Windows	TFDPhysTDataDriverLink, FireDAC.Phys.TData	TData
		Win64	Teradata ODBC Driver for Windows 64
		MacOS	Teradata ODBC Driver for OS X
MongoDB Database	Server and client version 3.0 and higher.	Win32	libbson-1.0.dll libmongoc-1.0.dll msvcr100.dll	TFDPhysMongoDriverLink, FireDAC.Phys.MongoDB	Mongo
		Win64	libbson-1.0.dll libmongoc-1.0.dll msvcr100.dll
		MacOS	libbson-1.0.0.dylib libmongoc-1.0.0.dylib

Note: (*) For the required libraries (Client), N is the DBMS major version number (8, 9 or 10)

Bridge Connections

Name	Server and client version	Platforms	Required libraries (Client)	Driver link component, Driver implementation unit	DriverID parameter
dbExpress Data Source	dbExpress drivers v 1-3 (Delphi 5 to RAD Studio 2006)	Win32	dbExpress drivers v 1-3	TFDPhysDBXDriverLink, FireDAC.Phys.DBX	DBX
dbExpress Data Source	dbExpress v 4 (RAD Studio 2007 and higher) (FireDACDBXDriver<nnn>.bpl) (**)	Win32	dbExpress drivers v 4	TFDPhysTDBXDriverLink, FireDAC.Phys.TDBX	TDBX
		Win64
		MacOS
		iOSDevice32 iOSDevice64
		Android
ODBC Data Source	ODBC Level 2, 3 drivers	Win32	ODBC drivers v 1-3	TFDPhysODBCDriverLink, FireDAC.Phys.ODBC	ODBC
		Win64	ODBC drivers v 1-3
		MacOS	UnixODBC

Note: (**) The bpl includes the product version (<nnn>) in its name.

Additional Connections

• MicroFocus Cobol
• SolidDB
• Microsoft SQL Server Compact Edition
• Sybase Adaptive Server Enterprise
• Unify SQLBase

See Also

• FireDAC Architecture
• Configuring Drivers
• Defining Connection
• Demo Databases
• Working with DBMS