Query Business Data from Uniconta ERP with OpenAI Chatbot via Peliqan

How it works

This template is an end-to-end demo of an in-house AI agent that can answer a wide range of questions by retrieving information from the Uniconta ERP system. For example users can ask questions related to products, stock, accounting or any other type of information contained in Uniconta.

Peliqan.io is used as a "cache" of all Uniconta data. Peliqan uses one-click ELT to sync all data from Uniconta to the built-in data warehouse, allowing for fast & accurate queries. The AI agent uses Text-to-SQL to answer questions.

Text-to-SQL is performed via the Peliqan node, added as a tool to the AI Agent. The question of the user - in natural language - is converted to an SQL query by the AI Agent. The query is executed by Peliqan.io on the source Uniconta data and the result is interpreted by the AI Agent.

Preconditions

• You signed up for a Peliqan.io free trial account
• You have a Uniconta ERP system

Set up steps

• Sign up for a free trial on peliqan.io
• Add Uniconta as a connection in Peliqan (using an API key from Uniconta)
• Copy your Peliqan API key (in Peliqan go to Settings > API key) and use it in n8n to add a Peliqan connection
• Select your data warehouse in the Peliqan node "Execute an SQL query via Peliqan" in the drop-down field "Data warehouse name or id"
• Optional: run the template script in Peliqan that outputs your specific Uniconta datamodel (tables & columns). Copy your datamodel and paste it in the System Message of the AI Agent (replace the standard Uniconta model already present in this workflow)

Visit peliqan.io/n8n for more information.
Need help ? Contact Peliqan at support@peliqan.io

Disclaimer: This template contains a community node and therefore only works for n8n self-hosted users.