Issue when connecting fabric to oracle using pipeline

[SLI]

Hi all 

I have an issue in fabric when I am trying to connect to oracle autonomous using a pipeline 

the goal is to Connect to oracle database , copy data into a lakehouse 

but when we do it i have this message :

Failed to open the Oracle database connection. Network Transport: SSL failure in parsing wallet location Illegal characters in path. ID d’activité: db4fc233-b0d0-456b-95dc-47e3de193990

the gateway that we use works Very good with power bi  (same connection to the same database)

have you an idea about whist i should do?

is there any issue with this kind of connection 

[SLI]

Hello @govind_021 

thank you for your answer 

it is the same answer that i've obtained from copilote 

i need to know if someone has already encountred the same problem

thank you 

[govind_021]

Hi @SLI 

It looks like the issue is related to the wallet location path when trying to connect Fabric to Oracle Autonomous Database via a pipeline. Here are a few things you can check and try:

1. Verify Wallet File Path:

   • The error message mentions "Illegal characters in path", which suggests that the wallet file path might contain special characters or spaces.
   • Try placing the wallet in a simple directory path (e.g., C:\Oracle\Wallet) and update the connection settings accordingly.

2. Check SSL Configuration:

   • Since the error mentions "SSL failure in parsing wallet location", ensure that the wallet files (tnsnames.ora, sqlnet.ora, cwallet.sso, etc.) are correctly configured.
   • Confirm that the wallet file is correctly extracted and not nested inside another folder.

3. Verify Gateway Configuration:

   • You mentioned that the same gateway works fine with Power BI. However, Fabric’s pipeline may have different requirements.
   • Ensure that the gateway has access to the wallet file path and is correctly set up for Fabric.

4. Check for Special Characters in File Path:

   • If your wallet location contains characters like #, @, or spaces, try renaming the folder or moving the wallet to a simpler location.

5. Try Using the Full UNC Path:

   • If you're using a shared network folder, try using the full UNC path instead of a mapped drive (e.g., \\ServerName\Folder\Wallet instead of Z:\Wallet).

6. Test with SQL Developer or SQL*Plus:

   • Try connecting to the database with SQL Developer or SQL*Plus using the same wallet. If it fails, the issue might be with the wallet itself.

7. Check Fabric’s Oracle Connector Documentation:

   • Microsoft Fabric might have specific requirements for Oracle connections that differ from Power BI. Checking official documentation might help identify any missing steps.
     
     Best Regards
     Govind Sapkade ( Microsoft Certified Data Analyst , PL 300 Certified , MS Fabric Enthusiast)
     Let's Connect
     Linkdin - www.linkedin.com/in/govind-sapkade-845104225
     Youtube - http://www.youtube.com/@govind_dataanalyst