OLEDB

[Venkata_NitishM]

What is OLEDB, which scenarios we can use mainly, can anyone elobarate it??

[John__Carter]

It's a mechanism for reading from data sources such as a DB or a file. It's MS technology not BP, and there is a ton of information online.

[Christopher]

We use it to query an oracle database to speed up processes which are running in a citrix env. instead of using surface automation.

[JivankumarKedar]

OLEDB is very powerful if you know how to write queries. This works for Databases and excel, csv etc etc files. Its faster. In my project, we are mainly using it for data extraction from MS Access DB and Excel sheets. Also few operations like Pivot, Sum, Filter, VLookup etc. on excel sheet. This is faster than doing from Manually sending keyboard shortcuts or Code stages.

[Rama_RajuGK]

hi, can we update the data with OLEDB VBO, If yes - can you please let me know how can we use that

[YogitaKulkarni]

Hi Jivankedar,   Can we insert records into MS Access DB using OLEDB Object?