Getting started with Scai

Once logged in to the Scai platform, you will see the sidebar opened and several tabs that can be clicked. Let's go through them one by one.

Connect to a JDBC data source

To connect to a new data source, follow these steps:

  • go to Settings, Data sources
  • click the Create new from the right side of the header
  • after the menu pops up, fill in all the JDBC information, such as:
    • database vendor
    • data source name
    • url
    • username
    • password
    • shared - whether the source is shared with the users or not
  • click the Save button
  • once the data source is added to the data sources table, you can click on its name to switch to it
  • click on yes and you will be automatically switched to the data source

Exploring Data

This Data sidebar tab will let you explore the data inside your SQL data source. Once this tab is opened, you can see all the SQL data source schemasthat are visible to Scai and that have not been hidden in Scai's configuration tables. Clicking on any schema listed here should display a list oftables that are visible to Scai and belong to the given schema. Finally, clicking on any of these tables will lead you to viewing the table's contentsin list view.

Open table or view

Search for the name of table or view in the left sidebar. Once found, simply click on the its link to open it.

List table or view

Once a table is opened, you will see its contents. Actually, you will usually only see the first 20 rows of this table. These rows will listed inside a widget.If not all rows are visible, you will be see them all by scrolling the widget data. The widget containing the table rows is draggable and resizable. In fact,all widgets that you will run into while playing with Scai are draggable and resizable.

You can move them by either:

  • dragging the header
  • dragging from the top-left corner

You can resize them by focusing one of the corners except the top-left one and dragging until the widget size meets your needs.

To navigate through different pages, press one of the numbers (or arrows) in the bottom-left corner.

Seeing more than 20 rows

You can choose how many rows you would like to see per widget by selecting a different number from the bottom-right select box.

Ordering rows

To order the table contents, you can click on any column name once. This will make the data to be ordered by the values on that particular column. By clicking twice, the data will be sorted in descending order by the values on the focused column. You will see that in both cases a symbol will appear next to thecolumn header describing the ascending or descending order.

If multiple column headers are clicked, then the data will be sorted according to the order the column headers were pressed. You will see that each column headerwill have, attached to the symbol, a small number that will describe the priority of the column in the final ordering (lower numbers have higher priority).

Filtering data

Here is an example on how you can drill down on your interesting data subset starting from a dashboard.

To filter the table data, you can click on the magnifying glass attached to any column header.

  • this will open a small window where you can choose how the filtering on that column should be performed
  • once the text input is focused, some suggestions of values will appear. As you type further in this text input, you will see suggestions that match the text you have entered
  • clicking on the top-right check mark will trigger the data filtering.

By default, all the rows that have a value on the filtered column that contains the entered text will be selected. This is because, when we opened the small window, we leftthe operation type (like) unchanged. There are other operation types that can be selected:

  • like filters all values that contain the entered text
    • only available for string columns
  • = filters all values that are exactly the same as the entered characters/number/date
  • not like filters all values that do not contain the entered characters
    • only available for string columns
  • not filters all values that are not exactly the same as the entered characters/number/date
  • > filters all values that are greater than the entered number or after the entered date
    • only available for number and date columns
  • filters all values that are greater than or equal to the entered number or on or after the entered date
    • only available for number and date columns
  • < filters all values that are smaller than the entered number or before the entered date
    • only available for number and date columns
  • filters all values that are smaller than or equal to the entered number or on or before the entered date
    • only available for number and date columns

Load file

Go to the main left sidebar, click Data, then Load file or simply search Load file and then follow these steps.

Create a graph

Firstly, open the table or view based on which you would like to create a graph, then click the Graph . The graph sidebar of that particular table or view will be open with all the columns specific to it. Select your columns to plot and click Preview. If you want to save the graph to a dashboard, click Save.

Create a dashboard

If you want to create a new dashboard, go to the main sidebar menu, click Dashboards and then Create new dashboard or, simply search for Create new dashboard and then click it. Then, a new dashboard will be created and you can start adding graph widgets by clicking the + button from the header.

Create a view

If you have permissions and you want to create a new view, simply search for Console or click Data, then click Console. Type your SQL code and click the Submit button to execute the code. If you want to save the view, click the Create View button from the header and save the view to a specific schema.

Another way of creating a view is by going to a table or view and clicking the Measurements button. Then, select the columns based on which you would like to create a view and click Save. A new table widget will be open with the report. If you have the permissions in place, you can save the view by clicking the Save button.