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.

SQL Connectors for SharePoint

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.

Future-proof Your Investment

As new versions of the search platforms are released, new features and functionality are introduced, and the same is true of new releases of SQL. BA Insight takes on the burden of keeping the connector up to date for both SQL and the respective search engines. The upgrades are easy to do and can be done by your IT organization. It is simply a matter of accessing the BA Insight customer portal, downloading the latest release, and installing and configuring it. If desired, our professional services team can handle the upgrades.

Platforms Supported:

  • Amazon Kendra
  • Amazon OpenSearch Service
  • Azure Cognitive Search
  • Elasticsearch
  • Microsoft Search
  • SharePoint Online
  • SharePoint On-Premise
  • Solr

Drive Productivity

By connecting SQL to your preferred search engine, you increase adoption of your intranet, improving organizational efficiency and productivity.