RPA Log Hub

We will use this method in UiPath to access the Excel as a Database and for that we need OLEDB Engine. You can download it from here : So what is OLE DB ? OLE DB (Object Linking and Embedding, Database, sometimes written as OLEDB or OLE-DB), an API designed by Microsoft, allows accessing data from a variety of sources in a uniform manner. Follow these steps to setup connection and used the excel as a database: First of all, use the Activity Connect to Configure Connection and create its variable "conn" FileName: Full Path of Excel File  Connection String: Provider=Microsoft.ACE.OLEDB.12.0; Data Source=FileName; Extended Properties='Excel 12.0 XML;HDR=YES;ReadOnly=False'  Provider Name: System.Data.OleDb HDR=Yes -- Indicates that the first row contains column names.  Then use the Activity Execute Query and pass the connection String variable in its existing Connection and write query like this. Then you can write the dat...

If you type on Google "MongoDB", you will find many tutorials about this, but here tutorials not only from experts of MongoDB but also learning assignments with Certification in the end. The University of MongoDB provides the free Certification Courses for the beginners and experienced , they are giving us the opportunity to learn about new Database like MongoDB. They provide you multiple courses related to MongoDB like MongoDB features, MongoDB for Java Developers, MongoDB for Node.js etc . They provide online video classes which is quite cool and flexible for everyone. I found their technique to teach something quite good and easy to understand. You dont have to spend much time on that, you have weekly module here where you need to spend only 2 hours for video lectures and 3 hours for homework and you are done, and this is the maximum time i am talking about otherwise you only have to spend 2-3 hrs in a week. They also provide you one discussion portal f...