The developerWorks Connections Platform is now in read-only mode and content is only available for viewing. No new wiki pages, posts, or messages may be added. Please see our FAQ for more information. The developerWorks Connections platform will officially shut down on March 31, 2020 and content will no longer be available. More details available on our FAQ. (Read in Japanese.)
This item takes an alternate approach and leverages Microsoft's Power BI capabilities to retrieve data from CRM Dynamics 365
To protect the actual data I have entered some sample text entries.
The results are shown in the screenshot below.
Since I am more comfortable in Java than with the Power BI Advanced Query editor,
I created a proxy REST endpoint that translates the IBM Watson Explorer Analysis results into JSON that is easily consumed in PowerBI.
This results in the following function (Advanced Editor view)
Now we have all the steps for the process
Get data from Microsoft CRM Dynamics (or any other data source that can be accessed from Power BI)
Identify the (text)column that you want to analyze
Create a new column that
takes the content of the column from step 2
passes the text to the function
stores the result in this new column
And that is how the 'WEX Enrichtment' column in the second screenshot is filled.
So when you have your data in one of data sources (see screenshot below ) that is supported by Power BI and not (yet) by Watson Explorer Content Analytics, you may consider this approach before you start building your own custom crawler.
If you have worked with PowerBI before, you probably recognize that this exercise is a variation on this tutorial: