BA Insight’s Azure SQL Database connector for search is built upon industry standard database access methods, so it can equally support databases from other systems such as Oracle, MySQL, and IBM DB2.

Azure SQL Database is the intelligent, fully-managed relational cloud database service that provides the broadest SQL Server engine compatibility so you can migrate your SQL Server databases without changing your apps. Accelerate app development and make maintenance easy and productive using the SQL tools you love to use. Take advantage of built-in intelligence that learns app patterns and adapts to maximize performance, reliability, and data protection.

Azure SQL Database uses built-in intelligence that learns your unique database patterns and automatically tunes the database for improved performance and protection. Threat Detection monitors your database around-the-clock and detects potential malicious activities, alerting you upon detection so you can intervene right away.

Build security-enhanced apps in the cloud with advanced built-in protection and security features that dynamically mask sensitive data and encrypt it at rest and in motion. Ensure high availability with three hot replicas and built-in automatic failover that guarantees a 99.99% availability SLA. Accelerate recovery from catastrophic failures and regional outages to an RPO of less than five seconds with active-geo replication. With physical and operational security, SQL Database helps you meet the most stringent regulatory compliances, such as ISO/IEC 27001/27002, Fed RAMP/FISMA, SOC, HIPPA, and PCI DSS.

BA Insight’s Azure SQL Database connector for search 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 of the time. It indexes content from the search engine, surfacing it through BA Insight’s SmartHub to provide users with integrated search results.

azure search Connectors for search indexing

BA Insight’s Azure SQL Database Connector for search is built upon industry standard database access methods, so it can equally support databases from other systems such as Oracle, MySQL, and IBM DB2.

Our Azure SQL Database Connector is 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 the Azure SQL Database.

Platforms Supported:

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

Drive Organizational Productivity

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