Connecting PowerApps/Flow to Impala.
I am working on an app that retrieves data from imapala and displays on powerapps. I have been able to test connectivity to impala using the cloudera ODBC /Microsoft ODBC connections from my local machine. The local connectivity is established via kerberos.
On the powerapps portal i have used the the Impala connection which is still under preview.
My finding is that the connection doesn't seem to be established via the on-premises data gateway.
Connection 1: When a connection is setup using my credentials with the active directory domain (domain\NetworkID) . The exception message returned is
ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct.
inner exception: ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct.
On inspecting the logs, we can see that traffic does come into the gateway and the logs capture the same exception as shown above.
Connection 2: However when i setup a connection using my credentials as 'User@domain' the exception message is
The 'Driver' property with value '{Simba Impala ODBC Driver}' doesn't correspond to an installed ODBC driver.
inner exception: The 'Driver' property with value '{Simba Impala ODBC Driver}' doesn't correspond to an installed ODBC driver.
On checking the gateway configurations, it appears that the onpremises gateway uses the Simba impala drivers for ODBC.
i was under the impression that the gateway would utilize the cloudera ODBC drivers or the Microsoft ODBC drivers.
I have also tried installing the Simba ODBC drivers and created a DSN on the machine. Yet the error persists.
Since the gateway is already packaged with the simba drivers, i assume that we needn't install the simba drivers separately. i have nevertheless tried this option as well.
Are there any alternate options to connect to an on-premise impala instance.
