[read this post on Mr. Fox SQL blog]
[UPDATED 7 JUN 2020 – ADDED NEW TEXT ANALYTICS v3.0 FEATURES!]
Just last week we had the fantastic opportunity to present at Microsoft Ignite 2017 in the Gold Coast on Azure Cognitive Services – and we had an absolute blast of a time!
I co-presented with Kristina Rumpff who works at Microsoft in the Data Platform team as a Solution Architect. I focused on an overview of the suite of Azure Cognitive Services along with a deep dive into the Text Analytics service, and Krissy focused on the LUIS service coupled together with Azure Bots.
- For those interested – this is our session on Channel 9 (75 mins) – https://channel9.msdn.com/Events/Ignite/Australia-2017/DA321
- We also did an interview for SSW which is here (10 mins) – https://www.youtube.com/watch?v=jILcbJw1nso
- If you just need a refresher on what Cognitive Services is then go here – https://azure.microsoft.com/en-us/services/cognitive-services/
Fast Start to Azure Text Analytics Cognitive API’s
Leading up to, and since, the session I had a few people ask if there is anything pre-canned application wise which can call the Text Analytics API’s which they can just use.
The answer to that is kind of yes…
- Text Analytics MS Docs Ref – https://docs.microsoft.com/en-us/azure/cognitive-services/text-analytics/
- Running Text Analytics in Containers! – https://docs.microsoft.com/en-us/azure/cognitive-services/text-analytics/how-tos/text-analytics-how-to-install-containers
- My previous blog post on embedding the API into SQL 2016 (CLR) – https://mrfoxsql.wordpress.com/2016/09/13/azure-cognitive-services-apis-with-sql-server-2016-clr/
- Build your own pipeline using Azure Logic Apps (which mind you even though its a graphical workflow service you still need to build it!) – https://azure.microsoft.com/en-au/services/logic-apps/
- Luckily this is an excellent blog post showing you how to build your very own Logic App to push text to the Text Analytics API – very cool! – https://gautambiztalkblog.com/2017/01/09/logic-app-to-detect-sentiment-and-extract-key-phrases-from-your-text/
However apart from that I didn’t find anything else out there which people can quickly leverage to do this for them… so I wrote one!
UPDATE: I have since found this app handy myself when I need to quickly process a stack of once-off random text that someone sent to me for some other downstream reporting. (…AND this was a good chance to learn more c# coding!)
And so, lets see the application code in action!
Mr. Fox SQL 