Azure SQL Database Connector

Azure SQL Database Ingestion Connector for Elasticsearch, Elastic Cloud, and Elastic Cloud Enterprise

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

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:

  • 1

    Provides both full and incremental ingestion of content into the index of your choice

  • 2

    Provides all management of security, role, and access list management, requiring no specialized security software or search index add-ons

  • 3

    Supports all data stored within Azure SQL

  • 4

    Supports filtering of the Azure SQL content, allowing administrators to define specifically which data is sent for ingestion into the search index

  • 5

    Brings all associated metadata into the search index to drive refinement and relevancy

  • 6

    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:

  • 1

    Provides enhanced search capabilities into your existing search application while ensuring the source system retains the master information

  • 2

    Indexes with a very high throughput

  • 3

    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.