Create a new SQL Server database.
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_
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.
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.
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".
Update the Connection in the new "Product - Category - Mapping" job to use the connection created in step 4.
Make sure your WIS is running and your SiteConnections.config has the correct value for URL.
Then add the IntegrationConnectionName from Step 4 and stop/start your WIS service.
Schedule the job and view the logs to confirm success.
Link to Files: <https://insitesoftwaresolutions.box.com/v/CongifIntJobPrdCatMap>