Skip to main content

Notifications

Copilot Studio - General
Suggested answer

Oracle Sql as Knowledge Source

(0) ShareShare
ReportReport
Posted on by 2
Hello every one,
 
I am trying to connect CoPilot studio to Oracle On-Premise database as a Knowledge source. I've made the connection in Admin Center under Search & Intelligence - Data sources and were able to indexed my data.
However, copilot studio cannot able to retrieve the results. I have given every one access to my connection. I am using trial license for CoPilot Studio. I'm not sure what i am missing here.
Please any help highly appreciated
 
 
Thank you
Faris
Categories:
  • Artur Stepniak Profile Picture
    Artur Stepniak 1,352 on at
    Oracle Sql as Knowledge Source
    Hello Faris,
     
    I really understand this and I'm also not happy with it. But that's how it goes now - they're pushing everything to prod. MS states that preview features aren't meant for production, so they couldn't work and we may not know why, because we don't have the access to the codebase. :-)
     
    Best regards,
     
    Artur Stepniak
    Interested in GenAI? Visit my site!
  • SPCloudguy Profile Picture
    SPCloudguy 75 on at
    Oracle Sql as Knowledge Source
    Hi Faris,
     
    I don't have any experience with the Oracle on prem connector that I can share.
     
    However I did have similar issues with Dataverse tables and initially got terrible results. I re-read documentation and setup glossary definitions correctly and things went from not finding anything to answering questions with a high degree of accuracy very quickly, so if there's config options similar to glossary definitions it may be worth spending time there.
  • Suggested answer
    Fف-19010550-0 Profile Picture
    Fف-19010550-0 2 on at
    Oracle Sql as Knowledge Source
    Hello Artur,
     
    Thank you for your suggestion really appreciate that.
    However, I just have a concern that if they launched a preview feature, then it should work up to certain extent at least for testing purposes. In my case, CoPilot studio is not giving any information, no results are found. So, I'm not sure if it is because of preview version or there is something missed in the configuration.
     
    Any articles or URL highly appreciated for On-Premises connectivity with Oracle DB in CoPilot Studio as a knowledge source
     
    Thank you,
    Faris
  • Suggested answer
    Artur Stepniak Profile Picture
    Artur Stepniak 1,352 on at
    Oracle Sql as Knowledge Source
    Hello Faris,
     
    it's still a preview feature (check out what preview is: https://copilottoday.com/what-is-a-preview-feature-in-microsoft-products/). I really suggest you to just wait for it to be stable, probably they just didn't end it yet.
    However you can test it further if you like, but it's not suitable for prod.
     
    In case of any other questions, let me know. If the answer helped you, mark it, so that others can benefit from it.
     
    Best regards,
     
    Artur Stepniak
    Interested in GenAI? Visit my site!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard