User Tools

Site Tools


Ole DB Connection

About Ole DB

OLE DB (Object Linking and Embedding, Database, sometimes written as OLEDB or OLE-DB) is an API designed by Microsoft for accessing different types of data stored in a uniform manner. It is a set of interfaces implemented using the Component Object Model (COM); it is otherwise unrelated to OLE. It was designed as a higher-level replacement for, and successor to, ODBC, extending its feature set to support a wider variety of non-relational databases, such as object databases and spreadsheets that do not necessarily implement SQL.

Creating Ole DB connection

To create an Ole DB connection follow the steps below:

  • In the Name Text Box type in a new name for the connection you are about to create
  • Type in the connection string or use Build Connection String button to create one.
  • Click OK to close the connection properties window
Ole DB is one of the slowest ways of accessing the data and it uses a lot of memory. 
It is not recommended for very large datasets. 
Use variable to connect to the repository

For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions

Confused? Ask question on our ETL Forum

This website uses cookies for visitor traffic analysis. By using the website, you agree with storing the cookies on your computer.More information
aetle/connections/database/oledb.txt · Last modified: 2015/06/10 05:02 by admin