SQLOne is a web-based, keyword driven multi-database search engine that enables you to find the required information across multiple enterprise databases. You can search any database just as easily as you would search the Web. Enterprises can use SQLOne database search engine to get an integrated view of data across databases with its relationships and context intact. Currently supports MySQL database search, Oracle database search and SQL Server database search.

SQLOne is much more than a database full text search. Contrary to full text search engines, SQLOne offers a unique feature of fetching data not just from the matching tables, but also from its related tables, thus providing a complete view. It also offers the feature of searching across multiple databases.

SQLOne integrates seamlessly with existing Websites, enterprise applications and portals. Wide range of SQLOne built-in admin tools allow you to easily customize the search behavior to suit your specific requirements.

• Searches information scattered across multiple databases
• Employs familiar keyword driven web-based search interface
• Automatic categorization, enabling quick multi-dimensional navigation to search results
• Powerful HTTP based XML API to integrate SQLOne search in to your existing application
• Uses intelligent ranking to show most relevant results upfront
• Search and Result fetching considers primary-foreign key relationship between tables to provide complete information of the entity being searched
• Generates SQL queries for matching results
• Useful for database exploration and analysis with search, query generation, data model analysis and query execution features
• On-the-fly Search Result View customization in minutes, without writing a line of code
• Powerful SQLOne Administrative Console to manage and monitor search
• Enables seamless integration of SQLOne Search into your website or enterprise portal/Intranet   
  

• Instantly search across multiple databases
• Requires no SQL knowledge or understanding of data models
• Search-enable existing enterprise applications easily
• Easy-to-use web-based interface
• Zero impact on Application Database being searched
• Re-usable SQL Queries for repeated fetching/reporting of data
• Discover new relationships between data
• Quickly customize search GUI to integrate into your environment
  
  

  How SQLOne Works

SQLOne is a multiple database search engine that finds information present across different databases such as Oracle, SQL Server, and MySQL.

1. SQLOne Crawler: Crawls enterprise databases of different applications and creates an Index of all possible keywords that can be searched. The index database created will be the primary reference for the SQL Search engine.

2. SQLOne GUI: Offers a simple Web GUI that connects to the SQLOne Search Engine to find the searched keyword across the crawled and indexed databases. Users can search across multiple databases for any information they want just like a regular internet search