Skip to main content

I am trying to connect to a generic database (Oracle database) to access as a knowledge base for my AI Agent. I am trying to connect with the connect string below and it’s not working. 

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=your_host_name_or_ip)(PORT=your_port))(CONNECT_DATA=(SID=your_sid)))

How can I connect to an Oracle database from AI Agent?

 

I think you’re looking for something like this:

https://docs.automationanywhere.com/bundle/enterprise-v2019/page/gen-ai-studio-aa-enterprise-knowledge.html

The AI Agents only connect to LLMs, while the AAI Enterprise Knowledge can connect to databases, documents, folders, etc.


I apologize for the confusion. I want to use an Oracle database as knowledge base for my AI Agent. I wanted to know how I can do this.
 


I apologize for the confusion. I want to use an Oracle database as knowledge base for my AI Agent. I wanted to know how I can do this.
 

As stated by ​@Aaron.Gleason this is not possible (yet?), in the AI Agent FAQ: https://docs.automationanywhere.com/bundle/enterprise-v2019/page/ai-studio-faq.html you can read which public (cloud) providers are supported as of this time.

Please have a look into Automation Anywhere Enterprise Knowledge which provides you with the possibility to create a knowledge base so that your AI based solution uses this knowledge base as their ‘understanding’. This technique is called Retrieval Augmented Generation (RAG).

I'm not quite sure if you can connect to an Oracle database with AA Enterprise Knowledge, but the documentation page linked earlier by ​@Aaron.Gleason states the following:

This content can include document formats such as: PDF, DOCX, HTML, JSON, CSV, TXT, and more, which can be sourced from popular enterprise applications such as Google Drive, Microsoft SharePoint, Confluence, or publicly accessible internet sites.


I want to read data from Oracle tables. Is that not possible yet by the AI Agent? What is the below screenshot for then?

 


That screen shot is AAI Enterprise Knowledge. You cannot connect directly to an Oracle database from an AI agent at this time.


Reply