Learn more
 

CData Software - Knowledge Base

Recent Oracle ADO.NET Articles

How to Import Oracle into SQL Server using SSIS

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

LINQ to Oracle

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 Oracle Data Provider.

Visualize Oracle in TIBCO Spotfire through ADO.NET

Integrate Oracle Database into dashboards in TIBCO Spotfire.

Back Up Oracle Database to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Oracle. In this article, we will employ an SSIS workflow to populate a database with Oracle Database data.

DataBind Oracle to the DevExpress Data Grid

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

Build an OLAP Cube in SSAS from Oracle

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

Export Data from SQL Server to Oracle through SSIS

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

Automate Oracle Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Oracle Database from PowerShell? This article demonstrates how to utilize the Oracle Cmdlets for tasks like connecting to Oracle Database, automating operations, downloading data, and more.

Provide OData Services of Oracle from a WCF Application

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

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

Connect to Oracle Database 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.