SQL Server Data Access Components

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) for Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms. SDAC-based applications connect to SQL Server directly through OLE DB, which is a native SQL Server interface. SDAC is designed to help programmers develop faster and cleaner SQL Server database applications.

SDAC, a high-performance and feature-rich SQL Server connectivity solution, is a complete replacement for standard SQL Server connectivity solutions and presents an efficient native alternative to the Borland Database Engine (BDE) and standard dbExpress driver for access to SQL Server.

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), and that's why they can work 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.

Cross-Platform Development in Delphi, C++Builder, and Lazarus

SDAC is a cross-platform solution for developing applications using SQL Server and various IDEs: RAD Studio, Delphi, C++Builder, Lazarus (and FPC) on Windows, macOS, Linux, 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.

Wide Coverage of SQL Server Features

SDAC supports a wide range of SQL Server specific features, such as Transparent Application Failover, Notification, Queing and reliable messaging, SQL Server Compact Edition, User-defined Types (including HierarchyID, Geography, Geometry), Table-Valued Parameters, Filestream, and others.

Filestream
Geography
SQL Server Compact Edition
Queing and reliable messaging

HierarchyID
Geometry
Notification
User-defined Types

Table-Valued Parameters
Transparent Application Failover

and more...

Product features

Direct Mode

Allows your application to work with SQL Server directly via TCP/IP without involving SQL Server Client, thus significantly facilitating deployment and configuration of your applications.

Mobile Development

Development for iOS and Android mobile devices using SDAC becomes still easier, as SDAC allows your mobile applications to work with SQL Server database as simply as desktop applications do.

DB Compatibility

SQL Server 2017\2016\2014\2012\2008 R2\ 2008\2005 (including Express edition), SQL Server 2000 (including MSDE), SQL Server 7, SQL Server Compact 4.0\3.5\3.1, SQL Azure

IDE Compatibility

Our product is compatible with the latest IDE versions and editions including Community Edition: Embarcadero RAD Studio 10.3 Rio, Delphi 10.3 Rio, C++Builder 10.3 Rio, Lazarus (and FPC). It is also compatible with the previous IDE versions since Delphi 6 and C++Builder 6.

Data Type Mapping

If you want to make custom correspondence between SQL Server and Delphi data types, you can use a simple and flexible Data Type Mapping engine provided by SDAC.

Development Platforms

All major GUI frameworks supported: develop VCL applications for Windows or cross-platform FMX applications in Delphi, as well as LCL applications for Windows, macoS, or Linux in Lazarus.

Performance

All our components and libraries are designed to help you write high-performance, lightweight data access layers, therefore they use advanced data access algorithms and techniques of optimization.

Monitoring

Use our freeware dbMonitor tool to monitor and analyze all the DB calls made by your application using SQL Server data access components. dbMonitor performs percomponent tracing of SQL statement execution, commits, rollbacks, etc.

Support

Visit our Support page to get instant support from experienced professionals, fast and detailed responses, user engagement and interaction, frequent builds with bug fixes, and much more.

What our customers say

Your testimonials

Utilizo em um sistema desktop em delphi xe7 que acessa uma base sql server 2014 remota em um data center, onde tenho centenas de usuarios conectados, o sdac se mostrou extremamente veloz ao acessar dados remotos. se mostrou mais veloz na busca dos dados, do que a utilizacao do datasnap. execelente documentacao, suporte, evolucao constante do produto

Wilton De Queiroz Vieira

Analista De Sistemas

We have developed an ERP system for a wet glue label printer company. The 280 users are using the application in a 7*24 hour production. With SDAC we have implemented fast performing client applications, production systems which are easy to install and maintain. Since The software is over 2 million lines of code the use of the right dataset componentset is critical. We think using Devart SDAC is for us the best choice, because no additional drivers need to be installed, it performs well even on the older machines and the quality is excellent

Olivier Olmer

Oxolutions bv

SDAC component suite gave us opportunity to provide our customers with trouble-free and efficient database access in our software solutions. Since we began using Devart DAC components, our development time shortened drastically, since we can focus on the application instead of data access. Some clever solutions, like macro parameters, gave us widened programming options which help us satisfy our customers more efficiently. Devart's devotion to keep up with database server developers warrants us security and helps us stay in business...

Mr. Davor Tavcar

Head of Development Department, Storitve Tavcar in Partnerji D.N.O.

I use SDAC in my daily works. It works perfect. I use it to fetch data from SQL Server 2000 to SQL Server 2008 without changing any code, it save my many time to work with different MS SQL Server Version. And it is very fast. I like it as I like ODAC.

Quan Zhong Min

Cio of Xi'an Siyuan University of China

Database Tools

Data Connectivity

Productivity Tools

Data Services

Tech support

Sales support

About us

Resources

Community