ADO.NET Data Providers

Easily connect .NET applications with SaaS, NoSQL, & Big Data

  • Databind to Applications, Databases and Services
  • Full Create, Read, Update, and Delete (CRUD) Support
  • No Coding Required


Low-Code ADO.NET Data Integration

Easily connect data from any source to BI, ETL, Reporting, and Custom Apps.

Custom Applications

Developers can use ADO.NET Drivers to rapidly build Web, Desktop, and Mobile applications.

Enterprise-Class Design

Built with the same reliability, scalability, performance & security powering leading data integration solutions.

Data-Centric Architecture

A robust SQL-engine simplifies data movement & processing from Cloud Apps, NoSQL, Files, & more.

BI, ETL, & Reporting Tools

Extend popular .NET data application like SSAS, SSRS, & PowerBuilder, and more with real-time data access.

ADO.NET Providers

Fully-Managed ADO.NET Providers. Databind to Apps, Databases, & Services.


Access
Act CRM
Act-On
Active Directory
ActiveCampaign
Acumatica
Adobe Analytics
ADP
Airtable
AlloyDB
Amazon Athena
Amazon DynamoDB
Amazon Marketplace
Amazon S3
Asana
Authorize.Net
Avalara AvaTax
Avro
Azure Active Directory
Azure Analysis Services
Azure Data Catalog
Azure Data Lake Storage
Azure DevOps
Azure Synapse
Azure Table
Basecamp
BigCommerce
BigQuery
Bing Ads
Bing Search
Box
Btrieve
Bugzilla
Bullhorn CRM
Cassandra
Cloudant
CockroachDB
Confluence
Cosmos DB
Couchbase
CouchDB
CSV
Databricks
DB2
DocuSign
Dropbox
Dynamics 365
Dynamics 365 Business Central
Dynamics CRM
Dynamics GP
Dynamics NAV
eBay
eBay Analytics
Elasticsearch
Email
EnterpriseDB
Epicor ERP
Exact Online
Excel
Excel Online
Facebook Ads
FHIR
FinancialForce
FreshBooks
Freshdesk
FTP
GitHub
Gmail
Google Ad Manager
Google Ads
Google Analytics
Google Calendar
Google Campaign Manager
Google Cloud Storage
Google Contacts
Google Data Catalog
Google Directory
Google Drive
Google Search
Google Sheets
Google Spanner
GraphQL
Greenplum
HarperDB
HBase
HCL Domino
HDFS
Highrise
Hive
HubSpot
IBM Cloud Object Storage
IBM Cloud SQL Query
IBM Informix
Impala
Jira
Jira Service Desk
JSON
Kafka
Kintone
LDAP
LinkedIn Ads
Magento
MailChimp
MariaDB
Marketo
MarkLogic
Microsoft Dataverse
Microsoft Exchange
Microsoft OneDrive
Microsoft Planner
Microsoft Project
Microsoft Teams
Monday.com
MongoDB
MYOB AccountRight
MySQL
Neo4J
NetSuite
OData
Odoo
Office 365
OneNote
Oracle
Oracle Eloqua
Oracle Financials Cloud
Oracle HCM Cloud
Oracle Sales
Oracle SCM
Oracle Service Cloud
Outreach.io
Parquet
Paylocity
PayPal
Phoenix
Pipedrive
PostgreSQL
Power BI XMLA
Presto
QuickBase
QuickBooks
QuickBooks Online
QuickBooks POS
Raisers Edge NXT
Reckon
Reckon Accounts Hosted
Redis
Redshift
REST
RSS
Sage 200
Sage 300
Sage 50 UK
Sage Cloud Accounting
Sage Intacct
Salesforce
Salesforce Marketing
Salesforce Pardot
Salesloft
SAP
SAP Business One
SAP BusinessObjects BI
SAP ByDesign
SAP Concur
SAP Fieldglass
SAP HANA
SAP HANA XS Advanced
SAP Hybris C4C
SAP Netweaver Gateway
SAP SuccessFactors
SAS Data Sets
SAS xpt
SendGrid
ServiceNow
SFTP
SharePoint
SharePoint Excel Services
ShipStation
Shopify
SingleStore
Smartsheet
Snowflake
Spark
Splunk
SQL Analysis Services
Square
Streak
Stripe
Sugar CRM
SuiteCRM
SurveyMonkey
Sybase
Sybase IQ
Tableau CRM Analytics
Tally
TaxJar
Teradata
Trello
TSheets
Twilio
Twitter Ads
Veeva
Veeva CRM
Wave Financial
WooCommerce
WordPress
Workday
xBase
Xero
Xero WorkflowMax
XML
YouTube Analytics
Zendesk
Zoho Books
Zoho Creator
Zoho CRM
Zoho Inventory
Zoho Projects
Zuora
… Dozens More
(API Driver)

Robust ADO.NET Data Integration

Full-featured and consistent SQL access to any supported data source through ADO.NET



  • Fully-managed .NET

    100% fully managed ADO.NET libraries supporting .NET Standard, .NET Core 2.0, & Xamarin.

  • Developer Friendly

    Seamless integration with all versions of Visual Studio.

  • Powerful ADO.NET Features

    Indluding support for ADO.NET Entity Framework (EF 5 & 6), ADO.NET 2.0, LINQ to datasets, etc.

  • Replication and Caching

    Our replication and caching commands make it easy to copy data to local and cloud data stores such as Oracle, SQL Server, Google Cloud SQL, etc. The replication commands include many features that allow for intelligent incremental updates to cached data.

  • String, Date, Numeric SQL Functions

    The driver includes a library of 50 plus functions that can manipulate column values into the desired result. Popular examples include Regex, JSON, and XML processing functions.

  • Collaborative Query Processing

    Our drivers enhance the data source's capabilities by additional client-side processing, when needed, to enable analytic summaries of data such as SUM, AVG, MAX, MIN, etc.

  • Easily Customizable and Configurable

    The data model exposed by our ADO.NET Providers can easily be customized to add or remove tables/columns, change data types, etc. without requiring a new build. These customizations are supported at runtime using human-readable schema files that are easy to edit.

  • Enterprise-class Secure Connectivity

    Includes standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications.

Eliminate Architectural Complexity

The most natural way to access data from any .NET application. Use through Visual Studio Server Explorer, in code through familiar classes, and in data controls like DataGridView, GridView, DataSet, etc.


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