Task 3: Index database data

1. On the azureaixxxx blade, in the navigation pane, select Overview, and then select Import data.

2. On the Import data blade, in the Data Source dropdown list, select Azure SQL Database.

3. In the Data source name field, enter datasourcexxxx.

4. Under Connection strings, select Choose an existing connection.

5. On the SQL Database window, select /DB01

6. In the Password field enter the SQL administrator password QWERTqwert12345 and then select Test connection.

7. In the Table/View dropdown list, select [Products] and then select Next.

8. On the Add cognitive skills tab, select Skip to: Customized target index.

9. On the Customize target index tab, in the Key dropdown list, select ProductName.

10. In the table, select the following checkboxes, and then select Next.
    • ProductName -Retrievable, Filterable, Searchable
    • Description -Retrievable, Filterable, Searchable
    • Price -Retrievable, Filterable, Searchable - CategoryID -Retrievable, Filterable

11. On the Create an indexer tab, verify Once is selected.

12. Expand Advanced options, select the Base-64 Encode Keys checkbox, and then select Submit.