Skip to main content
Solved

Connect AI Agent to Oracle database

  • January 16, 2025
  • 5 replies
  • 81 views

Forum|alt.badge.img+1

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?

 

Best answer by Aaron.Gleason

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.

View original
Did this topic help answer your question?

5 replies

Aaron.Gleason
Automation Anywhere Team
Forum|alt.badge.img+10
  • Automation Anywhere Team
  • 541 replies
  • Answer
  • January 16, 2025

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.


Forum|alt.badge.img+1
  • Author
  • Cadet | Tier 2
  • 2 replies
  • January 17, 2025

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.
 


Forum|alt.badge.img+4
  • Cadet | Tier 2
  • 5 replies
  • January 17, 2025
khadeejath.a wrote:

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.


Forum|alt.badge.img+1
  • Author
  • Cadet | Tier 2
  • 2 replies
  • January 17, 2025

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

 


Aaron.Gleason
Automation Anywhere Team
Forum|alt.badge.img+10
  • Automation Anywhere Team
  • 541 replies
  • January 17, 2025

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings