Hello, what other methods can I use to make a database?

Help Solution Accelerators
,
1

I cannot use Write Range as I cannot add a connection to Microsoft OneDrive

I also cannot use Output Data Table as I don’t have it in my activities (even after I downloaded the package). I also tried to download 2016.2.6246 version but I don’t even know where to find it

Someone please help me, Im out of options

2

@Justin_Tan_Jun_Song_EE,

Can you explain more about your requirement what you are trying to do?
Are you trying to create database in any Databases like SQL or MySQL etc?

3

Are you referring to make a Data Table Or Create a Data Base?
If it is to create a data table with some values which - Following are some of the options

  1. Use Activity Build Data Table where you can give the column names and their types. To add data - either you can add manually or use Add Data Row Activity to add rows using Studio

The screenshot shows the UiPath interface with a search for 'Build Data Table' and the activity selected and currently configured within a workflow. (Captioned by AI)
The screenshot shows the UiPath interface with a search for 'Build Data Table' and the activity selected and currently configured within a workflow. (Captioned by AI)1340×460 44.2 KB

The image shows the "Build Data Table" interface with two columns and a row of data, highlighting the button to add a new row. (Captioned by AI)
The image shows the "Build Data Table" interface with two columns and a row of data, highlighting the button to add a new row. (Captioned by AI)691×283 18.8 KB

  1. If the data is already available in an excel - You can use Following activities to read the details to a data table

Use Excel Application scope
Read Range Activity
Output to be saved to a variable of type Data Table

We can explore more based on your reply

4

My apologises, english is not my strongest subject, I meant to say data table.

Ah I see, thank you. I would like to ask though, how many columns would I need if my data comes from an API (I have already generated the data table to text but just confused on how many columns I should add by simply looking at the output)

5

I apologize for my mistake, I meant data table. However, if you do know about how I can connect my UiPath studio with DBeaver (SQLite), could you please share with me?

6

Data Table is used if the output is coming in the data table format

In case of API - it depends on the type of Output. Most of the cases - It will be in Json Format . In that case - you need to use deserialize json activity to work with output details

If you are new to UiPath - I would recommend to start with Academy courses in a structured manner. Else it might be overwhelming for you to understand the concept

Register below
Automation Training - Build Automation Skills with Free Courses | UiPath Academy

You can search for different courses / role based learning materials. Try this

Happy Automation

7

Thank you very much! I will look into this once I get spare time

8

Sure

kindly mark the solution if there are no further queries

You can always create a new topic later if you have questions

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.