SQL Server Connector

SQL Server Ingestion Connector for Elasticsearch, Elastic Cloud, and Elastic Cloud Enterprise

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.

SQL Connectors for SharePoint

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:

  • 1

    Works with all types of data

  • 2

    Works with custom tables, documents, attachments, and BLOB data

  • 3

    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

  • 4

    Minimizes the impact on the source system through views or stored procedures as necessary, ensuring no impact to its performance

  • 5

    Only surfaces the content that users are permitted to see, even if the security configuration is custom designed

  • 6

    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 Elasticsearch, Elastic Cloud, and Elastic Cloud Enterprise 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 Elastic search engine. 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.

Drive Productivity

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