Issues Connecting to Oracle ODBC Driver

[aslam24196]

Hello Qlik Community,

We are migrating to SaaS and I am trying to establish a Oracle ODBC connection through Direct Access. While the test connection is successful on both the ODBC DSN on the Data Gateway server and the Qlik SaaS ODBC Connector, I am facing an error when trying to Load the Data.

I am receiving the following error:

The Same connection works on the Qlik Sense OnPrem and Qlikview. I anot sure where it is going wrong. Have someone faced the same issue and fixed this?

The ODBC Driver is Oracle in instantclient_21_12

Thanks in Advance,

Aslam

[Scotchy]

Points to consider...

The error message you are encountering, "ODBC Wrapper: Unable to execute SQLTables: [Oracle][ODBC]Optional feature not implemented," typically indicates that the ODBC driver you are using does not support a feature that Qlik Sense SaaS is attempting to use.

Here are a few steps you can take to troubleshoot and potentially resolve this issue:

1. Driver Compatibility: Ensure that the Oracle Instant Client ODBC driver version you are using is compatible with the Qlik Sense SaaS environment. While it may work on Qlik Sense On-Premises and QlikView, SaaS environments can have different requirements or compatibility standards.

2. Driver Configuration: Verify that the ODBC DSN (Data Source Name) settings are correctly configured. Differences between the On-Premises and SaaS environments could affect how the driver behaves.

3. Qlik Sense SaaS Limitations: There may be limitations or differences in how Qlik Sense SaaS handles ODBC connections compared to On-Premises versions. Check the Qlik Sense SaaS documentation for any noted differences.

4. Permissions and Access: Ensure that the necessary permissions and network access are configured correctly for SaaS to communicate with your Oracle database.

5. Alternative Methods: As a workaround, you might try using a different method to connect to the Oracle database, such as through REST API or Qlik's built-in Oracle connectors if available.

6. Qlik Community and Support: Engage with the Qlik community or reach out to Qlik support for guidance. Other users may have faced similar issues and could offer a solution.

7. Consult Documentation: Review the official documentation from Oracle for the Instant Client and from Qlik for any recommended settings or known issues with Oracle connections.

8. Update Drivers: If you are not on the latest version of the Oracle Instant Client ODBC driver, consider upgrading to see if the issue persists with a newer version.

9. Log Analysis: Examine the logs for both the Data Gateway server and Qlik SaaS to gain more insight into the error. The logs may provide additional details that can help identify the root cause.

10. Database Settings: Some database settings on the Oracle side could prevent certain features from being used through ODBC. It's worth checking the Oracle database configuration to ensure it's set up to allow the required ODBC operations.

If you've gone through these steps and the problem persists, it may be necessary to involve your database administrator or a Qlik specialist to further diagnose and resolve the issue.

[Ken_T]

could you link to the pages that give the details for what drivers are compatible? anyone know where that is?