Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

[QUESTION] Inject MS SQL data into OpenSearch dashboard #240

Closed
PatrickB100 opened this issue Oct 21, 2021 · 4 comments
Closed

[QUESTION] Inject MS SQL data into OpenSearch dashboard #240

PatrickB100 opened this issue Oct 21, 2021 · 4 comments
Labels
question Further information is requested

Comments

@PatrickB100
Copy link

Hi Guys,

I'm sorry for using the bugs function to raise a question but i have no idea how to do it in another way.

Currently i am looking for an option to use data from my current Microsoft SQL server in OpenSearch. Is there a way to handle this?

Apologies and thanks in advance,
Patrick
@CEHENKLE CEHENKLE transferred this issue from opensearch-project/OpenSearch Oct 22, 2021
@anirudha
Copy link
Collaborator

we support SQL ODBC and have it working with powerBI and Excel.
the driver will be released for OpenSearch next week.

@PatrickB100
Copy link
Author

Thanks for your reply, so this means data could be query'd from an microsoft sql to visualize in openSearch?

@chloe-zh
Copy link
Contributor

Hi @PatrickB100 we currently only support the OpenSearch SQL plugin as the SQL server/engine to do the queries, so I'm afraid you would have to migrate your data into OpenSearch first and then you will be able to use our SQL and also PPL (another language in the plugin) to query and visualize.

@chloe-zh chloe-zh added the question Further information is requested label Oct 22, 2021
@penghuo
Copy link
Collaborator

penghuo commented Jan 6, 2022

Feel free to reopen this issue.

@penghuo penghuo closed this as completed Jan 6, 2022
dai-chen pushed a commit that referenced this issue Mar 15, 2023
@matthewryanwells
Added RINT function to V2 engine (#240) (#1433)
7220cfe 
Added RINT to V2 engine, updated documentation, added unit and IT tests

Signed-off-by: Matthew Wells <[email protected]>
opensearch-trigger-bot bot pushed a commit that referenced this issue Mar 15, 2023
@matthewryanwells @github-actions
Added RINT function to V2 engine (#240) (#1433)
0630379 
Added RINT to V2 engine, updated documentation, added unit and IT tests

Signed-off-by: Matthew Wells <[email protected]>
(cherry picked from commit 7220cfe)
Yury-Fridlyand pushed a commit that referenced this issue Mar 15, 2023
@opensearch-trigger-bot @matthewryanwells
Added RINT function to V2 engine (#240) (#1433) (#1439)
014de25 
Added RINT to V2 engine, updated documentation, added unit and IT tests

Signed-off-by: Matthew Wells <[email protected]>
(cherry picked from commit 7220cfe)

Co-authored-by: Matthew Wells <[email protected]>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
question Further information is requested
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
4 participants
@anirudha @penghuo @chloe-zh @PatrickB100