The BA Insight Microsoft SQL Server Connector for Search integrates your organization’s SQL-based databases—including SQL Server, MySQL, Oracle, IBM DB2, and more—with leading enterprise search solutions such as SharePoint, Azure AI Search, Elasticsearch, Amazon Kendra, Solr, and others.
Leveraging BA Insight’s robust connector framework, the SQL Server Connector ensures secure, reliable connectivity. It supports both full and incremental crawls, automatically synchronizing the search index with new and modified database records.
Problems SQL Server Connector for Search Solves
Difficulty accessing and searching vital SQL database content without direct database access.
Disconnected search experiences when SQL-stored data is siloed from other enterprise content.
Security concerns about exposing sensitive or regulated database records to wider audiences.
Maintaining up-to-date search indexes as database content evolves—without manual intervention.
Benefits SQL Server Connector for Search Delivers
Seamless Integration with Leading Search Platforms
Seamless connection of SQL database content with SharePoint, Azure AI Search, Elasticsearch, Amazon Kendra, Solr, and more.
Strict Security Trimming Based on Native Database Permissions
Fully honors native database security—ensuring users only see the data they’re authorized to access.
Full and Incremental Indexing for Fresh Results
Supports both full and incremental indexing, keeping search results fresh and synchronized as records are added or updated.
High-Throughput Crawling with Live Record Pointers
High-throughput crawling that returns live pointers to original records—keeping information accurate and centralized.
Unified Search Experience Across SQL and Other Repositories
Boosts productivity by enabling unified search across all SQL data and other repositories from a single interface.
Key Features of the SQL Server Connector for Search
Key Features of the SQL Server Connector for Search
Use the left and right arrow keys to move between tabs. Swipe or drag to scroll through more tabs. Press Enter or Space to activate a tab.
Comprehensive Content Indexing
Comprehensive Content Indexing
Securely indexes tables, views, and metadata from any SQL-based database, supporting both full and incremental crawls for always-current results.
FAQ
FAQ
-
Yes, the connector honors source database security, ensuring users only see information they are permitted to access.
-
Both full and incremental crawls are supported—automatically synchronizing the search index whenever database content is added or modified.
-
SharePoint Online and On-Premise, Azure AI Search, Elasticsearch, Amazon Kendra, Amazon OpenSearch Service, Solr, and more.
-
Any relational database with industry standard connection methods—such as SQL Server, Oracle, MySQL, and IBM DB2—can be connected and indexed.
-
No, the connector requires standard read access and does not need software installed on the database itself.