Standard Driver Interfaces

Comprehensive MetaData Discovery

Full support for Metadata provides extensive schema discovery capabilities. Explore tables, columns, keys, etc. based on user identity.

Caching and Replication

Embedded commands make it easy to copy data to local and cloud data stores.

Embedded Remoting

MySQL and TDS wire protocol hosting offer seamless Linked Servers access and remote connectivity.

Pushdown, Batch, & Bulk Operation

High performance features like streaming forward cursors for performance, BatchAPI for efficient INSERT/UPDATES.

SQL-92 Compliant Queries

Write standard SQL queries with support for joins, updates, aggregation, and more. Our drivers compensate for features lacking in the source.

SELECT WITH INNER JOIN

SELECT Account.Id, Account.Name, Account.Fax,     
  Opportunity.AccountId, Opportunity.CloseDate
FROM Account
INNER JOIN Opportunity
  ON Account.Id = Opportunity.AccountId

AGGREGATE FUNCTIONS

SELECT Name, AVG(AnnualRevenue) FROM Account GROUP BY Name

CRUD OPERATIONS

UPDATE Account SET Name='John' WHERE Id = @myId