topic We use it to query an oracle in Product Forum https://community.blueprism.com/t5/Product-Forum/OLEDB/m-p/49241#M4680 We use it to query an oracle database to speed up processes which are running in a citrix env. instead of using surface automation. Wed, 15 Nov 2017 23:45:00 GMT Christopher 2017-11-15T23:45:00Z OLEDB https://community.blueprism.com/t5/Product-Forum/OLEDB/m-p/49239#M4678 What is OLEDB, which scenarios we can use mainly, can anyone elobarate it?? Mon, 06 Nov 2017 13:39:00 GMT https://community.blueprism.com/t5/Product-Forum/OLEDB/m-p/49239#M4678 Venkata_NitishM 2017-11-06T13:39:00Z It's a mechanism for reading https://community.blueprism.com/t5/Product-Forum/OLEDB/m-p/49240#M4679 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. Mon, 06 Nov 2017 13:54:00 GMT https://community.blueprism.com/t5/Product-Forum/OLEDB/m-p/49240#M4679 John__Carter 2017-11-06T13:54:00Z We use it to query an oracle https://community.blueprism.com/t5/Product-Forum/OLEDB/m-p/49241#M4680 We use it to query an oracle database to speed up processes which are running in a citrix env. instead of using surface automation. Wed, 15 Nov 2017 23:45:00 GMT https://community.blueprism.com/t5/Product-Forum/OLEDB/m-p/49241#M4680 Christopher 2017-11-15T23:45:00Z OLEDB is very powerful if you https://community.blueprism.com/t5/Product-Forum/OLEDB/m-p/49242#M4681 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. Mon, 04 Dec 2017 13:51:00 GMT https://community.blueprism.com/t5/Product-Forum/OLEDB/m-p/49242#M4681 JivankumarKedar 2017-12-04T13:51:00Z hi, can we update the data https://community.blueprism.com/t5/Product-Forum/OLEDB/m-p/49243#M4682 hi, can we update the data with OLEDB VBO, If yes - can you please let me know how can we use that Tue, 19 Dec 2017 18:03:00 GMT https://community.blueprism.com/t5/Product-Forum/OLEDB/m-p/49243#M4682 Rama_RajuGK 2017-12-19T18:03:00Z Hi Jivankedar,… https://community.blueprism.com/t5/Product-Forum/OLEDB/m-p/49244#M4683 Hi Jivankedar,   Can we insert records into MS Access DB using OLEDB Object?   Tue, 06 Feb 2018 12:26:00 GMT https://community.blueprism.com/t5/Product-Forum/OLEDB/m-p/49244#M4683 YogitaKulkarni 2018-02-06T12:26:00Z