SQL Tool is a sub task that is optional and will only be run when configured in the analysis. It can be configured to run either before or after an analysis, or after a module generation.
It is triggered to run when the user adds the specific action for this in either the 'Tools before analysis' or the 'Tools after analysis' sections in the Content Enrichment tab of the application configuration, or in the 'Tools after module generation' section in the Module tab of the application configuration.
A separate log will be generated for the action of the SQL Tool execution.
The screenshot below shows how SQL Tool can be configured as a tool before analysis
Example screenshot showing how the Tools after Module Generation is configured in CAST-MS:
Check the below documentation and example screenshots for more information on this step and an example of where it is located in the CAST Management Studio.
8.3.X Documentation: CMS - Modules tab
8.3.X Documentation: CMS - Content Enrichment tab
Select the log lines that you are interested from the list below
CAST-MS-<date>-<time>.log.txt log file
Section of CAST-MS log file dealing with SQL Tool step as shown in the log above.
Run SQL Tool Generation
INF: 2018-10-01 16:04:36: starting Task Run Tool
INF: 2018-10-01 16:04:36: starting Task sql1
INF: 2018-10-01 16:04:39: Script successfully completed
INF: 2018-10-01 16:04:39: Task message: No Task message
INF: 2018-10-01 16:04:39: Log file: C:\ProgramData\CAST\CAST\Logs\c\Run_Tool_2166\sql1-20181001-160428.log.txt
INF: 2018-10-01 16:04:39: ending Task sql1
INF: 2018-10-01 16:04:39: Task message: No Task message
INF: 2018-10-01 16:04:39: No associated log file
INF: 2018-10-01 16:04:39: ending Task Run Tool
<sql job name>-<Date>-<Time>.log.txt log file
Example screenshot showing the SQL Tool being executed:
Sample results of a SQL Tool log (results will vary depending on the contents of the SQL being run):
Run SQL Tool Results
This logline contains the SQL Query
INF: 2018-10-01 16:20:13: [SQL] set search_path=test830_local;
select count(*) from keys;