Connection to SQL Server From Delphi, C++Builder, and Lazarus

SQL Server Data Access Components (SDAC) is a library of components that provides native connectivity to SQL Server from Delphi and C++Builder (including Community Edition), as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms. SDAC is an efficient native alternative to the Borland Database Engine (BDE) and the standard dbExpress driver intended to provide access to SQL Server.

  • Direct SQL Server access
  • VCL, LCL, FMX support
  • High-performance connection pooling
  • TMSQuery and TMSStoredProc automation
  • Design-time migration and editors
How the SDAC connector works

Native connectivity to SQL Server

SDAC-based DB applications are easy to deploy, do not require installation of other data provider layers (such as BDE and ODBC). This makes them faster than the ones based on standard Delphi data connectivity solutions. Moreover, SDAC provides functionality for working with SQL Server not only through OLE DB, but also through SQL Native Client.

SDAC supports the following Microsoft SQL Server versions:
  • All SQL Server editions, from legacy to current
  • Express editions
  • Compact editions via TMSCompactConnection

Features

Secure connections using SSL, SSH, or HTTP/HTTPS protocols

Secure connection

You can use SDAC with SecureBridge components to embed SSL, SSH, or HTTP/HTTPS protocols into your application developed in Delphi, C++Builder, Lazarus, and Free Pascal for establishing a secure SQL Server database connection.

Compatibility with the latest versions of popular IDEs

IDE compatibility

SDAC is compatible with the latest IDE versions, including Community editions: Embarcadero RAD Studio 13 Florence, Delphi 13 Florence, C++Builder 13 Florence, Lazarus (and FPC), as well as with previous IDE versions since Delphi 6 and C++Builder 6.

Support for popular development platforms

Development platforms

SDAC supports all major GUI frameworks, providing you with all the capabilities you need to develop VCL applications for Windows or cross-platform FMX applications in Delphi, as well as LCL applications for Windows, macOS, or Linux in Lazarus.

Support for development of mobile applications

Mobile development support

Our SQL Server Data Access Components facilitate and expedite application development for iOS and Android devices by enabling your mobile applications to access and query SQL Server databases as easily and efficiently as desktop applications do.

Advanced data access algorithms improving performance

Performance

All our SQL Server-optimized components and libraries use advanced data access algorithms and engineering best practices to assist you with writing high-performance, lightweight data access layers.

Custom data type mapping

Data type mapping

If your application requires establishing custom alignment between SQL Server and Delphi data types, you can achieve it by using the straightforward and flexible Data Type Mapping engine available in SDAC.

Executing batch SQL operations for large data changes

Monitoring

Use our freeware dbMonitor to monitor and analyze all the database calls made by your application using SDAC. dbMonitor performs per-component tracing of SQL statement execution, commits, rollbacks, etc.

Professional support and frequent updates

Support

Whenever you need assistance, you can visit our Support page to get instant help from knowledgeable and experienced professionals, a quick resolution of your problems, and nightly builds with hotfixes.

SDAC supports a wide range of SQL Server-specific features

  • Filestream
  • Geography
  • SQL Server Compact edition
  • HierarchyID
  • Geometry
  • Notification
  • User-defined types
  • Table-valued parameters
  • Transparent application failover

Cross-platform solution for Delphi, C++Builder, and Lazarus

SDAC is a cross-platform solution for developing applications using various IDEs: RAD Studio, Delphi, C++Builder, Lazarus (and FPC) on Windows, Linux, macOS, iOS, Android, and FreeBSD for both x86 and x64 platforms. SDAC also provides support for the FireMonkey application development platform, which allows you to develop visually spectacular, high-performance desktop- and mobile-native applications.

SDAC supports various application development platforms and IDEs

Pricing

SQL Server Data Access Components

Starts from

$229.95
Try the SQL Server Components

Key features:

  • Direct mode without client libraries
  • VCL, LCL, FMX support
  • Standard data access compatibility
  • Full SQL Server technology support
  • Design-time productivity tools
  • Disconnected model capabilities

Universal Data Access Components

Starts from

$349.95
Try the Universal Components

Key features:

  • Universal access to multiple databases
  • Direct mode without client libraries
  • VCL, LCL, FMX support
  • Disconnected mode with failover
  • Unified database-independent queries
  • Design-time productivity tools

Advanced ORM support

Entity Developer and EntityDAC enhance SDAC by adding ORM capabilities on top of its direct SQL Server connectivity. EntityDAC uses SDAC as its underlying data access layer for native, direct SQL Server connections without client software. Entity Developer provides a visual designer to create ORM models, generate Delphi entity classes, and support LINQ queries mapped to SQL Server via SDAC.

Key benefits for SDAC users

  • Visual ORM modeling: Design database schemas into Delphi classes with inheritance and encapsulation.
  • LINQ for SQL Server queries: Write server-agnostic queries that SDAC executes efficiently.
  • Code-first flexibility: Generate or hand-edit entities, leveraging SDAC's performance features like caching.
  • Seamless integration: No extra providers needed; SDAC handles TCP/IP access while EntityDAC abstracts data into objects.
ORM modeling

Other Data Access Components for databases

Data Access Components for Firebird Firebird Data Access Components for InterBase InterBase Data Access Components for MySQL MySQL Data Access Components for Oracle Oracle Data Access Components for PostgreSQL PostgreSQL Data Access Components for SQLite SQLite

Ready to get started?

Get a 60-day free trial now

Get a free 60-day trial now

Download SDAC for a FREE 60-day trial and enjoy the high performance and new possibilities when working with SQL Server.

Get a free trial now
Enjoy bulk discounts

Enjoy bulk discounts

We offer flexible options to meet your budget in the optimal way. You can get bulk discounts for multiple purchases.

Discover now
Need a hand?

Need a hand?

If you need any help or have questions about our connectivity solutions or purchasing options, feel free to get in touch.

Contact us

FAQ

What is SDAC?

SDAC (SQL Server Data Access Components) is a set of data access libraries designed for building applications that connect to SQL Server databases from Delphi, C++Builder, Lazarus (Free Pascal), and other RAD Studio environments.

How do I download SDAC for a free trial?

To start a free trial of SDAC, click the Download button at the top of the page and select the component that matches your environment. Click Get trial. If you are not signed in, sign in to your Devart account or sign up to create one. Then proceed with downloading SDAC for a free, fully-functional 60-day trial.

Is a registration or email required to download SDAC?

Yes. To download SDAC, you need to sign in to your Devart account or sign up if you don't have one yet.

Where do I find the documentation for SDAC?

You can find the SDAC documentation at Devart's documentation portal.

How do I install SDAC on Windows?

To install SDAC on Windows, run the installer you downloaded and follow the instructions in the wizard. Note that installing SDAC requires changes to your environment. For more details, see the documentation.