 |
VOOZH | about |
|
VOOZH | about |
SQL-based Access to Workday through ADO.NET for your custom .NET applications and SSAS.
The Workday ADO.NET Data Provider enables user to easily connect to Workday data from .NET applications. Rapidly create and deploy powerful .NET applications that integrate with Workday.
Use Workday from SQL Server Analysis Service (SSAS) multi-dimensional cubes. Keep your analytical data modeling and access to any source including cloud and on-premises.
The Workday ADO.NET Provider allows developers to build applications that connect to Workday using familiar SQL and Entity Framework. Integrate Workday to your mission -critical applications or create easy side-by-side applications.
You can connect from ADO.NET compliant low-code development tools:
You can connect Workday from .NET-based reporting and analytics tools:
The Workday ADO.NET Provider offers the most natural way to access Workday data from any .NET application. Simply use Workday Data Provider objects to connect and access data just as you would access any traditional database. You will be able to use the Workday Data Provider through Visual Studio Server Explorer, in code through familiar classes, and in data controls like DataGridView, GridView, DataSet, etc.
The CData ADO.NET Provider for Workday hides the complexity of accessing data and provides additional powerful security features, smart caching, batching, socket management, and more.
The Workday Data Provider has the same ADO.NET architecture as the native .NET data providers for SQL Server and OLEDB, including: WorkdayConnection, WorkdayCommand, WorkdayDataAdapter, WorkdayDataReader, WorkdayDataSource, WorkdayParameter, etc. Because of this you can now access Workday data in an easy, familiar way.
using (WorkdayConnection conn = new WorkdayConnection("...")) {
string select = "SELECT * FROM CashManagement";
WorkdayCommand cmd = new WorkdayCommand(select, conn);
WorkdayDataAdapter adapter = new WorkdayDataAdapter(cmd);
using (adapter) {
DataTable table = new DataTable();
adapter.Fill(table);
...
}
}
With traditional approaches to remote access, performance bottlenecks can spell disaster for applications. Regardless if an application is created for internal use, a commercial project, web, or mobile application, slow performance can rapidly lead to project failure. Accessing data from any remote source has the potential to create these problems. Common issues include:
The CData ADO.NET Provider for Workday solves these issues by supporting powerful smart caching technology that can greatly improve the performance and dramatically reduce application bottlenecks.
Smart caching is a configurable option that works by storing queried data into a local database. Enabling smart caching creates a persistent local cache database that contains a replica of data retrieved from the remote source. The cache database is small, lightweight, blazing-fast, and it can be shared by multiple connections as persistent storage.
Caching with our ADO.NET Providers is highly configurable, including options for:
This powerful caching functionality increases application performance and allows applications to disconnect and continue limited functioning without writing code for additional local storage and/or data serialization/deserialization.
More information about ADO.NET Provider caching and best caching practices is available in the included help files.
Working with the new Workday ADO.NET Provider is easy. As a fully-managed .NET Data Provider, the Workday Data Provider integrates seamlessly with the Visual Studio development environment as well as any .NET application.
As an ADO.NET Data Provider, Workday ADO.NET Provider can be used to access and explore Workday data directly from the Visual Studio Server Explorer.
It's easy. As a standard ADO.NET adapter, developers can connect the Server Explorer to Workday ADO.NET Provider just like connecting to any standard database.
Explore all of the data available! Workday ADO.NET Provider makes it easy to access live Workday data from Visual Studio.
Connecting Web, Desktop, and Mobile .NET applications with Workday is just like working with SQL Server. It is even possible to integrate Workday ADO.NET Provider into applications without writing code.
Developers are free to access the Workday ADO.NET Provider in whatever way they like best. Either visually through the Visual Studio Winforms or Webforms designers, or directly through code.
Done! It's just like connecting to SQL Server.
Build Workday integrations faster with AI that understands your schema
Supported AI Coding Tools
MCP Server gives AI coding tools direct access to your Workday schema. No more guessing table names or column types—AI sees the same metadata as your ADO.NET Driver.
Table names, column names, and SQL syntax in MCP Server are identical to this ADO.NET Driver. Queries you validate with AI work directly in your production code.
Stop guessing. Start shipping. Prototype queries in conversation, validate against live data, then deploy with CData ADO.NET Drivers—no rewriting required.
Free for development. No trial period. No credit card required.
Take a look at some of our most popular articles from our knowledge base:
For more articles and technical content related to Workday ADO.NET Provider, please visit our online knowledge base.
Do you want to learn more about how you can use CData to connect Tableau with real-time data from anywhere? Contact us below, and let's talk.
