Step 1. Launch Aspire and open the Content Source Management page

Launch Aspire (if it's not already running).

• See Launch Control
• Browse to: http://localhost:50505

For details on using the Aspire Content Source Management page, refer to Admin UI

Step 2. Add a new SQL content source

To specify exactly what shared folder to crawl, we will need to create a new "Content Source".

To create a new content source:

1. From the Content Source , click on "Add Source" button.
2. Click on "Aspire CosmosDbSql Source".

Step 2a. Specify basic information

In the "General" tab in the Content Source Configuration window, specify basic information for the content source:

1. Enter a content source name in the "Name" field. 
   1. This is any useful name which you decide is a good name for the source. It will be displayed in the content source page, in error messages, etc.
2. Click on the Scheduled pulldown list and select one of the following: Manually, Periodically, Daily, Weekly or Advanced.
   1. Aspire can automatically schedule content sources to be crawled on a set schedule, such as once a day, several times a week, or periodically (every N minutes or hours).For the purposes of this tutorial, you may want to select Manually and then set up a regular crawling schedule later.
3. Click on the Action pulldown list to select one of the following: Start, Stop, Pause, or Resume.
   1. This is the action that will be performed for that specific schedule.
4. Click on the Crawl pulldown list and select one of the following: Full, Real Time, or Cache Groups.
   1. This will be the type of crawl to execute for that specific schedule.
      

After selecting a Scheduled, specify the details, if applicable:

• Manually: No additional options.
• Periodically: Specify the "Run every:" options by entering the number of "hours" and "minutes."
• Daily: Specify the "Start time:" by clicking on the hours and minutes drop-down lists and selecting options.
• Weekly: Specify the "Start time:" by clicking on the hours and minutes drop-down lists and selecting options, then clicking on the day checkboxes to specify days of the week to run the crawl.
• Advanced: Enter a custom CRON Expression (e.g. 0 0 0 ? * *)

Step 2b. Specify the connector information

In the "Connector" tab, specify the connection information to crawl the SQL

1. Endpoint: The URI from the Azure Connection String Configuration tab.
2. Key: One of the key from the Azure Connection String Configuration tab.
3. Crawl all databases/collections in the server
4. Crawl Specific databases/containers:

• 1. All containers per database: Need to write the database or databases to want crawl the containers inside.
  2. Specific database and container: Is more accurate because you can decide the container and the database, however the database and the container need to be associated, in other words, the container has to be inside the database.

1. Limit extracted rows: Enable fields to limit how many rows are selected from the table.
2. Limit: Number of rows to be selected.
3. Perform sampling: This option means that the retrieved records will be picked randomly. If check this option consider that the performance could be affected when querying large tables.
4. Offset: Number of rows to be skip for the sampling.

Step 2c. Specify workflow information

In the "Workflow" tab, specify the workflow steps for the jobs that come out of the crawl. Drag and drop rules to determine which steps should an item follow after being crawled. This rules could be where to publish the document or transformations needed on the data before sending it to a search engine. See Workflow for more information.

1. For the purpose of this tutorial, drag and drop the Publish To File rule found under the Publishers tab to the onPublish Workflow tree.
   1. Specify a Name and Description for the Publisher.
   2. Click Add.

After completing this steps click on the Save then Done and you'll be sent back to the Home Page.