Azure SQL Database Connector

Azure SQL Database Indexing Connector for Azure Search, SharePoint Online/O365, SharePoint 2016 and SharePoint 2013

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 Azure, SharePoint Online or SharePoint 2016/2013, surfacing it through BA Insight’s SmartHub to provide users with integrated search results

azure search Connectors for SharePoint

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.

Our Azure SQL Database Connector is off-the-shelf software that addresses the following requirements:

  • 1

    Works with all types of data.

  • 2

    Works with custom tables, documents, attachments, and BLOB data.

  • 3

    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.

  • 4

    Minimizes the impact on the source system through views or stored procedures as necessary, ensuring no impact to its performance.

  • 5

    Only surfaces the content that users are permitted to see, even if the security configuration is custom designed.

  • 6

    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 Azure Search and SharePoint Search are released, new features and functionality are introduced, and the same is true of new releases of the Azure SQL Database.

Drive Organizational Productivity

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

Some of the attributes of the Alfresco Connector are:

  • 1

    Support of unstructured content, structured data, large documents, and attachments.

  • 2

    Very high throughput, supporting large implementations. Many Alfresco customers have millions of documents or even hundreds of millions. Just 1 million documents indexed at 1 document/second would take over 11 days for a full crawl!

  • 3

    The architecture minimizes the impact on the source system to ensure there is no impact on the performance Alfresco.

  • 4

    Adherence to Alfresco’s security schema, only surfacing the content that users are permitted to see.

  • 5

    Alfresco retains the master information and the search index is only a representation. Users work on the original document when they click on search results.