sql icon indicating copy to clipboard operation
sql copied to clipboard

opensearch_sql_odbc.taco cannot be found [BUG]

Open elliotweissberg opened this issue 2 years ago • 6 comments

What is the bug? The connector file opensearch_sql_odbc.taco that is linked in the read me does not seem to exist, and leads to a page not found error.

How can one reproduce the bug? Steps to reproduce the behavior:

  1. Go to 'project home page'
  2. Click on 'Tableau connector'
  3. See error

elliotweissberg avatar May 26 '22 23:05 elliotweissberg

Yes. The connector links should get updated. However, if you're looking for the latest connectors, you can download the 2.0.0 release connectors from: https://github.com/opensearch-project/sql/actions/runs/2392486854

acarbonetto avatar May 26 '22 23:05 acarbonetto

Thanks! I see that the .pkg file is also in the release notes. It would also be immensely useful if there was some kind of link to them from the readMe as well. Currently, the readMe makes reference to the driver package, but does not mention where to find them.

elliotweissberg avatar May 27 '22 14:05 elliotweissberg

@acarbonetto The 2.0.0 release connector for tableau is called opensearch_sql_jdbc.taco, but everything else in the docs seems to recommend using ODBC. Is the tableau connector misnamed, or should I be using JDBC to connect opensearch to tableau?

elliotweissberg avatar May 27 '22 17:05 elliotweissberg

You shouldn't have trouble using the ODBC driver in tableau, but there was an issue creating the connector with the ODBC (I don't know exactly which existing issue is related). So it was created with JDBC. That's all the background that I know of.

acarbonetto avatar May 27 '22 22:05 acarbonetto

this issue is a duplicate of https://github.com/opensearch-project/sql/issues/439

acarbonetto avatar May 27 '22 22:05 acarbonetto

@elliotweissberg sounds like the odbc driver in tableau is giving some people issues (https://github.com/opensearch-project/sql-odbc/issues/23) and this may be an issue. Recommend using the jdbc driver instead, at least for now.

acarbonetto avatar May 27 '22 23:05 acarbonetto

Fixed by opensearch-project/sql#665

Yury-Fridlyand avatar Sep 12 '22 22:09 Yury-Fridlyand