This article provides details on configuring an integration job to read the datasets from an SQL Server database, then create Products, create Categories, and map or assign the Products to the Categories. Here are the steps involved:
- 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
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.