OLE DB
Data Integration

via Premium ADO.NET Components

OLE DB (Object Linking and Embedding, Database) is a Microsoft API designed for accessing data from a variety of sources in a uniform manner. It supports not only relational databases but also non-relational data sources.

Using the Premium OLE DB components from our ETL development platform, you can connect to a wide range of OLE DB-compliant data sources and work with them efficiently.

SSIS Productivity Pack

OLE DB Data Integration Made Easy

Sample Integration Use Case

Read and Write Data to External OLE DB Systems

Read and Write Data to External OLE DB Systems

You are working with a legacy application or a proprietary database that only supports OLE DB connections. You need to extract records for reporting or push processed data into the system as part of an ETL workflow.

  • Connect to OLE DB Source: Retrieve data from supported systems using parameterized queries or full table reads

  • Transform Data Using ETL Platform: Apply mappings, filters, and conversion logic

  • Write Back to OLE DB Destination: Insert, update, delete, or upsert records to the target system

Get Expert Help 

Developed for Complex Enterprise Workloads

Our Solutions Are Built to Support
Advanced Data Workflows Across Systems

Browse ProductsView All Solutions

Accelerate Legacy System Integration

Accelerate Legacy System Integration

Make data available from legacy or proprietary sources by connecting through OLE DB.

Handle Complex Transformations with Flexibility

Use our ETL platform’s transformation capabilities to clean, format, or restructure data before loading.

Work with Any System that Supports ODBC

Aligned Data and Improved Workflows

Leverage OLE DB to facilitate integration across legacy and modern systems.

Scenario Data Movement Business Outcomes
Pull historical records OLE DB → Target system Use legacy data for audits or analytics
Insert processed data ETL → OLE DB Update proprietary systems with current business records
Sync user or customer details Source system → OLE DB Keep downstream applications aligned with customer profiles
Read reference data OLE DB → ETL Enrich modern platforms with consistent lookup tables
Update configuration tables ETL → OLE DB Maintain control logic in legacy applications

Youtube Video - Getting started with SSIS Productivity Pack - Premium ADO NET Components

Click to watch tutorial video.

The Premium ADO.NET Source and Destination components offer expanded functionality to the out-of-box SSIS ADO.NET components.

With advanced options and functionality, our Premium ADO.NET components are your go-to solution when reading or writing to virtually any database. You will not only be able to insert data into a database, but also use Update, Delete and even Upsert actions.

The Premium ADO.NET Components, part of the SSIS Productivity Pack, offer much greater performance, flexibility and ease of use with advanced datatype detection.

Access the full suite of KingswaySoft’s SSIS Integration Toolkits
and the SSIS Productivity Pack under a single commercial license.

Comprehensive Integration Solution
Using Our SSIS Ultimate Edition

 Learn More  Purchase

Database Integration Scenarios

View data integration scenarios supported by our solutions. Each example shows how our
components connect enterprise platforms and services to support practical business processes.

Azure SQL DB Integration
Azure SQL DB Integration
Azure Synapse DB Integration
Azure Synapse DB Integration
DB2 Integration
DB2 Integration
Firebird Integration
Firebird Integration
MariaDB Integration
MariaDB Integration
Microsoft Access DB Integration
Microsoft Access Integration
MySQL DB Integration
MySQL Integration
ODBC DB Integration
ODBC Connections
Oracle DB Integration
Oracle Database Integration
PostgreSQL Integration
PostgreSQL Integration
SQL Server Integration
SQL Server Integration
SQLite Integration
SQLite Integration
Sybase Integration
Sybase Integration

More Data Integration Use Cases

See more use cases across databases,
enterprise systems, and supported application platforms.

SSIS Integration Toolkit for Directory Services Use Cases
Directory Services
SSIS Integration Toolkit for Microsoft Dynamics 365 Use Cases
Dynamics 365
SSIS Integration Toolkit for Microsoft Dynamics GP Use Cases
Dynamics GP
SSIS Integration Toolkit for Microsoft Dynamics SL Use Cases
Dynamics SL
SSIS Integration Toolkit for HubSpot Use Cases
HubSpot
SSIS Integration Toolkit for Marketo Use Cases
Marketo
SSIS Integration Toolkit for NetSuite Use Cases
NetSuite
SSIS Integration Toolkit for Oracle CRM On Demand Use Cases
Oracle CRM On Demand
SSIS Integration Toolkit for Oracle Marketing Cloud Use Cases
Oracle Marketing Cloud
SSIS Integration Toolkit for Microsoft Project Server Use Cases
Project Server
SSIS Integration Toolkit for QuickBooks Use Cases
QuickBooks
SSIS Integration Toolkit for Salesforce Use Cases
Salesforce
SSIS Integration Toolkit for SAP Use Cases
SAP
SSIS Integration Toolkit for Microsoft SharePoint Use Cases
SharePoint
SSIS Integration Toolkit for Team Foundation Server Use Cases
Team Foundation (DevOps) Server

Easily Solve Your Data Integration
and Migration Problems

Experience why thousands of businesses across 100+ countries trust KingswaySoft for reliable data connectivity and integration solutions.

Contact Us