Page tree
Skip to end of metadata
Go to start of metadata

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. 

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. 

A separate log will be generated for the action of the SQL Tool execution.

Please see 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. 

The screenshot below shows how SQL Tool is being configured as a tool before analysis:

8.0.X Documentation: CMS - Content Enrichment tab

Select the log lines that you are interested from the list below


CAST-MS log file

Section of CAST-MS log file dealing with SQL Tool step as shown in the log above. 

Run SQL Tool Generation

INF: 2016-08-09 17:33:02:  Script successfully completed

INF: 2016-08-09 17:33:02:  Task message: No Task message

INF: 2016-08-09 17:33:02:  Log file: C:\Users\JMC~1.CAS\AppData\Local\Temp\CAST\CAST\8.0\45d05b12c701491592c266cf6efa7678\SqlTool-20160809173301.log.txt

INF: 2016-08-09 17:33:02:  ending Task SQL

End Tools Before Analysis 

INF: 2016-08-09 17:33:02:  Task message: No Task message

INF: 2016-08-09 17:33:02:  No associated log file

INF: 2016-08-09 17:33:02:  ending Task Tools before analysis

SQLTool log

SQLTool-<DateTime>.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: 2016-08-09 17:33:02:  [SQL] create table _tmp1 (int1 int); insert into _tmp1 values (1); drop table _tmp1;




  • No labels