Need help to connect conversation chat bot with external databases (RDBMS).
Is there any way to integrate IBM conversation chat-bot with Facebook,Twitter and other messaging environments without using third party middle-ware solutions like Stamplay,Twilio etc.?
How to consume retrieve and rank Watson service to select or insert records into the external database?
It will take custom app code. Here's a blog post about connecting to cloudant: https://developer.ibm.com/clouddataservices/2016/12/09/chatbot-analytics-watson-conversation-and-cloudant/
If you look in the docs there is a link to botkit. This is open source code to connect that we offer for free that host and own end to end.
I'm not sure retrieve and rank is used that way...but if you give more info on what you're trying to do maybe I can help.
Thanks for your quick response @MitchMason (2728)
I am going through the recipe app to explore more on the first point.
I tried botkit opensource code and It's working perfect.
Here is my POC Requirement: We have to Capture Customer Name, Email, Mobile No and Product and create Lead in back end database like SQL or DB2. Enable End user to get additional details various plans/ products offered by customer. For that we have to create FAQ type chatbok where our FAQ details will be fetched from external database.
So please suggest how could I connect to back end database like SQL or DB2 OR Is there any way to consume web-services in chatbots?
For the FAQ type bot I would recommend something like RnR or Discovery. And basically you will use Conversation to collect the details you need, then when you want to just get an answer from your knowledge base youll query discovery/rnr.
I will caution that the results from rnr/discovery may look a bit awkward in something like facebook/slack.