ADO Architecture

ADO is an object-oriented data access interface for data sources such as a USoft application governed by a USoft Rules Engine.

ADO is a layer on top of OLE DB. ADO uses OLE DB for ODBC providers to connect to existing ODBC drivers. The USoft Remote Rules Service driver starts the rules engine for the configured application and makes a connection to the configured RDBMS and server/database. Optionally it will prompt for a user ID and password. After the connection succeeds, any issued SQL statement is processed by the rules engine which will automatically check and enforce defined business rules. The application using ADO does not need to re-implement the rules (in code) again. The ADO application can freely query and manipulate the data.