Embed SQLite in UiPath Robot

database
studio

#1

Hi All,
Do you have any working example of using SQLite database?
Thanks,
Doru


#3

Solved: I created new set of custom activities to work with SQLite (connection, Execute Query/NonQuery/Insert…). Can be closed.


#4

Did standard db activities not work?
One would think they should…


#5

@andrzej.kniola standard Database Connect activity has < ProviderName > as required parameter. Installing a provider for SQLite on the machine running the robot defeats the purpose of having the database “embedded” within the workflow. I selected SQLite based on several criteria, database being “embedded” is one of them among but not all: persistent storage (NOT in memory), ability to use SQL or similar DML, price.
But again, since I am still learning, if you have a working example for using SQLite please let me know / send me the link to it.
Thanks,
Doru


#6

I have found this very useful: https://docs.microsoft.com/en-us/dotnet/framework/windows-workflow-foundation/samples/property-grid-extensibliity
And of course the tutorials
https://www.uipath.com/kb-articles/how-to-create-a-custom-activity
and
https://www.uipath.com/kb-articles/how-to-execute-your-custom-code-in-a-workflow


Custom Activity: Collection as Input Argument
#7

Would you be willing to share your code for the custom activities? I am also trying to connect uipath to a local SQLite .db, for persistent storage.


#8

Hi @Tiramisu Unfortunately I cannot do this since I work for a company and they own all IP for my work. I will however help you build something similar, just ask the questions.
But if it is only for persistent storage (e.g. no DML over data) I highly recommend to consider .xlsx files.


#9

That’s very kind of you. I am working though this guide


but if I would run into problems then I will surely return here.


#10

So update. I have a simple but functional SQLite nuget package for use in UiPath. I don’t know when I will get around to upload it but if anyone is urgently in need I will hurry up. I can share source code and .nupkg package as well.


#11

Hi,

I would love to see this nuget package!

Hope you can post it.

Regards!