Microsoft SQL Server is the industry leading Operational Database Management System. Gartner recognized Microsoft as a Leader once again in the Magic Quadrant for Operational Database Management Systems, positioning it furthest to the right on the axis for completeness of vision, and closest to the top on the axis for ability to execute.
Organizations leverage SQL Server to solve a wide range of complex business problems, and the data stored within these specific databases often goes unnoticed in the intranet or search portal platform. The BA Insight SQL Server Connector allows organizations to tap into the wealth of data stored within SQL databases, making that data instantly actionable to users through search.
The SQL Server Connector is built upon industry standard database access methods, so it can equally support databases from other systems such as Oracle, MySQL, and IBM DB2. It honors the security of the source database and provides both full and incremental crawls so the users have the latest information available to them all the time.
The SQL Server Connector is standard, off the shelf software that addresses the following requirements:
Works with all types of data.
Works with custom tables, documents, attachments, and BLOB data.
Indexes every desired item with a very high throughput. Many SQL databases have millions of rows, making high throughput critical to the success of the implementation.
Minimizes the impact on the source system through views or stored procedures as necessary, ensuring no impact to its performance.
Only surfaces the content that users are permitted to see, even if the security configuration is custom designed.
The source system retains the master information and the search index has only a representation (pointers). If applicable to the database being crawled, users click on a search result and are taken to their original item or document.