Universal Data Corporation - UDQ Features

Click to read more...

universal data corporation

Universal Data Query (UDQ) Features

UDQ helps you work with data

See the tables & views in your database
Create queries against the data without typing SQL
Sort, filter and drill into the details
Instantly filter result sets
Group data by dragging columns
Quickly summarize data with grouping and aggregate function
Export data for further analysis
Create presentation-quality reports from the data
Navigate large XML files
Create reports for distribution that prompt for input (ex: Enter starting date:)
Organize queries and reports into project folders

Supported platforms

IBM Informix Dynamic Server
IBM DB2
Microsoft SQL Server
Microsoft Access
mySQL
Oracle
Progress
Sybase
Many others (UDQ supports virtually any SQL offering OLEDB or ODBC connections)

Building queries

UDQ has a unique point-and-click query builder
UDQ supports complex join operations without prior knowledge of SQL
The filter wizard guides access to just the data you are seeking
No prior knowledge of SQL is required
Single-click to count records or preview data from a table or view
Query history buffer

Browsing data

Unique, filterable data grid presentation of data
Instantly group data
Format cells, add counts, totals, averages and more
View the previous query's data grid
See data as text listing
Visualize data in cards, grid and layout data view formats
Search within query results
Instantly sort data by any column

Reporting on data

Instantly create attractive reports
Choose from several pre-formatted report themes
Report on filtered results
Control report's appearance with report preferences

Export data

Export to Microsoft Excel for further analysis
Column labels and data types are preserved
Export to PDF to share your data with others
Export to Microsoft Word for additional formatting
Export to HTML for presenting data in a browser
Export to XML for uploading to other tables or systems
Export to CSV delimited for cross-platform operations

Technical considerations

Multithreaded client remains responsive during long-running queries
Single-click query cancellation reacts immediately
Warns (and offers to cancel) when large result set detected
Designed by expert DBAs for general user community usage
Formulates well-structured queries; won't tax system resources
Intuitive interface easily mastered by most users
Single-trip to the database - filtering, sorting, grouping occurs in the UI, not the database!