Unify Q is an easy to use, yet powerful solution for typical end-user reporting requirements. The intuitive user interface easily enables creation of queries, reports and business graphs. Build queries and produce reports from queried data that include support for cross tabs, images and graphs. Then export reports or raw data to a variety of formats including Excel, CSV, text, XML, HTML, PDF and RTF. For added security and control, administrators can assign users as 'read-only' users to prevent them from changing the database data or schema, or as 'power users' enabling them to import data, write data and write and execute their own SQL queries.

Highlight

• Personal Query Management: Build queries to see the latest quarterly revenue numbers, monitor the success of online campaigns or see the performance of your online store. Data stored in your organization’s database can be queried and turned into useful information by Unify Q. Query results can be exported into a variety of formats or turned into stunning reports to share with team members, management and external service providers.
• Personal Report Management: Turn your database queries into stunning reports, including images, graphs and powerful cross tab reports. Unify Q offers powerful but easy tools to format reports including watermarks, text rotation and conditional formatting. When done save the report as a PDF file and share it with friends and colleagues. Or print a serial letter to invite customers to an event.
• Personal Information Sharing: Unload data to Excel, XML, or HTML files. Import data into new or existing database tables. Edit data content using the powerful and easy to use Q Table Activity. Update data that cannot be edited by application screens. 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 Excel format with friends, colleagues and customers.
  
  Unify Q supports the following document formats for data sharing: Excel, CSV, text, XML, HTML, PDF, and Rich Text files.

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).

Features

• Easy to use user interface with a 'ribbon UI' for easy navigation through the application
• Connect to a range of databases
• Easy to use querying capabilities
• SQL scripting support
• Edit table content
• Export and import data to and from a range of formats including Excel, XML and CSV
• Reporting capabilities - export to PDF and more
• Support for creation of tables, views and indexes
• Read-only version to help prevent accidental data modification
• Includes SQLBase 11.5 single user database with SQLBase Command Center

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.

System Req.

Database Support

• SQLBase 11, SQLBase 11.5
• Oracle 10g, 11g
• SQL Server 2005, 2008
• ODBC support

Operating System Requirements

• Windows XP
• Windows Server 2003
• Windows Vista
• Windows Server 2008
• Windows 7

Available languages: English, German, French, Spanish, Portuguese