SQL Server Data Access Component (SDAC) is a component library that provides local connectivity from Delphi and C++Builder to SQL Server, including Community Edition, as well as Lazarus (and Free Pascal) for Windows, Linux, macOS, iOS, and Windows. Android for 32-bit and 64-bit platforms. SDAC based applications directly connect to SQL Server through OLE DB, which is a native SQL Server interface. SDAC aims to help programmers develop faster and cleaner SQL Server database applications.
SDAC is a high-performance and feature rich SQL Server connectivity solution that is a complete replacement for standard SQL Server connectivity solutions. It provides an effective native alternative to Borland Database Engine (BDE) and standard dbExpress drivers for accessing SQL Server.
Native connection to SQL Server
SDAC based database applications are easy to deploy and do not require the installation of other data provider layers (such as BDE and ODBC), which is why they can be faster than applications based on standard Delphi data connectivity solutions. In addition, the functions provided by SDAC can be used not only through OLE DB, but also with SQL Server 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: Lazarus (and FPC) platforms for x86 and x64 on RAD Studio, Delphi, C++Builder, Windows, macOS, Linux, iOS, Android, and FreeBSD. SDAC also provides support for the FireMonkey application development platform, which allows you to develop visually appealing high-performance desktop and mobile native applications.
Extensive coverage of SQL Server functionality
SDAC supports various SQL Server specific features, such as transparent application failover, notification, queuing, and reliable messaging, SQL Server Compact Edition, user-defined types (including HierarchyID, Geography, Geometry), table valued parameters, Filestream, and others.
- File stream
- Geography
- SQL Server Lite Edition
- Queuing and reliable messaging
- Hierarchy ID
- geometry
- notice
- User defined type
- Table value parameter
- Transparent application failover
- And more
Product Features
Allowing your application to be used directly with SQL Server through TCP/IP without involving the SQL Server Client greatly simplifies application deployment and configuration.
Developing for iOS and Android mobile devices using SDAC has become easier, as SDAC allows your mobile applications to use SQL Server databases like desktop applications.
SQL Server 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005 (including Express version), SQL Server 2000 (including MSDE), SQL Server 7, SQL Server Compact 4.0, 3.5, 3.1, SQL Azure.
Our product is compatible with the latest IDE versions, including community versions: Embarcadero RAD Studio 10.4 Sydney, Delphi 10.4 Sydney, C++Builder 10.4 Sydney, Lazarus (and FPC). It is also compatible with early IDE versions starting from Delphi 6 and C++Builder 6.
If you want to customize the mapping between SQL Server and Delphi data types, you can use the simple and flexible data type mapping engine provided by SDAC.
Support all major GUI frameworks: develop VCL applications for Windows or cross platform FMX applications in Delphi, and LCL applications for Windows, macOS, or Linux in Lazarus.
All our components and libraries are designed to help you write a high-performance, lightweight data access layer, so they use advanced data access algorithms and optimization techniques.
Use our freeware dbMonitor tool to monitor and analyze all database calls made by your application using SQL Server data access components. DbMonitor executes SQL statement execution, submission, rollback, and other component based tracking.
Please visit our support page for instant assistance from experienced professionals to quickly resolve your issues and build patches every night.
