Omega.MSSQL:
Features |
Online Demonstration |
Pricing
Who Should Use Omega.MSSQL? |
Why You Should Use Omega.MSSQL?
Omega.MSSQL allows you to access and manage* your Microsoft SQL Server® databases using just your browser.
That means your database users need not install any special database access software to access the database.
Product Features
Omega.MSSQL allows you to access and manage* your Microsoft SQL Server® databases using just your browser.
That means your database users need not install any special database access software to access the database.
| Database Explorer |
|
Omega.MSSQL provides you in-depth information about various database objects contained in the
database ranging from tables, columns, views, and users etc. all by using a very intuitive and easy to
use browser based interface. Using just one application you can connect to SQL Server 2008,
SQL Server 2005 and SQL Server 2000.
Demo Video
|
More Information
|
| Designers |
|
Omega.MSSQL includes designers for most commonly used objects like tables, views etc. Using Omega.MSSQL you can design (CREATE/ALTER/DROP)
these objects just by using the browser based interface of Omega.MSSQL. These features can be enabled or disabled by setting simple values
in the configuration file so that administrator can control if the users of Omega.MSSQL are allowed to use these features. Table below explains
the designer features available in Omega.MSSQL:
Table Designer:
Using the table designer feature, you can create new
tables, edit (alter) & drop existing tables. You can define new columns, define default constraints for
the columns, define computed column specifications for the new columns etc.
Demo Video Of Table Designer
View Designer:
Using the view designer feature, you can create new
views, edit (alter) & drop existing views.
Demo Video Of View Designer
Stored Procedure Designer:
Using the stored procedure designer feature, you can create new
stored procedures, edit (alter) & drop existing stored procedures.
Demo Video Of Stored Procedure Designer
User Designer:
Using the user designer feature, you can create new
users in your database, edit (alter) & drop existing users. When defining users, you can define the roles that
user can have and the list of owned schemas.
This functionality is available for SQL Server 2005 and above.
Role Designer:
Using the role designer feature, you can create new
roles in your database, edit (alter) & drop existing roles. When defining role, you can define the users that
belong to this role. You can create both Database Roles & Application Roles.
This functionality is available for SQL Server 2005 and above.
Rule Designer:
Using the rule designer feature, you can create new
rules in your database, edit (alter) & drop existing rules.
Default Designer:
Using the default designer feature, you can create new
defaults in your database, edit (alter) & drop existing defaults.
User Defined Function Designer:
Using the user defined function designer feature, you can create new
user defined functions in your database, edit (alter) & drop existing user defined functions.
You can define scalar, inline, and table valued
user defined functions using Omega.MSSQL.
User Defined Data Type Designer:
Using the user defined data type designer feature, you can create new
user defined data types in your database, edit (alter) & drop existing user defined data types.
User Defined Type (Assembly Type) Designer:
Using the user defined type designer feature, you can create new
user defined types in your database, drop existing user defined types.
This functionality is available for SQL Server 2005 and above.
Schema Designer:
Using the schema designer feature, you can create new
schemas in your database, drop existing schemas. This functionality is available for SQL Server 2005 and above.
Synonym Designer:
Using the synonym designer feature, you can create new
synonyms in your database, drop existing synonyms. This functionality is available for SQL Server 2005 and above.
Database Trigger Designer:
Using the database trigger designer feature, you can create new
database triggers in your database, drop existing database triggers. This functionality is available for SQL Server 2005 and above.
User Defined Table Type Designer:
SQL Server 2008 introduced User Defined Table Types. Omega.MSSQL has a table type designer feature. Using the user defined table type designer feature, you can create new
user defined table types in your database, drop existing user defined table types. This functionality is available for SQL Server 2008.
Plan Guide Designer:
SQL Server 2008 introduced Plan Guides. Omega.MSSQL has a plan guide designer feature. Using the plan guide designer feature, you can create new
plan guides in your database, drop existing plan guides, enable or disable plan guides. This functionality is available for SQL Server 2008.
|
| Database Search |
|
Using any database query tool you can easily find out the information contained in the tables (i.e. data).
However there is not efficient way to search metadata. For example if you need to find what all tables contain a
particular column, your only choice is to look manually into each and every table in the database to find the
information you are looking for. Omega has an in-built metadata search engine. You specify what you are looking for,
in what all objects (e.g. tables, views, etc.) you want to search for this information and Omega will list all
the objects containing the information you are looking for.
Demo Video
|
More Information
|
| Database Documentation |
|
Omega.MSSQL lets you document your SQL Server databases. As a part of database documentation
users can provide a meaningful explanation of various objects contained in the database. This feature
is very useful for the development team and the business users of the database who will know exactly
what kind of information is contained in which database object.
For table columns and stored procedure parameters, Omega.MSSQL also allows you to specify what
kind of values will be contained. Depending upon the data type, a user can specify that a column
can contain all possible values, a set of selected values (e.g. 'A', 'B', or 'C') or a range of values
(e.g. between 1 and 1000, less than 10000, greater than 50000 etc.)
Demo Video
|
More Information
|
| Reporting |
|
Omega.MSSQL has a built-in reporting engine using which you can generate
reports about the database structure and associated documentation.
Reports can be generated for all database objects or selected objects (e.g. Tables & Views only).
Users can save the reports in XML & HTML format (other formats coming soon).
Users have an option of saving the report on the web server for sharing and downloading it on their machines
for later viewing purposes. For a sample report, click here.
Demo Video
|
Sample Report
|
| SQL Query Builder |
|
What good a database explorer would be if you cannot query the database to view the data.
Well Omega.MSSQL has an in-built SQL Query builder using which you can create and execute
SQL queries against your database. You have an option of designing the queries using a
WYSIWYG query builder or writing on your own. The query engine has an in-built query validator
which can be used to validate the queries for syntactical errors before they are executed.
Demo Video
|
Online Demonstration
Want to try Omega.MSSQL even before downloading!!! Click on the fully functional online demonstration links below.
You will have access to our application connecting
to one of our sample databases (and not just some Flash animation movie). The demo version
however has some limitations/built in features:
- Any updates/deletes/structure changes done by you using the SQL Query editor will not be saved.
- Database server name will be masked.
- The demonstration application will automatically log you in. You do not have to provide the database
login name and password.
This demonstration application connects to AdventureWorks database (SQL Server 2005).
So what are you waiting for!! Click on the link below to get started with the demonstration and try
the software.
- Omega.MSSQL Demo - SQL Server 2005 (AdventureWorks Database)
|
Pricing
Omega.MSSQL is licensed per SQL Server installation. Using Omega.MSSQL, You can connect to all the SQL Server databases
installed on a SQL Server for which you have acquired a license to use Omega.MSSQL. Product pricing will depend on the number of
licenses requested by you. Please note that a license is required to use Omega.MSSQL.
Currently we offer three kinds of licenses:
Trial License:
A trial license as the name suggests is for you to try out Omega.MSSQL and is obviously free of cost.
A trial license allows you to connect to any SQL Server database (provided you have login on that
database server) and is valid for a period of 30 days from the date you requested it. You will need to provide a
valid email address so that we can send you the trial license.
Individual License:
An individual license as the name suggests lets you use Omega.MSSQL as an Individual. An individual license allows you to
connect to up to 2 database servers of your choice along with the databases hosted on your local computer [normally accessed
by specifying (local) or (local)\SQLExpress)] and is valid for a period of 90 days from the date you download it. Currently
an individual license is offered absolutely free of cost. You will need to provide a valid email address so that we can send
you the individual license.
Enterprise License:
An enterprise license as the name suggests lets you use Omega.MSSQL in an enterprise setting. If you are an organization and
wish to use Omega.MSSQL in your organization, you will need to procure an enterprise license. An enterprise license allows you
to connect to any SQL Server database (provided you have login on that database server) and is valid for a period of 365 days
from the date you requested it. You will need to pay to procure an enterprise license and would need to register and create an
account with us before you could procure an enterprise license.
|
| Who Should Use Omega.MSSQL? |
|
Web Hosting companies: Web hosting companies who offer Microsoft SQL Server to their
customers can use Omega to provide their customers with a browser-based access to their respective
databases from their portal for an overall integrated experience. Customers need not download/install/use
3rd party software for accessing their databases.
Organizations with a need to expose their databases: Often times, organizations need
to provide a direct access to their databases outside of their network. Usually the databases reside
within organization internal networks. Currently for this they will have to open up certain ports within
their firewall (e.g. TCP port 1433) or resort to mechanisms like Virtual Private Networks (VPN) so that
database access tools (like Enterprise Manager etc.) can connect to the database. Using Omega.MSSQL, they can easily
do so by fronting their databases with Omega.MSSQL. Under a normal deployment scenario, they would host Omega.MSSQL in their
DMZ network segment (along with their other web applications) and they will have to just open up ports used
by SQL Server between DMZ and their internal network (which would already be open if they are hosting
database-based applications using SQL Server).
New Employees/Business Users: Database documentation is one of the most ignored parts of the
overall documentation process. Omega has the capability to document most of the database objects. Omega can be used
to train new IT staff on the enterprise databases. Similarly Omega.MSSQL can be used to provide information about the
objective of a particular database object (e.g. what a particular table does, or what kind of values a column
can contain) from a business perspective to a business user.
Ad-Hoc Reporting Users: Omega has a built in query engine using which users can build and
execute queries against a particular database. Skilled users can write their own complex SQL queries and
at the same time a novice user can use an easy-to-use graphical user interface to design and execute queries.
|
| Why You Should Use Omega.MSSQL? |
|
There are a number of reasons you should use Omega.MSSQL:
Browser based: First and foremost, it is browser-based. What that means is that you or your
database users need not install any special software to access database. Just use a web browser to find
information about the database.
Built-in Search Engine: Omega.MSSQL has a built in search engine which allows your users
to search for objects (not data) contained in the database. For example, you can search for a column
name and Omega.MSSQL will bring the list of tables which contain this column.
Built-in Query Engine: Omega.MSSQL has a built in query engine which allows you or your users
(at various skills level) to design and execute queries against your database.
Security: If you are a database or network administrator, you need not open up your database
to the outside world. Just front your database with Omega.MSSQL, if somebody from outside of your organization
needs to access your database. You can configure Omega.MSSQL to limit certain functionality (e.g. you do not want users to
use query engine of Omega.MSSQL to execute queries against your database).
Document your database: Omega.MSSQL allows you to document your database objects and provide
business/technical importance of these objects to your team members. Think of it as
a great tool for your new hires (who often have to rely on current staff to get an
understanding of the database) and business users (who have to struggle with the business
understanding of a particular object)!!
|
|
| |
|
Version 2008.11.000.01
|
A license key is required to run Omega.MSSQL
|
See Omega.MSSQL in action connecting to one of our databases
|
Watch demo videos (Flash) of Omega.MSSQL
|
Download/View installation guide (PDF format)
|
| |
|
|
|