Ole DB Connection

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.

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

  • vimpe/connections/database/oledb.txt
  • Last modified: 17/09/2018 10:33
  • by admin