3013431 - Data flow building disabled with Oracle Connection in DSP

Creating "Oracle" connection for Data Flows in DSP (SAP Datasphere) and validate it, receive pop-up with the following message:

...

- Data flow building disabled.

Data Flows: Cause: Open request could not be performed due to error: Oracle driver could not be found. Please, check the documentation in order to configure the driver. Code:99999

...

SAP Datasphere

1. Open DS Tenant
2. Display "Local Connections"  for your Space in "Space Management"
3. Select the connection type "Oracle" and use "Validate Connection" button
4. Error message is displayed 

Prerequisite for creating connection is missing

For some connection types that support data flows and that connect to a non-SAP source - such as Amazon Redshift or Oracle, you need to upload third-party drivers to SAP Datasphere.

Pre manual steps:

1. Download the corresponding driver from the last column of the table.

2. When uploading the drivers, they are identified by their SHA256-formatted fingerprint. The fingerprint of the driver file name to be uploaded must match the fingerprint. You can verify the fingerprint with the following command:

   • Windows 10: In PowerShell, run the following command:

     Get-Filehash <driver file> -Algorithm SHA256

   • Linux/MacOS: In a unix-compliant shell, run the following command:

     shasum -a 256 <driver file>

Then perform the following steps before creating the first Amazon Redshift, Oracle, or Google BigQuery connection that you want to use for data flows.

1. In the side navigation area, click System -> Configuration -> Data Integration.

2. Go to Third-Party Drivers and choose -> Upload.

3. In the following dialog box, choose Browse to select the driver file from your download location.
   
   
4. Choose Upload.
   
   
5. Choose Sync to synchronize the driver with the underlying component. Wait for about 5 to 10 minutes to finish synchronization before you start creating connections or using data flows with the connection.
   
   

Data flow, Oracle Connection, Oracle, driver, Amazon Redshift, Oracle driver could not be found, third-party drivers , KBA , DS-DI-CON , Connections , How To