How to create managed table

Overview

SolveXia provides simple way to create an SQL table on SolveXia system and store large amount of data. It is called “Managed table”. Managed table is used to store large amount of historical data, store periodic data, retrieve block of data based on specific criteria, for data analysis and much more.

Steps

1. Login to SolveXia system
2. Expand “Managed tables” folder
3. Right click on Managed table, and click on “Add a folder
4. Right click on just added folder and click on “Rename folder
5. Enter the name of your choice and hit Enter key
6. Right click on just added folder and choose “Create a table“. (A new Table designer will open in the main working area)

Above steps will add a folder under “Managed Table section”, where you can create and   organize the managed tables

7. Enter the table name of your choice (Refer to rules for table name)
8. Click on ‘Add‘ link to add columns one by one OR enter numbers of columns you like in the table and then click on “Add many” button
9. Enter the column names for each of the column (Refer to rules for column names)
10. Click on drop-down button and select data type for the column
11. Tick check-box, if column is key column

12. Use Options to

  • Un-tick checkbox if column cannot be empty
  • Enter default values in the column when column cannot be empty and
  • Enter length of text for “Fixed length text data type column

13. Click on “Save” button

 

Above steps will add a managed table under “Sample Managed Table” folder, as shown in above image.

17 Comments
Leave a Reply

Latest Tweets

Free eBook: 10 Tips for sourcing good data yucalc.com/2017/02/17/fre…

reply · retweet · favorite

Newsletter

By signing up, you agree to our Terms of Service and Privacy Policy.

Address

Suite 1506, Westfield Tower 2, 101 Grafton St Bondi Junction NSW 2022 Australia

View Larger Map

Contact Us

AUS: +61-2-9386-0202
UK: +44-20-8123-1251
Send us an email

ContactUs.com
WordPress Image Lightbox