How to connect to Opensearch 2.18.0 security enabled with only TLS certificates using the Microsoft Power Bi connector and the Opensearch ODBC driver

OpenSearch
,
1

We have installed OpenSearch with the security plugin enabled, and we are connecting to OpenSearch solely with TLS certificates(CN=opensearch…<dns_zone>), no basic authentication is being used. The opensearch setup for TLS is shown below.

clientcert_auth_domain:
description: “Authenticate via SSL client certificates”
http_enabled: true
transport_enabled: true
order: 1
http_authenticator:
type: clientcert
config:
username_attribute: cn #optional, if omitted DN becomes username
challenge: false
authentication_backend:
type: noop

To load bulk data (real-time data), Restapi connects to OpenSearch using tls.crt and tls.key. For instance, when using curl to connect to OpenSearch, use the command below.

curl --insecure --cert /usr/share/opensearch/config/certs/tls.crt --key /usr/share/opensearch/config/certs/tls.key -XGET -H ‘Content-Type: application/json’ “https://opensearch..<dns_zone>/_cat/indices/”

Now our requirement is to create reports/dashboards in Microsoft Power Bi Desktop through opensearch odbc driver and Power Bi Connector. I installed/tried both version (opensearch-sql-odbc-win64-1.4.0.0 and opensearch-sql-odbc-driver-64-bit-1.5.0.0-Windows) but it is not connecting the opensearch with tls configuration.

Steps are followed with below link -

I would like a confirmation that the OpenSearch ODBC driver supports OpenSearch installed with TLS certificates? If so, kindly provide the steps, how to use the Microsoft Power Bi connector to connect to OpenSearch via the OpenSearch ODBC driver. If not, are there any plans for a future release?

Since the problem needs to be fixed immediately, kindly suggest.

Thanks and regards
Rajesh Kumar.