Cross-Platform Data Connectivity Library
ComponentOne DataConnectors is a data connectivity library for performing any data operation, such as queries and updates, against a variety of popular data sources.
- Import and analyze data from different data sources using a common interface
- Quickly and easily display data or generate reports from popular Cloud services
- Supports connecting to Microsoft Dynamics 365, Salesforce, QuickBooks Online, Google Analytics, and more
- Cross-platform .NET Standard support
Overview
Data Connector components are reusable libraries that help developers connect to a wide variety of data sources in their applications in less time. ComponentOne provides a rich set of high-performing, flexible data connector components for popular data formats and CRMs.
Why Choose ComponentOne DataConnectors?
Create Data-Oriented Apps Faster
DataConnectors provides fast and direct access to a variety of data sources, hiding the complexity with a unified interface for querying and updating multiple data sources.
Manage Data More Efficiently
Integrate data from various sources into your business applications and empower your users to manage data more efficiently without relying on additional software.
Connect to Data from Any Platform
The DataConnectors library is built against .NET Standard from the ground up so it's supported across all Windows, Mac, Linux, and mobile device platforms.
Supported Data Sources
OData
A cross-platform, data connectivity library for connecting to any OData data source.
Dynamics 365
A cross-platform, data connectivity library for connecting to Microsoft Dynamics 365 Cloud-based CRM.
Salesforce
A Salesforce .NET data connector for cross-platform data integration and management.
Google Analytics
A cross-platform, .NET library for connecting to Google Analytics cloud data.
Visual Studio Integration
Quickly and easily connect to any of the supported data sources through Visual Studio 2019 or 2022. You can connect to these sources through the Server Explorer, without writing a single line of code, and then drag and drop tables on the dataset designer, and connect data-aware controls like grids, charts & report designers.
Data Features
ADO.NET and Entity Framework Core Support
Connect to online data sources using standard ADO.NET objects and Entity Framework Core. The data connector uses ADO.NET objects to make it easy to set up a connection.
Open Authorization Support
The data connectors support the industry standard open authentication protocol, OAuth 2.0, to help you protect your data through a secure connection.
SQL and LINQ Query Support
Query against the data source using most standard SQL syntax including joins queries, functions, and summaries. It also has in-built support for LINQ queries for native .NET data queries.
Batch CRUD Operations
The data connectors support CRUD operations such as inserting, updating and deleting data through Command and DataAdapter objects. You can further optimize network performance by performing batch updates.
Fast Cache with Incremental Updates
With built-in caching you can improve performance by using a local cache database for repeat operations. It also supports incremental updates so that only new or modified records get synced to the cache.
Scaffolding
With scaffolding support, the data connector library can generate model classes and a database context for Entity Framework Core. The scaffolding command can be run from Visual Studio.
More Data Integration Capabilities
While the data connectors focus primarily on connecting and querying, you can use them with other powerful .NET Standard and .NET Framework components to do a lot more.
- Integrate data with DataCollection to provide filtering, grouping, data virtualization to your data-aware controls.
- Import data and use DataEngine to analyze massive amounts of data in fractions of a second.
- Connect to pivot grids & charts, such as FlexPivot, to visually analyze data from the data source.
- Create business reports using FlexReport for important business tasks.
- Display data in a .NET FlexGrid control on desktop, web, or mobile devices.
Featured Blogs, Videos, and Other Resources
ComponentOne Customer Feedback and Awards
"Prompt responses, quality feedback, and help with code examples. Fantastic service!"
RICHARD HERBERT
"Excellent product with good support"
MIKE WEBSTER
"I am very appreciative of the effort your entire team gave to make this transaction happen. Thank you for your efforts!"
SAM COLE
 |
 |
"When I run into complex problems, I turn to my ComponentOne Studio Enterprise toolbox."
KEN SPENSER, MICROSOFT REGIONAL DIRECTOR - FRAMEWORK MASTERS
"I love to use C1 components! I can be confident that if I need to do a particular task, ComponentOne will have the control to do the job."
SILV SORDELLO, SOFTWARE DEVELOPER
"As an ISV, I need tools that allow me to be competitive. Therefore, it's a must to use reliable and stable tools for customized solutions...ComponentOne provides all that to me and even more!"
DENNIS WALLENTIN, MICROSOFT MVP (EXCEL)
"Easier to use right off the bat. I liked using the Scheduler for drag-and-drop capability."
MICHELLE GIBSON, SOFTWARE ENGINEER
Trusted by the World's Leading Companies
