Learn more
 

CData Software - Knowledge Base

Recent Paylocity ADO.NET Articles

LINQ to Paylocity

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Paylocity Data Provider.

Create Dynamic Paylocity Grids Using the Infragistics XamDataGrid

Learn how you can connect Paylocity to Infragistics XamDataGrid to build dynamic grids.

Provide OData Services of Paylocity from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Paylocity by developing a WCF Service Application.

DataBind Charts to Paylocity

Use the standard ADO.NET procedures for databinding to provide bidirectional access to Paylocity from controls in the Visual Studio toolbox. This article demonstrates a graphical approach using wizards in Visual Studio, as well as how to databind with only a few lines of code.

How to Import Paylocity into SQL Server using SSIS

Easily back up Paylocity to SQL Server using the SSIS components for Paylocity.

DataBind Paylocity to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Paylocity with the DevExpress Windows Forms and Web controls to provide Paylocity to a chart.

Deploy the ADO.NET Provider for Paylocity on an SSRS Report Server

Connect to Paylocity from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

Build an OLAP Cube in SSAS from Paylocity

Establish a connection to Paylocity data from SQL Server Analysis Services, and use the Paylocity Data Provider to build OLAP cubes for use in analytics and reporting.

Import Real-Time Paylocity in ColdFusion to Build Applications

Use CData JDBC drivers to import and use Paylocity in ColdFusion.

Export Data from SQL Server to Paylocity through SSIS

Easily push SQL Server data to Paylocity using the CData SSIS Tasks for Paylocity.

How to Access Paylocity Using Entity Framework

This article shows how to access Paylocity using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.