Embeddable AI

Expand all | Collapse all

How can IBM Watson Chatbot work with SQL Server

  • 1.  How can IBM Watson Chatbot work with SQL Server

    Posted Wed September 08, 2021 09:32 AM
    Dear everyone,

    I'm a newcomer with IBM Chatbot and I've faced an issue that I have not found any solution. Could anyone suggest to me some ideas? I appreciate that. I'm developing a simple chatbot as following.
    1. Bot: Hello users. Do you want to register an account to log in?
    2. User: Select Yes
    3. Bot: Please input your username.
    4. User: Input username, e.g. user1
    5. Bot: Please input your password.
    6. User: Input password, e.g. 123456
    7. Bot will insert username and password into a table in SQL Server, e.g. tableName = 'User'

    In Step7, I want to store username and password data into SQL Server. How can I do that?

    Thanks so much,
    Mr Huy

    ------------------------------
    Huy Chenh
    ------------------------------

    #BuildwithWatsonApps
    #EmbeddableAI


  • 2.  RE: How can IBM Watson Chatbot work with SQL Server

    Posted Thu September 09, 2021 09:11 AM
    Mr Huy,  There is an easy way to have a database driven chatbot.  My colleagues have shown this pattern for years.  Here is a git link to one that has worked for me. (GitHub - data-henrik/db2-slack-chatbot: Db2 database actions triggered from Slack and IBM Watson Conversation, based on OpenWhisk / IBM Cloud Functions 
    GitHub remove preview
    GitHub - data-henrik/db2-slack-chatbot: Db2 database actions triggered from Slack and IBM Watson Conversation, based on OpenWhisk / IBM Cloud Functions
    This repository contains code snippets to build a Slack chatbot backed by IBM Watson Conversation. Depending on the dialog, data is fetched from a Db2 database. The Slack chatbot uses the Conversation Connector which is based on IBM Cloud Functions and Cloudant. The IBM Cloud Functions provide a serverless messaging channel between Slack and Watson Conversation.
    View this on GitHub >
    ) Henrik, shows how you can use cloud functions to connect, query, and parse messages between Assistant and a Database.

    Regards,
    Brandon

    ------------------------------
    BRANDON SWINK
    ------------------------------