1. Create a new SQL Server database.

2. Run the scripts found in the attached **Category-Product-SQL-Structure-and-Data.xlsx** file at the bottom of this article. They are found on the worksheet tabs of the spreadsheet called:

   • _Create Category Table_

   • _Create Product Table_

   • _Create MapProductsToCategories_

3. Load the data from the **Category-Product-SQL-Structure-and-Data.xlsx** file. The data is found within the following worksheet tabs:

   • _Category data_

   • _Product data_

   • _MapProductsToCategories data_

     📘

     Note

     Make sure your data does not contain any hidden characters, which may come about if data is copied and pasted.

4. Create a new Connection in the Admin Console (AC) of type **SqlServer** and configure it to connect to the new SQL Server database created in Step 1.

5. Use the Import feature in the AC to load the integration job from the **Category-Product-JobDefinition.json** file.  The new job is called "Product - Category - Mapping".

6. Update the Connection in the new "Product - Category - Mapping" job to use the connection created in step 4.

7. Make sure your WIS is running and your SiteConnections.config has the correct value for URL.

8. Then add the IntegrationConnectionName from Step 4 and stop/start your WIS service.

9. Schedule the job and view the logs to confirm success.

Link to Files: <https://insitesoftwaresolutions.box.com/v/CongifIntJobPrdCatMap>