Index SQL into Elasticsearch to provide an integrated search experience for your users. Microsoft SQL Server is the industry leading Operational Database Management System. In the past, Gartner has recognized Microsoft as a Leader 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.
The SQL Server Connector is built upon our ConnectivityHub, which is how we developed over 70 connectors that can be used for your enterprise search implementations. Like all of our other connectors, it honors the security of the source database and provides both full and incremental crawls so that users have the latest information available to them all the time.
The BA Insight Microsoft SQL Server Connector provides you with the capability to tap into the wealth of information stored within SQL databases, making that data discoverable across your organization.
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