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 Get Expert Help

Sample Integration Use Case

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 Products View All Solutions

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.

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

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.

See help manual for a highlight
of the technical features

KingswaySoft SSIS Connectivity Solutions are available in SSIS Integration Toolkit

Download Purchase Help Manual

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.