Azure Search

Azure Search is a managed service from Microsoft Azure that enables you to add powerful and sophisticated search capabilities to your application. Azure Search is supported in our Cerulean product.

Overview

 

Azure Search is a managed service from Microsoft Azure that enables you to add powerful and sophisticated search capabilities to your application. With features like multiple languages support, faceting, suggestions, and relevance etc., Azure Search makes it super simple to provide a search engine for your application. Cerulean enables you to manage data in your Azure Search accounts from the convenience of your desktop and the platform of your choice. Using Cerulean, you can connect to your Azure Search accounts and manage data in there.


With features like Index, Data Source, and Indexer management, Integrated Search Console and data management plus support for other Azure services like Azure Cosmos DB, Azure Service Bus, Redis Cache and more, you don't have to look for any other tool to manage data in your Azure Search accounts.

Search Accounts

 
  • Connect: Connect to one or more Search accounts using account name and key.
  • Multi-Region Support: You can manage Search accounts hosted in all Azure regions where this service is supported.
  • Friendly Name: Assign a friendly name to your Search accounts e.g. "Development", "Production", "Staging" etc. for easier identification.
  • Resource Category: Assign a category e.g. "Development", "Production", "QA" to your Search accounts for resource categorization.
  • Permissions: Open an account in "Read Only" or "Read Write" mode to prevent accidental deletes and updates.

Indexes

 

Indexes contain the searchable data. You can think of it as a table in your relational databases. Cerulean provides the most comprehensive set of features to enable you manage indexes in your Search accounts.


General

  • List: List indexes in your Search account.
  • Create: Create index in your Search account.
  • Edit: Edit properties of an existing index in your Search account.
  • Delete: Delete one or more indexes from your Search account.
  • Copy: Create new index in a search account by copying an index schema from same/different account using easy to use UI.
  • Export: Export index schema in JSON format. Exported index schema can be either copied on the clipboard or saved to disk.

Fields

  • Add: Add fields to an index.
    • Data Type: You can specify data type for index field.
    • Attributes: You can choose attributes (key, facetable, filterable, retrievable, searchable, and sortable) for the field. Cerulean takes care of enabling/disabling attribute fields based on the data type selection so that you don't have to worry about attributes applicability based on data type.
    • Analyzers: For "String" and "String Collection" data type fields, using Cerulean you can set analyzers for an index field by selecting from a pre-defined list of analyzers (no need for you to remember). You can also set "Search" and "Index" analyzers as well.
  • Edit: Though Azure Search does not allow you to edit an existing index's data type and attributes, you can change the analyzer settings. Using Cerulean you can very easily change this setting.
  • Delete: While an index field is not saved, you can delete that field. Once a field is saved, it can't be deleted. This is a limitation from Azure Search.

Scoring Profiles

  • Add: Add scoring profiles to an index.
    • Function Aggregation: Specify function aggregation (Average, First Matching, Maximum, Minimum and Sum) for an index scroring profile by selecting from a pre-defined list.
    • Function: Add one or more functions (Distance, Freshness, Magnitude or Tag type function) to a scoring profile.
    • Weight: Add weights to a scoring profile by choosing index fields and specify weightage for those fields.
    • Default: Make the scoring profile as default scoring profile.
  • Edit: Edit scoring profiles in an existing index.
    • Function Aggregation: Change function aggregation value by selecting from a pre-defined list.
    • Function: Add new functions, edit existing functions or even delete one or more functions from a scoring profile.
    • Weight: Add weights to a scoring profile, edit existing weightage or even delete one or more functions from a scoring profile.
    • Default: Mark/unmark a scoring profile as default scoring profile.
  • Delete: Delete one or more scoring profiles from an existing index.
  • Scoring Profile Functions: Add/edit/delete scoring profile functions from a scoring profile. All four (Distance, Freshness, Magnitude or Tag) function types are supported.
  • Scoring Profile Weights: Add/edit/delete scoring profile weights from a scoring profile.

Suggesters

  • Add: Add new suggester to an index (new or existing). You can specify search mode (currently only analyzingInfixMatching is supported). There can be only one suggester per index.
  • Edit: Edit existing suggester by adding new fields to index suggester source fields. Other properties of a suggester can only be edited while a suggester is not saved.
  • Delete: While a suggester is not saved, you can delete that suggester. Once a suggester is saved, it can't be deleted. This is a limitation from Azure Search.

Cross-Origin Resource Sharing (CORS)

  • Add: Add domains that will be able to do search my making AJAX calls directly to your Search account.
  • Edit: Edit domains that will be able to do search my making AJAX calls directly to your Search account.
  • Delete: Delete one or more domains that will be able to do search my making AJAX calls directly to your Search account.
  • Max Age: Set the maximum age (in seconds) for which browser should cache the CORS settings and not send "Options" request.

Char Filters

  • Add: Add char filters to an index using an easy-to-use UI where Cerulean guides you through the process by informing you of various parameters and their values based on char filter type.
  • Edit: While a char filter is not saved, you can edit parameters for that char filter. Once a char filter is saved, it can't be edited. This is a limitation from Azure Search.
  • Delete: While a char filter is not saved, you can delete that char filter. Once a char filter is saved, it can't be deleted. This is a limitation from Azure Search.
  • Supported Char Filters: Using Cerulean you can create both "Mapping" and "Pattern Replace" type char filters.

Tokenizers

  • Add: Add tokenizers to an index using an easy-to-use UI where Cerulean guides you through the process by informing you of various parameters and their values based on tokenizer type.
  • Edit: While a tokenizer is not saved, you can edit parameters for that tokenizer. Once a tokenizer is saved, it can't be edited. This is a limitation from Azure Search.
  • Delete: While a tokenizer is not saved, you can delete that tokenizer. Once a tokenizer is saved, it can't be deleted. This is a limitation from Azure Search.
  • Supported Tokenizers: Using Cerulean you can create following types of tokenizers: "Classic", "Edge NGram", "Keyword", "Microsoft Language", "Microsoft Language (Stemming)", "NGram", "Path Hierarchy", "Pattern", "Standard" and "Uax Url Email".

Token Filters

  • Add: Add token filters to an index using an easy-to-use UI where Cerulean guides you through the process by informing you of various parameters and their values based on token filter type.
  • Edit: While a token filter is not saved, you can edit parameters for that token filter. Once a token filter is saved, it can't be edited. This is a limitation from Azure Search.
  • Delete: While a token filter is not saved, you can delete that token filter. Once a token filter is saved, it can't be deleted. This is a limitation from Azure Search.
  • Supported Token Filters: Using Cerulean you can create following types of token filters: "Ascii Folding", "Cjk Bigram", "Common Gram", "Dictionary Decompounder", "Edge NGram", "Elision", "Indic Normalization", "Keep Token", "Keyword Marker", "Length", "Limit", "NGram", "Pattern Capture", "Pattern Replace", "Phonetic", "Shingle", "Snowball", "Sorani Normalization", "Stemmer", "Stemmer Override", "Stopwords", "Synonym", "Truncate", "Unique", and "Word Delimiter".

Analyzers

  • Add: Add analyzers to an index using an easy-to-use UI where Cerulean guides you through the process by informing you of various parameters and their values based on analyzer type.
  • Edit: While an analyzer is not saved, you can edit parameters for that analyzer. Once an analyzer is saved, it can't be edited. This is a limitation from Azure Search.
  • Delete: While an analyzer is not saved, you can delete that analyzer. Once an analyzer is saved, it can't be deleted. This is a limitation from Azure Search.
  • Custom Analyzer: Using Cerulean, not only you can create"Pattern", "Standard", and "Stop" type analyzers but also you can create "Custom" analyzers using predefined and user defined char filters, token filters and tokenizers in an index.

Index Documents

 
  • List: List documents in an index.
  • Create: Create documents in an index using an easy-to-use UI.
  • Edit: Edit existing documents in an index using an easy-to-use UI.
  • Delete: Delete one or more documents from an index.
  • Documents Count: Cerulean shows you an approximate count of the documents matching a search query.
  • Key Lookup: Find a document based on the document's key.

Data Sources

 

A data source specifies which data to index, credentials for data access, and policies that efficiently identify changes in the data (new, modified, or deleted). Cerulean provides the most comprehensive set of features to enable you manage data sources in your Search accounts.



General

  • List: List data sources in your Search account.
  • Create: Create data source in your Search account.
  • Edit: Edit properties of an existing data source in your Search account.
  • Delete: Delete one or more data sources from your Search account.
  • Copy: Create new data source in a search account by copying a data source schema from same/different account using easy to use UI.
  • Export: Export data source schema in JSON format. Exported data source schema can be either copied on the clipboard or saved to disk.
  • Supported Data Source Types: Using Cerulean, you can manage following types of data sources: "Azure Blob", "Azure SQL", "Azure Table", and "DocumentDB".

"Azure Blob" Data Source

  • Enables you to index data in a blob container in an Azure Storage account.
  • Cerulean enables you to specify credentials for an Azure Storage account in multiple formats. You can specify credentials using account name/key, account shared access signature or container shared access signature.
  • Cerulean enables you to either select or specify a blob container name. As part of credential validation, Cerulean will fetch the list of blob containers in an Azure Storage account so that you can select from existing blob containers.
  • Cerulean enables you to specify a virtual folder inside a blob container if you only want to index data in a specified folder instead of data from entire blob container.
  • Using Cerulean, you can easily specify a Data Deletion Detection policy that can be used by Azure Search to automatically remove unrequired data.

"Azure SQL" Data Source

  • Enables you to index data in a table or view in an Azure SQL Database.
  • Cerulean enables you to specify credentials for an Azure SQL database.
  • Cerulean enables you to either select or specify a table or a view name. As part of credential validation, Cerulean will fetch the list of tables and views in the database so that you can select from existing tables/views.
  • Using Cerulean, you can easily specify a Data Deletion Detection policy that can be used by Azure Search to automatically remove unrequired data.
  • Using Cerulean, you can easily specify a Data Change Detection policy that can be used by Azure Search to automatically update changed data in the index.

"Azure Table" Data Source

  • Enables you to index data in a table in an Azure Storage account.
  • Cerulean enables you to specify credentials for an Azure Storage account in multiple formats. You can specify credentials using account name/key, account shared access signature or table shared access signature.
  • Cerulean enables you to either select or specify a table name. As part of credential validation, Cerulean will fetch the list of tables in an Azure Storage account so that you can select from existing tables.
  • Cerulean enables you to write an ODATA query if you only want to index certain entities from that table instead of data from entire table.
  • Using Cerulean, you can easily specify a Data Deletion Detection policy that can be used by Azure Search to automatically remove unrequired data.

"DocumentDB" Data Source

  • Enables you to index data in a collection in an Azure DocumentDB account.
  • Cerulean enables you to specify credentials for an Azure DocumentDB account.
  • Cerulean enables you to either select or specify a collection name. As part of credential validation, Cerulean will fetch the list of collections in an Azure DocumentDB database so that you can select from existing collections.
  • Cerulean enables you to write an SQL query if you only want to index certain documents from that collection instead of data from entire collection.
  • Using Cerulean, you can easily specify a Data Deletion Detection policy that can be used by Azure Search to automatically remove unrequired data.
  • Using Cerulean, you can easily specify a Data Change Detection policy that can be used by Azure Search to automatically update changed data in the index.

Indexers

 

Simply put, an Indexer is a service that acts as a bridge between a data source and an index in Azure Search. Its main job is to fetch data from the data source, transform that data if needed, and then insert/update/delete data in the index it associated with.


General

  • List: List indexers in your Search account.
  • Create: Create indexer in your Search account.
  • Edit: Edit properties of an existing indexer in your Search account.
  • Delete: Delete one or more indexers from your Search account.
  • Copy: Create new indexer in a search account by copying a indexer schema from same/different account using easy to use UI.
  • Export: Export indexer schema in JSON format. Exported indexer schema can be either copied on the clipboard or saved to disk.
  • Run: Using Cerulean you can run an indexer on demand.
  • Reset: Cerulean enables you to reset an indexer. This operation resets the change tracking state associated with the indexer. This allows you to trigger from-scratch re-indexing.
  • Status: Using Cerulean you can view the status of an indexer including the status of last few runs of the indexer.

Schedule

  • Indexer scheduler functionality lets you run an indexer at predefined intervals automatically.
  • Using Cerulean you can set an indexer schedule very conveniently by setting schedule interval and start date/time.

Parameters

  • Indexer parameters control the behavior of an indexer like batch size etc.
  • Using Cerulean you can set parameters like batch size, max failed items, max failed items per batch etc. very conveniently.

Field Mapping

  • Indexer field mapping functionality essentially creates a mapping between data source fields and index attributes.
  • Cerulean enables you to create/update/delete this mapping very easily.
  • Cerulean also enables you to specify and configure mapping functions. Cerulean supports "Base64 Decode", "Base64 Encode", "extractTokenAtPosition", and "jsonArrayToStringCOllection" mapping functions.