OmniView fills that gap by providing powerful data manipulation capabilities in a simple user interface. DBAs, developers, tech support, QA staff...all will benefit from the ease of use of OmniView.

OmniView is a general-purpose data viewing/editing utility. We built OmniView in recognition of the need for easy, powerful access to raw data in database servers. OmniView is very useful for anyone involved in database development or maintenance.

Useful for Expert Users...

Database administrators and developers will find data access through OmniView quicker, easier, and more convenient than that which is provided natively with SQL Server Enterprise Manager and Query Analyzer. But users outside traditional development roles will find even greater value with OmniView...

...Invaluable for Nonexpert Users

OmniView was specifically designed to address the needs of technical users who need access to raw data but who aren't necessarily expert database developers or administrators. We have found that technical support staff, quality assurance teams, project managers, trainers, and others often need to directly examine and manipulate data outside the constraints of end-user applications which operate on that data.

This same group of people is often not as productive with the more developer-centric tools of Enterprise Manager or Query Analyzer. They need to rapidly and easily get in and out of data and then get on with their job.

Smart Editing Streamlines Tasks and Reduces Mistakes

OmniView is more than just a simple data browsing/editing tool. OmniView uses its knowledge of the server-defined characteristics of the data to streamline tasks, reduce data entry mistakes, and add convenience.

Some of the benefits of OmniView...

Users can setup private views of particular rows and columns, much like a SQL view but without having to setup a physical view in the database. Recall the view later with a simple mouse click.

Define groups of related or frequently used tables so you can easily access the tables you use most without having to scroll through the entire list of tables in the database.

Filter rows without knowing SQL syntax! Use a point-and-click interface to select column names and pre-defined operations. Filtering using actual SQL expressions is also available.

Add new records which are substantially similar to existing records using the "copy row" feature...saves you from manually rekeying similar data.

Export data to Excel, XML, HTML, or text formats.

Print formatted reports of selected data