SDAC Features

In this topic you will find the complete SDAC feature list sorted by categories.

Supported target platforms

• Windows 32-bit and 64-bit
• macOS 64-bit
• Mac ARM
• iOS 64-bit
• iOS Simulator ARM 64-bit
• Android 32-bit and 64-bit
• Linux 32-bit (only in Lazarus and Free Pascal) and 64-bit

General usability:

• Direct access to server data. Does not require installation of other data provider layers (such as BDE and ODBC)
• Interface compatible with standard data access methods, such as BDE and ADO
• VCL, LCL, and FMX versions of library available
• Separated run-time and GUI specific parts allow you to create pure console applications such as CGI
• Unicode support

Network and connectivity:

• Disconnected Model with automatic connection control for working with data offline
• Local Failover for detecting connection loss and implicitly reexecuting certain operations
• P:Devart.Sdac.TCustomMSConnection.ConnectString support
• Ability to search for installed SQL Server databases in a local network
• Support for connection encryption without certificate validation

Compatibility:

• Full support of the latest Microsoft SQL Server versions, including Express and Compact editions
• Support for all SQL Server data types
• Compatible with all IDE versions starting with Delphi 6, C++Builder 6 and Lazarus (Free Pascal)
• Includes provider for UniDAC Standard Edition
• Wide reporting component support, including support for InfoPower, ReportBuilder, and FastReport
• Wide support of all standard Borland and third-party visual data-aware controls
• Allows you to use Professional Edition of Delphi and C++Builder to develop client/server applications

SQL Server technology support:

• TMSLoader component for improving record insertion performance
• TMSServiceBroker component for SQL Server queuing and reliable messaging
• Enhanced support for User-defined Types of SQL Server
• Enhanced support for SQL Server Compact Edition with the TMSCompactConnection component
• Possibility to change application name for a connection
• Possibility to change workstation identifier for a connection
• Configuration of OEM/ANSI character translation
• Ability to lock records and tables

Performance:

• High overall performance
• Fast controlled fetch of large data blocks
• Optimized string data storing
• Advanced connection pooling
• Incredible performance of applying updates in CachedUpdates mode
• Caching of calculated and lookup fields
• Fast Locate in a sorted DataSet
• Preparing of user-defined update statements

Local data storage operations:

• Database-independent data storage with TVirtualTable component
• CachedUpdates operation mode
• Local sorting and filtering, including by calculated and lookup fields
• TMSMetaData Local master/detail relationship
• Master/detail relationship in CachedUpdates mode

Data access and data management automation:

• Automatic data updating with TMSQuery , TMSTable and TMSStoredProc components
• Support for Query Notifications with the TMSChangeNotification component
• Automatic record refreshing
• Automatic query preparing
• Support for getting results from queries with the FOR XML clause in readable view
• Support for ftWideMemo field type in Delphi 2006 and higher

Extended data access functionality:

• Separate component for executing SQL statements
• Simplified access to table data with TMSTable component
• Ability to retrieve metadata information with TMSMetaData component
• BLOB compression support
• Support for using macros in SQL
• FmtBCD fields support
• NonBlocking mode allows background executing and fetching data in separate threads
• Ability to customize update commands by attaching external components to TMSUpdateSQL objects.
• Deferred detail DataSet refresh in master/detail relationships
• MIDAS technology support
• Distributed transactions are supported with the TMSTransaction component

Data exchange:

• Transferring data between all types of TDataSet descendants with TCRBatchMove component
• Data M:Devart.Dac.TMemDataSet.SaveToXML and import to/from XML (ADO format)
• Ability to synchronize positions in different DataSets

Script execution:

• Advanced script execution features with TMSScript component
• Support for executing individual statements in scripts
• Support for executing huge scripts stored in files with dynamic loading
• Optimized multi-statement script execution

SQL execution monitoring:

• Extended SQL tracing capabilities provided by TMSSQLMonitor component and DBMonitor
• Borland SQL Monitor support
• Ability to send messages to DBMonitor from any point in your program

Visual extensions:

• Includes source code of enhanced TCRDBGrid data-aware grid control
• Customizable connection dialog
• Cursor changes during non-blocking execution

Design-time enhancements:

• DataSet Manager tool to control DataSet instances in the project
• Advanced design-time component and property editors
• Automatic design-time component linking
• Easy migration from BDE and ADO with Migration Wizard
• More convenient data source setup with the TMSDataSource component
• Syntax highlighting in design-time editors

Resources:

• Code documentation and guides in the CHM, PDF, and HXS formats
• Many helpful demo projects

Error handling:

• Multiple error processing support
• Unicode error messages support

Licensing and support:

• Included annual SDAC Subscription with Priority Support
• Licensed royalty-free per developer, per team, or per site