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 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 Azure SQL Database into Elasticsearch, Elastic Cloud, and Elastic Cloud Enterprise, 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 is built upon industry standard database access methods, so it can equally support databases from other systems such as Oracle, MySQL, and IBM DB2.

The key capabilities of the Azure SQL Connector for Elasticsearch, Elastic Cloud, and Elastic Cloud Enterprise are:

  • 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.

 

The benefits of including Azure SQL data within your Elasticsearch, Elastic Cloud, or Elastic Cloud Enterprise are:

  • Provides enhanced search capabilities into your existing search application while ensuring the source system retains the master information
  • Indexes with a very high throughput
  • Requires no custom code, with full support and enhancements

Future-proof Your Investment

As new versions of Elasticsearch, Elastic Cloud, and Elastic Cloud Enterprise are released, new features and functionality are introduced. BA Insight takes on the burden of keeping the connector up to date for both Azure 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 Azure SQL to your Elastic search engine you increase adoption of your intranet, improving organizational efficiency and productivity.