Using Q
Unify Q is for mid-tier managers, information workers, IT managers, IT personnel, developers and application end users to help them get their job
done quickly and easily.
- Mid-tier managers and information workers: Unify Q is used to gather facts for meetings and business decisions. Using Q, mid-tier
managers and information workers can provide the best data foundation for sound business intelligence. Once queries and reports for business intelligence
have been created, they can be shared in a multitude of ways, for example as excel files and PDF documents, or simply by sharing the query file that can
be executed by others.
- IT managers and IT personnel: Corporate IT can use Unify Q in a variety of ways. Q can be used to update non-integrated internal systems.
IT can use Q to integrate data pools after company mergers and create MIS reports for management. Q can also be used to provide reports on latest website metrics,
marketing campaign results, revenue figures and much more. IT also benefits from the data editing and import/export capabilities of Q that help to keep data up
to date and allows getting everyday database management tasks done.
- Developers: Developers can use Unify Q to synch development, testing and production databases. Using Q, developers can create database modification
scripts for deployed applications. They can very easily create test data for their development purposes and simulate multi-user access to the database. They can update
and insert data into tables that cannot be maintained by apps. Unify Q helps developers create documentation reports that document the application data model.
- Application users: Application users can use Q to create reports that are not part of applications and to modify application reports to their requirements.
Unify Q can be used to maintain and manage personal data including maintaining and merging personal Outlook contacts with contacts from other sources. Unify Q can be used by
application users to update data that is not editable via application screens (if allowed to).
Benefits
Personal Query Management, Personal Report Management and Information Sharing
- Personal Query Management: Building queries using Unify Q is very intuitive. Pick the desired tables and columns from a database and Unify Q will suggest
how to join the tables and display the table links graphically. The query can be fine tuned by adding as many conditions, sorting, groups and group conditions as you like.
When you are done, Unify Q displays the query results.
Queries can also be turned into nicely designed powerful reports. From the Q ribbon, just select Report Preview and a sample report design will be generated. Switch to Report Design
mode to change the design to meet your needs. The report can be printed or saved to PDF format and shared with colleagues and customers.
- Personal Report Management: Turn your database queries into stunning reports, including images, graphs and powerful cross tab reports. When done, save the
report as a PDF file and share it with friends and colleagues.
- Personal Information Sharing: Edit data content using the powerful and easy to use Q Table Activity. Update data that cannot be edited by application screens.
Unload data to Excel, XML, or HTML files. Import data into new or existing database tables. Create new tables from complex queries. Load data from Oracle or SQL Server databases
into a local SQLBase database. Create SQL script files for complex aggregation queries or data update procedures.
Share exported query data or table exports in HTML
format with friends, colleagues and customers.
Share exported query data or table exports in HTML format with friends, colleagues and customers.
Q for ISVs
Unify Q is a very useful tool for database application end users. Application users can use Q to create custom queries and reporting not included with applications. They can use
Q to customize existing application reports and edit data that is not available for editing from application screens (if allowed to).
The powerful and easy to use information sharing capabilities of Q allow for very easy data, report and query exchange with colleagues, management, customers and external agencies.
Unify Q supports export/import for Excel, CSV, XML and text files. Query results can be saved as HTML files and reports can be published as PDF documents.
Unify provides a special Embedded Deployment Pack (EDP) for ISVs that want to deploy their applications bundled with Unify Q.
The Q EDP allows ISVs to create combined installers for applications including Q. The end user will only see one installation being executed to install the application including Q.
Please contact Unify Sales for pricing details.