Use Microsoft Dynamics As a Content Source

This feature is not available in the SearchUnify Cloud Edition.

SearchUnify can index the data stored in Microsoft Dynamics. This article explains how to use your instance as a content repository.

PERMISSIONS.

SearchUnify ignores Knowledge base level and cases level permissions.

Prerequisites

  1. Create an OAuth 2.0 Application in Microsoft Dynamics
  2. Create an Application User in Microsoft Dynamics

Establish a Connection

  1. Navigate to Content Sources and click Add New Content Sources.

  1. Find Microsoft Dynamics from the search box and click Add.

  2. Give your content source a name.

  3. Enter the address of your Azure instance in Client URL.

  4. Client ID, Tenant ID, and Client Secret were generated when you created an OAuth 2.0 app in Microsoft Dynamics. (Prerequisites). Enter them all.

  5. Click Connect.

  6. Select a Microsoft Account.

  7. Click Next.

Re-Connect

The Authentication screen is displayed when an existing Content Source is opened for editing, as given below. An admin can edit a Content Source for multiple reasons:

  • To reauthenticate

  • To fix a crawl error

  • To change frequency

  • To add or remove an object or a field for crawling

  • For multiple other reasons

When you edit a Content Source, there can be any one of two cases as listed below:

If the Content Source authentication is successful; a Connected message is displayed.

Case 1: There are no crawl errors and the Content Source authentication is valid.

If the Content Source authentication fails or is disrupted; a Re-Connect button is displayed.

There is a crawl error or the authentication details have changed. In both cases, the SearchUnify Content Source connection must be authenticated again i.e. re-authenticated. To authenticate a Content Source again, enter the authentication details, and click Re-Connect.

Set Up Crawl Frequency

The first crawl is always manual and is performed after configuring the content source. In Choose A Date, select a date to start crawling; the data created after the selected date will be crawled. For now, keep the frequency to its default value Never and click Set and move to the next section.

Select Types and Fields for Indexing

SearchUnify supports two Dynamics objects: cases and articles. You can select all, none, or only a few object properties (fields) for indexing.

Selecting none (by clicking Remove All) is a way to tell SearchUnify to not index an object (content type). For more precise indexing: 

  1. Click .

  2. Use the Name column to select a content field (Dynamics object property).

  3. SearchUnify will automatically assign a Label, Type, and condition (isSearchable: show in search OR isFilterable: use as a facet). You can change these values.

  4. Click Add.

  5. Repeat the steps 2, 3, and 4 to add other content fields.
  6. Click Save.

  7. Repeat the steps 1-6 for other content types (Dynamics objects).

  8. Press Save.

Find and Replace

Those on the Q2 '24 release or a later version will notice a new button next to each object on the Rules screen. It resembles a magnifying glass and is labeled "Find and Replace." You can use this feature to find and replace values in a single field or across all fields. The changes occur in the search index, not in your content source.

Find and Replace proves valuable in various scenarios. A common use case is when a product name is altered. Suppose your product name has changed from "SearchUnify" to "SUnify," and you wish for the search result titles to immediately reflect this change.

  1. To make the change, click .

  2. Now, choose either "All" or a specific content source field from the "Enter Name" dropdown. When "All" is selected, any value in the "Find" column is replaced with the corresponding value in the "Replace" column across all content source fields. If a particular field is chosen, the old value is replaced with the new value solely within the selected field.

  3. Enter the value to be replaced in the Find column and the new value in the Replace column. Both columns accept regular expressions.

  4. Click Add. You will see a warning if you are replacing a value in all fields.

  5. Save the settings.

  6. Run a crawl for the updated values to reflect in search results.

After the First Crawl

Return to the Content Sources screen and click in Actions. The number of indexed documents is updated after the crawl is complete. You can view crawl progress in in Actions. Documentation on crawl progress is in View Crawl Logs.

Once the first crawl is complete, click in Actions open the content source for editing, and set a crawl frequency.

  1. In Choose a Date, click to fire up a calendar and select a date. Only the data after the selected date is indexed.

  2. The following options are available for the Frequency field:

    • When Never is selected, the content source is not crawled until an admin opts for a manual crawl on the Content Sources screen.

    • When Minutes is selected, a new dropdown appears where the admin can choose between three values: 15, 20, and 30. Picking 20 means that the content source crawling starts every 20 minutes.

    • When Hours is selected, a new dropdown is displayed where the admin can choose between eight values between 1, 2, 3, 4, 6, 8, 12, and 24. Picking 8 means that the content source crawling starts every 8 hours.

    • When Daily is selected, a new dropdown is displayed where the admin can pick a value between 0 and 23. If 15 is chosen, then the content source crawling starts at 03 p.m. or 1500 hours every single day.

    • When Day of Week is selected, a new dropdown is displayed where the admin can pick a day of the week. If Tuesday is chosen, then content source crawling starts at 0000 hours on every Tuesday.

    • When Day of Month is selected, a new dropdown appears where the admin can select a value between 1 and 30. If 20 is chosen, then content source crawling starts on the 20th of each month.

      It’s recommended to pick a date in the range 1-28. If 30 is chosen, then the crawler may throw an error in February. The error will be “Chosen date will not work for this month.”

    • When Yearly is selected, the content source crawling starts at midnight on 1 January each year.

  3. Click Set to save crawl frequency settings. On clicking Set, you are taken to the Rules tab.

Data Deletion and SU Index

Deleted team IDs are fetched through APIs between frequency crawls and removed from the SearchUnify index.