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