RAD Studio 10.3.1 ist ab sofort verfügbar! Weitere Infos

Hier finden Sie unsere aktuellen Angebote

FireDAC

Multi-Device Data Access Library


Universelle Konnektivität für Unternehmensdaten


FireDAC Architecture Diagram


FireDAC ist eine universelle Datenzugriffsbibliothek zur Entwicklung von Anwendungen für verschiedene Geräte, die mit Unternehmensdatenbanken verbunden sind. Mit seiner leistungsstarken universellen Architektur ermöglicht FireDAC einen nativen Hochgeschwindigkeits-Direktzugriff von Delphi und C++Builder auf InterBase, SQLite, MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, DB2, SQL Anywhere, Advantage DB, Firebird, Access, Informix, DataSnap und viele mehr, inklusive der NoSQL-Datenbank MongoDB.

FireDAC ist ein leistungsfähiges, aber doch einfach zu bedienendes Zugriffsmodul, das den Datenzugriff unterstützt, strukturiert und vereinfacht und dabei alle Features zur Verfügung stellt, die für das Erstellen von realen, anspruchsvollen Anwendungen notwendig sind. FireDAC bietet eine allgemeine API für den Zugriff auf unterschiedliche Datenbank-Backends, ohne auf die Verwendung datenbankspezifischer Features zu verzichten und ohne Kompromisse bei der Leistung. Verwenden Sie FireDAC für Android-, iOS-, Windows- und Mac OS X-Anwendungen, die für PCs, Tablet-Computer und Smartphones entwickelt werden.


FireDAC-Features nach der Edition von RAD Studio, Delphi und C++Builder Professional
Edition
Enterprise and Architect Editions

Local/embedded connectivity and support for certain databases

FireDAC local/embedded connectivity to certain local databases, including Microsoft Access database, SQLite database, InterBase ToGo / IBLite, InterBase on localhost, MySQL Embedded, MySQL Server on localhost, Advantage Database local engine, PostgreSQL on localhost, Firebird Embedded, and Firebird on localhost.

Local/embedded/remote connectivity and support for more databases

Full local/embedded, client/server and enterprise connectivity to all supported databases including InterBase, SQLite, MySQL, SQL Server, Oracle, PostgreSQL, DB2, SQL Anywhere, Advantage DB, Firebird, Access, Informix, DataSnap and support for ODBC to many more. Support also includes NoSQL with MongoDB.


FireDAC Features

Native Driver Support

MySQL

Microsoft SQL Server

Oracle Database

InterBase

PostgreSQL

DataSnap

SQLite

Sybase SQL Anywhere

Microsoft Access

IBM DB2 Server

Informix

Firebird

Advantage Database

Teradata (ODBC)

NoSQL Driver for MongoDB


SUPPORTED SERVICES

Backup, Restore, Security Management, and more


MOBILE DATABASE ACCESS

InterBase ToGo and IBLite

SQLite

Datenzugriffs-Engine

Die Datenmengen von FireDAC wurden in Verbindung mit einer leistungsfähigen Datenzugriffs-Engine erstellt. Diese wenig speicherintensive, effektive und flexible Engine kann direkt in Anwendungen verwendet werden und bietet eine leistungsstarke Grundlage für die Datenmengen-API. Die Engine besteht aus den Datenmengenkomponenten und den Schichten der flexiblen, objektorientierten APIs.

Easy to use TDataSet descendant classes including TFDQuery, TFDMemTable, TFDStoredProc, and TFDTable. Dataset classes that are highly compatible with original BDE datasets and ClientDataSet. One of the fastest in-memory datasets, with sorting, filtering, aggregates, filtered and expression indexes, persistence and more. Local SQL engine for executing SQL queries against datasets.

Unified API

FireDAC provides a range of features that help abstract the differences between database systems, making it easy to write code that does not have to be concerned about different DBMS dialects or other subtle differences between DBMSs.

  • SQL dialect abstraction through FireDAC escape sequences, conditional statements and macros
  • Data type unification with flexible and adjustable data type mapping
  • Unified error reporting, including DBMS-independent and DBMS-specific error information
  • Unified transaction support, with separate read and update transactions, and access to the full power of the specific transactions support of InterBase and Firebird
  • Support for multiple Unicode and ANSI encodings
  • Automatic connection recovery, automatically re-establishing the connection in case of an unstable environment
  • Disconnected connection mode, allowing application to continue to work without a physical connection to a database
  • Database events and notifications support
  • Unified SQL scripts support
  • Extended metadata retrieval capabilities

High-Performance Data Access

Database access is optimized using many different techniques often found only in database-specific components, which let you get faster data access out of the box.

  • Live Data Window mode enabling fast bi-directional navigation through large datasets
  • Array Data Manipulation Language (DML) command execution and Command Batches for batch applications and for minimizing network traffic
  • Customizable and flexible "row set" fetching
  • Direct support for asynchronous command execution, command execution timeout, and command execution canceling
  • Automatic, efficient and sophisticated update command generation and execution
  • Cached updates mode with ability to track correlated changes for several datasets with cascading updates
  • Full support for auto-incrementing fields, including those based on generators and table triggers

Get started with FireDAC today

Check out the FireDAC FAQ for answers to frequently asked questions

View the FireDAC documentation online for additional technical details and how-to tips