The BA Insight SQL-based Connector for Search integrates Microsoft SQL Server and other SQL-compatible databases—including Oracle, MySQL, and IBM DB2—with leading enterprise search platforms such as SharePoint, Azure AI Search, Elasticsearch, and others. It enables organizations to surface the wealth of structured data within their SQL databases, making content instantly actionable through unified enterprise search, without requiring users to log directly into the source database.
Problems SQL-Based Connector for Search Solves
Difficulty connecting business-critical SQL database content to the intranet or enterprise search platforms.
Fragmented search experiences and loss of valuable information due to siloed SQL data repositories.
Security concerns overexposing sensitive database content in integrated search results.
Maintaining up-to-date search indexes as database records are frequently changed or updated.
Benefits SQL-Based Connector for Search Delivers
Seamless Integration with Leading Enterprise Search Platforms
Seamless integration with major enterprise search platforms including SharePoint, Azure AI Search, Elasticsearch, and others.
Honors Native SQL Database Security Controls
Honors native security controls for each supported SQL databases, ensuring users access only permitted data.
Supports Full and Incremental Crawls for Real-Time Updates
Supports full and incremental crawls for efficient, real-time content updates in the search index.
Transforms SQL Data into Actionable Search Results
Transforms SQL content and metadata into actionable enterprise search results, improving data discoverability and productivity.
Broad SQL Compatibility Across Major Databases
Broad SQL compatibility using industry-standard protocols, supporting databases such as Oracle, MySQL, IBM DB2, and MS SQL Server.
Enhanced Metadata Enrichment and Normalization
Facilitates enrichment and normalization of metadata for improved search relevance and user experience.
Key Features of the SQL-Based Connector for Search
Key Features of the SQL-Based 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
Indexes structured data from SQL tables, views, and custom SQL queries, supporting full and incremental updates for continuous accuracy.
This connector helps organizations unlock and amplify the value of their SQL-based data within their enterprise search ecosystem, connecting structured database information directly to platforms like SharePoint, Azure AI Search, and Elasticsearch for secure, centralized, and actionable discovery.
FAQ
FAQ
-
Yes, it enforces native SQL database security permissions, so users only see data they are authorized to access.
-
It supports both full and incremental crawls, keeping the search index synchronized with database changes and updates.
-
The connector integrates with SharePoint Online and On-Premises, Azure AI Search, Elasticsearch, and other enterprise platforms.
-
No, the connector operates agentlessly, requiring only read-only database access credentials.
-
BA Insight’s metadata enrichment and classification tools harmonize and enrich metadata across connected SQL sources, improving findability and navigation.