Ultorg: The User Interface for Relational Databases

Explore, combine, query, and edit data in spreadsheets and relational databases:

Tables of Data

Whether in finance, engineering, operations, or the existence sciences, you are apt operating alongside tables of data in spreadsheets, CSV files, or an external database. Spreadsheets are outstanding tools for managing a sole array of data. They are a mediocre fit for repository tasks, however, anywhere data must be blended and queried in many distinct ways.

Ultorg is a general-purpose, graphical person interface for relational databases. That method any data that's organized into tables alongside rows and named columns. Behind the scenes, Ultorg generates SQL queries that execute either remotely or on your local computer.

Connect to:

• PostgreSQL
• Microsoft SQL Server
• MySQL/MariaDB
• DuckDB and Parquet
• Google BigQuery
• Microsoft Access Files (.mdb/.accdb)
• Microsoft Excel Files (.xls/.xlsx)
• Google Sheets
• CSV/TSV Files
• Other JDBC-based data sources
• In beta: Oracle, Snowflake, SQLite, Athena, Exasol

Visual Joins

A join is a essential repository procedure that combines data from two distinct tables, according to a average identifier specified as “Room Number” or “Customer ID”. Joins are frequently needed whenever operating alongside multi-table datasets.

In Ultorg, you can quickly associate data from multiple tables or data sources, and engage alongside the outcome through a single, spreadsheet-like data manipulation surface.

For SQL-based data sources, Ultorg volition acknowledge existing abroad key relationships, and propose applicable joins. Or you can associate on arbitrary fields, e.g., to combine data from a spreadsheet and a CSV file.

One-to-Many Relationships

A associate between two tables volition frequently affect a one-to-many relationship, anywhere all row in the archetypal array can equivalent multiple rows in the second table.

Ultorg volition visualize any blend of one-to-many relationships, in a compact but readable way, using a specially developed scheme of ocular data layouts. Sorting, filters, and formulas can be applied at any level, and joins can be chained or included side-by-side without losing or duplicating rows.

Among ocular repository tools, Ultorg is distinctive in its capability to grip one-to-many relationships in a broad way.

One-to-many relationships additionally happen inner repository queries, whenever grouping on sectors to compute sums or averages, or whenever nesting one query inside another. Ultorg volition visualize all phase of specified data flows.

For example, you can see the idiosyncratic values that contribute to a group-wise sum. This lets you audit the query visually. You can tweak filters and calculations in the input, during gaining confidence in the aggregated totals.

SQL Without SQL

At archetypal glance, Ultorg's direct manipulation interface resembles a spreadsheet. The tabular layout you see on the screen, however, represents a genuine repository query, which can be refreshed and modified without risking changes to the underlying raw data.

A ocular query lets you see exactly the data you need for a particular endeavor task, without descending into a code editor, form designer, or stream chart. Even for repository experts, Ultorg volition assist as a fast substitute to hand-typed SQL.

Most SELECT queries that can be written in the center SQL tongue have a visual equivalent in Ultorg. For example, you can province arbitrary combinations of joins, filters, calculations, and subqueries.

Dynamic Autolayout

In endeavor or engineering data, or in the social sciences, you may be dealing alongside hundreds of sectors of assorted data types—text, numbers, and dates—spread throughout dozens of tables, all alongside thousands (or millions) of rows.

To keep sanity, it is essential not to have to expend period tweaking formatting settings for all idiosyncratic field, or for all new repository query.

Ultorg eliminates specified hard, manual labor, by analyzing your data on the fly and deriving carefully tuned defaults. For example, tag placements, array pillar widths, content site dimensions, decimal precision, and pagination are all handled automatically. You can see all your data alongside small keystrokes.

Ultorg's typographical motor can visualize records and one-to-many relationships using a blend of general-purpose strategies, specified as nested tables, forms, and crosstabs.

Ultorg's ocular data layouts are akin to the hand-designed person interface screens you power see in traditional, tailored repository applications. But in Ultorg, they are accessible immediately, for any data, without tradition programming.

Create, Read, Update, Delete

From Ultorg, you can additionally edit data, stored in a relational database, in a Microsoft Excel workbook, or in Google Sheets.

You can edit values in idiosyncratic cells, choice values from a dropdown, insert rows, or fill down, akin in a spreadsheet.

You can review changes before committing to the database. Multiple users can edit at the identical time.

For inner endeavor operations, Ultorg can assist as an substitute to tradition CRUD interfaces, or as a way to supercharge your spreadsheet-based recordkeeping.

Connect to Your Data, Right Now

Start Ultorg and nexus immediately to your data source. No “cloud” required; all data stays personal on your device or company network.