AWS Opensearch Connectivity with On Prem Informatica

AWS Opensearch 2.7
Latest JDBC driver

Describe the issue:

We are using Informatica DIE on premise to connect to AWS Opensearch cluster within VPC. Connection is successful , however we are not able to see the indexes as objects. Using latest Opensearch JDBC driver and correct URL configuration.

Configuration:

Relevant Logs or Screenshots:

This sounds like it’s related to [FEATURE] BI tools compliance with complex objects · Issue #1793 · opensearch-project/sql · GitHub. Other BI tools use SELECT * to describe tables, and complex objects don’t return correctly from the JDBC driver to be used in BI tools.