Data Connectivity
Your DataFlex applications can be written to work with different databases. You access different databases by using database drivers. These drivers share an API, upon which the DataFlex language and framework rely. Because all drivers share the DataFlex API, most DataFlex database features are common across all databases. These common features are discussed in Database Essentials.
Embedded Driver
The Embedded Database is accessed using a built-in Embedded driver. The features, issues, and limitations that are unique to the Embedded Database are discussed in The Embedded Database.
SQL Drivers
The DataFlex SQL drivers are used to access SQL databases. They all share the common DataFlex API, making it possible to work with SQL databases in a standard DataFlex style.
The DataFlex SQL drivers share an additional common extended interface, making it possible to take better advantage of SQL features. This includes interfaces for working with:
- SQL Filters (the “where” clause)
- SQL Ordering (server partial indexes and server sorting)
- The use of direct SQL statements (Embedded SQL)
- And more
When the extended SQL interface is used, it is possible to write applications that can be deployed across the popular SQL databases.
The features, issues, and additional capabilities of using the DataFlex SQL Drivers are discussed in this section. These include:
- DataFlex SQL Drivers
- Understanding How Connectivity Works
- Using Managed Connections
- Connectivity and Development
- Converting Data
- Connecting to Existing Data
- Environment Setup Notes
- Using Embedded SQL
- Connectivity Concepts
The DataFlex Pervasive.SQL Driver is based on the Btrieve API and has different capabilities and restrictions than the DataFlex SQL Drivers.