Publish download links for ODBC and JDBC drivers

[Yury-Fridlyand]

Is your feature request related to a problem? Please describe.
I tried to download ODBC driver and the official website redirects me to this repository. Actually, it contains the source code; the installation package link is still nowhere published.
The same situation with JDBC driver download link.

Describe the solution you'd like
The download links for JDBC and ODBC (x64 and x86) both should be published on the website and on the repo.

Describe alternatives you've considered
It is possible to download installer from GitHub Actions artifacts. This way is extremely unclear and not obvious. It is possible to refer it as a temporary solution only.

Additional context
Once a newer version of drivers would be released, the download links should be updated automatically.

[stockholmux]

Closed by opensearch-project/project-website#635

ODBC/JDBC are now published 🎉

[nicotiendamia]

Hello @stockholmux Kyle, could you please point me to the installation link? I've followed the build instructions and the .msi is nowhere to be found to complete the installation. Please help!!

[forestmvey]

Hello @stockholmux Kyle, could you please point me to the installation link? I've followed the build instructions and the .msi is nowhere to be found to complete the installation. Please help!!

ODBC and JDBC artifacts can be found here: opensearch.org/artifacts

[nicotiendamia]

@forestmvey Kyle thanks for your response! Yeah, i actually navigated some more through the issues and found the link, i downloaded this opensearch-sql-odbc-win64-1.4.0.0.msi.
Now am getting an issue where it says the SQL plugin could not be found and i'm not quite getting how to install it, could you help me with that?

[forestmvey]

@nicotiendamia
What are your DSN configuration settings. Note there is currently a bug that if you need an SSL connection you need to use https:// prefix in your host parameter.

Related: github_issue-280

[nicotiendamia]

@forestmvey
Yes, i saw that issue and indeed we need SSL, so i prefixed like you say. Even doing that i got the issue when testing the connection.
My use case is to connect via Tableau and the ODBC, to AWS. But where can i find this SQL plugin, being that im not using OpenSearch locally i just want to be able to use the ODBC to connect to AWS via Tableau, to generate Vizes. Could you shed some light into this plugin issue? Thanks for your help, its much appreciated!

[forestmvey]

@nicotiendamia
For Tableau you will need to install the .tdc file from the installed ODBC directory. Follow installation instructions for using tdc file in tableau here: odbc_customize
With the tdc file installed you should be able to make a connection to AWS via ODBC driver by going to
To a Server -> More... -> Other Databases(ODBC)
That is how to connect on mac so I would think windows would be similar.

[nicotiendamia]

@forestmvey Yes i did that too, i've been with this issues since Monday, so i followed every doc i found, but still geting this issue about the SQL Plugin. WHere can i find this? Or you would say that isn't really the issue and the error message is confusing me?

[joshuali925]

@nicotiendamia docs are in this directory: https://github.com/opensearch-project/sql/tree/main/sql-odbc/docs/user

ODBC driver says SQL plugin is not available if SQL plugin is not installed, or if connection is not successful (which can be confusing). Are you able to connect to your SQL endpoint using curl?

e.g. curl -k -X POST "https://user:pass@ip:port/_plugins/_sql" -H 'Content-Type: application/json' -d'{"query": "show tables like %"}'