Integrating Jiwa ERP with SQL and AWS bedrock

[amyacker]

Hi,

I'm working on a project involving Jiwa ERP, Microsoft SQL Server, and AWS Bedrock, and I'd appreciate some guidance from anyone who has implemented something similar.

Jiwa ERP stores product, inventory, pricing, and customer related information in SQL Server. We'd like to use AWS Bedrock to build an AI assistant that can answer natural language questions such as: "Which products are currently in stock?" "Show me construction equipment under SAR 5,000." "Which suppliers have delivered this item in the past six months?" "Recommend alternative products if an item is out of stock."

My questions are:

What is the recommended architecture for securely exposing Jiwa SQL data to AWS Bedrock without allowing the model direct database access?
Are you using a Retrieval-Augmented Generation (RAG) approach, or are you generating SQL queries from user prompts?
How do you keep AI responses synchronized with frequently changing inventory and pricing data?
Have you encountered performance or security challenges when connecting SQL Server data with Bedrock?
What techniques have worked well for handling permissions so users only see data they are authorized to access?

If anyone has experience integrating Jiwa ERP using AWS Bedrock with SQL Server in an ERP environment, I would really appreciate hearing about your architecture, lessons learned, or best practices.

Thanks in advance.

[Scott.Pearce]

I don't know about AWS integration, but I can tell you that the next v8 release has inbuilt AI chat. The AI Chat leverages an MCP Server, which exposes certain tools for the AI model to call in answering questions about the Jiwa data including inventory items, stock levels, customer, suppliers, sales orders, etc. The MCP Server uses the Jiwa REST API to interface with the data. You point Jiwa to a hosted AI model of your choice (e.g. Azure OpenAI models).

MCP Server: https://github.com/JiwaFinancials/JiwaMCPServer
AI Chat: https://jiwa.atlassian.net/wiki/spaces/J8UG/pages/1555955718/AI+Chat
Jiwa REST API: https://jiwa.atlassian.net/wiki/spaces/J8UG/pages/882967023/REST+API

Jiwa v8.0.62.0 (which is available now) has some experimental AI Chat functionality, but significant changes and improvements will be part of the Jiwa v8.0.63.0 release.

Perhaps you could look at the MCP Server GitHub repository for some architectural ideas? AI Chat / Model -> MCP Server Tooling -> Jiwa REST API.

[Scott.Pearce]

Oh, I should add - the Jiwa MCP Server has a plugin framework so you can extend it's tooling as you see fit. Again, check the GitHub repository for more information and a sample plugin project.