>-
1 min
- 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.