Oracle on-premise database not connecting to Purview

Praneetha Varigonda 0 Reputation points
2023-01-28T00:08:56.92+00:00

Hi,

I'm trying to connect on-premise oracle database to Purview but I keep getting the error : Error: (3913) JavaException: Java cannot be found. Please install and add to Path. I installed Java and gave the path: C:\Users\myusername\Documents\java\jar . Can someone help identify the issue ? The integration runtime is running on the machine as well. We have another SQL on-prem db using the same SHIR and connecting to Purview just fine.

Thanks

User's image

Microsoft Purview
Microsoft Purview
A Microsoft data governance service that helps manage and govern on-premises, multicloud, and software-as-a-service data. Previously known as Azure Purview.
917 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Ortiz Ocio Leire TEF-D 20 Reputation points
    2023-03-02T12:35:13.9+00:00

    Hi,

    You need to install JDK, Oracle jdbc Drivers, and Visual C++ Redistributable, first in the machine where the IR runs.

    If this has been already installed, I'd recommend to place the jdbc in a folder outside the C:\Users.... folder

    You can also try to test from the Integration Runtime, in Diagnostics, if it connects to the oracle DB.

    I hope it helps!

    0 comments