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.
Organizations who leverage Azure SQL can now extend the reach of this data into their existing search indexes via the BA Insight ConnectivityHub and our Azure SQL Connector.
The key capabilities of the Azure SQL Connector for Elasticsearch, Elastic Cloud, and Elastic Cloud Enterprise are:
Provides both full and incremental ingestion of content into the index of your choice
Provides all management of security, role, and access list management, requiring no specialized security software or search index add-ons
Supports all data stored within Azure SQL
Supports filtering of the Azure SQL content, allowing administrators to define specifically which data is sent for ingestion into the search index
Brings all associated metadata into the search index to drive refinement and relevancy
All content remains safely in Azure SQL. The portal has only a searchable representation of data – pointers – and users are directed back to the URL/source application to launch data found in their search results.
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