This repository was archived by the owner on Mar 31, 2021. It is now read-only.
BranchesTags

Latest commit

History

316 Commits

Folders and files

NameName
Last commit message
Last commit date
.github/workflows
.github/workflows
docs
docs
libraries
libraries
release-notes
release-notes
src
src
.clang-format
.clang-format
.gitignore
.gitignore
BUILD_INSTRUCTIONS.md
BUILD_INSTRUCTIONS.md
CODE_OF_CONDUCT.md
CODE_OF_CONDUCT.md
CONTRIBUTING.md
CONTRIBUTING.md
LICENSE
LICENSE
NOTICE
NOTICE
README.md
README.md
THIRD-PARTY
THIRD-PARTY
aws_sdk_cpp_setup.ps1
aws_sdk_cpp_setup.ps1
aws_sdk_cpp_setup.sh
aws_sdk_cpp_setup.sh
build_win_debug32.ps1
build_win_debug32.ps1
build_win_debug64.ps1
build_win_debug64.ps1
build_win_release32.ps1
build_win_release32.ps1
build_win_release64.ps1
build_win_release64.ps1
opendistro-elasticsearch-odbc.release-notes.md
opendistro-elasticsearch-odbc.release-notes.md
run_cppcheck.bat
run_cppcheck.bat
run_cppcheck.sh
run_cppcheck.sh
run_test_runner.bat
run_test_runner.bat
run_test_runner.sh
run_test_runner.sh

Repository files navigation

NOTE: We have merged this repository into Open Distro for Elasticsearch SQL as of 7/9/20. Please visit here for latest updates on SQL ODBC. Thanks.

Open Distro for Elasticsearch ODBC Driver

ElasticsearchODBC is a read-only ODBC driver for Windows and Mac for connecting to Open Distro for Elasticsearch SQL support.

Specifications

The driver is compatible with ODBC 3.51.

Supported Versions

Operating SystemVersionSupported Bitness
WindowsWindows 1032-bit, 64-bit
MacOSCatalina 10.15.4, Mojave 10.14.664-bit

Installing the Driver

You can use the installers generated as part of the most recent release.

Windows

  1. Run the .msi installer to install the Open Distro for Elasticsearch SQL ODBC Driver.

To use the driver with Tableau:

  1. Copy the .tdc file from <driver-install-dir>/resources to <windows-user-dir>/Documents/My Tableau Repository/Datasources.

This will customize the connection from Tableau to Open Distro for Elasticsearch, ensuring that the correct forms of queries are used.

Mac

iODBC Driver Manager should be installed before installing the Open Distro for Elasticsearch SQL ODBC Driver on Mac.

  1. Run the .pkg installer to install the Open Distro for Elasticsearch SQL ODBC Driver.
  2. Configure a Driver and DSN entry for the Open Distro for Elasticsearch SQL ODBC Driver, following the instructions here.

To use the driver with Tableau:

  1. Copy the .tdc file from <driver-install-dir>/resources to <mac-user-dir>/Documents/My Tableau Repository/Datasources.

This will customize the connection from Tableau to Open Distro for Elasticsearch, ensuring that the correct forms of queries are used.

Using the Driver

The driver comes in the form of a library file:

  • Windows: odfesqlodbc.dll
  • Mac: libodfesqlodbc.dylib

If using with ODBC compatible BI tools, refer to the tool documentation on configuring a new ODBC driver. In most cases, you will need to make the tool aware of the location of the driver library file and then use it to setup Open Distro for Elasticsearch database connections.

Connection Strings and Configuring the Driver

A list of options available for configuring driver behaviour is available here.

To setup a connection, the driver uses an ODBC connection string. Connection strings are semicolon-delimited strings specifying the set of options to use for a connection. Typically, a connection string will either:

  1. specify a Data Source Name containing a pre-configured set of options (DSN=xxx;User=xxx;Password=xxx;)
  2. or configure options explicitly using the string (Host=xxx;Port=xxx;LogLevel=ES_DEBUG;...)

Building from source

Building

Please refer to the build instructions for detailed build instructions on your platform. If your PC is already setup to build the library, you can simply invoke cmake using

cmake ./src

From the projects root directory, then build the project using Visual Studio (Windows) or make (Mac).

  • Visual Studio: Open ./global_make_list.sln
  • Make: Run make from the build root.

Testing

NOTE: Some tests in ITODBCConnection will fail if a test DSN (Data Source Name) is not configured on your system. Refer to "Running Tests" in the build instructions for more information on configuring this.

Documentation

Please refer to the documentation for detailed information on installing and configuring Open Distro for Elasticsearch.

Code of Conduct

This project has adopted an Open Source Code of Conduct.

Security issue notifications

If you discover a potential security issue in this project we ask that you notify AWS/Amazon Security via our vulnerability reporting page. Please do not create a public GitHub issue.

Licensing

See the LICENSE file for our project's licensing. We will ask you to confirm the licensing of your contribution.

Copyright

Copyright 2019 Amazon.com, Inc. or its affiliates. All Rights Reserved.

About

Open Distro for Elasticsearch ODBC Driver

opendistro.github.io/

Resources

Readme
Apache-2.0 license

Code of conduct

Code of conduct

Contributing

Contributing

Security policy

Security policy
Activity
Custom properties

Stars

9 stars

Watchers

0 watching

Forks

10 forks
Report repository

Releases

Packages

Contributors

Languages

, 'i'); if (__m === '*' || __re.test(location.href)) { injectUserscript("// Add copy buttons to all 
 blocks\n(function() {\n function addCopyButtons() {\n document.querySelectorAll('pre code').forEach(function(codeBlock) {\n if (codeBlock.parentElement.hasAttribute('data-copy-added')) return;\n codeBlock.parentElement.setAttribute('data-copy-added', 'true');\n \n var btn = document.createElement('button');\n btn.textContent = 'Copy';\n btn.style.cssText = 'position:absolute;top:4px;right:4px;padding:2px 8px;font-size:11px;background:#4ecdc4;border:none;border-radius:4px;color:#1a1a2e;cursor:pointer;opacity:0.7;transition:opacity 0.2s;';\n btn.onmouseover = function() { this.style.opacity = '1'; };\n btn.onmouseout = function() { this.style.opacity = '0.7'; };\n btn.onclick = function() {\n navigator.clipboard.writeText(codeBlock.textContent).then(function() {\n btn.textContent = 'Copied!';\n setTimeout(function() { btn.textContent = 'Copy'; }, 1500);\n });\n };\n codeBlock.parentElement.style.position = 'relative';\n codeBlock.parentElement.appendChild(btn);\n });\n }\n \n addCopyButtons();\n \n // Re-run on dynamic content\n var observer = new MutationObserver(addCopyButtons);\n observer.observe(document.body, { childList: true, subtree: true });\n})();", "Add Copy Buttons to Code Blocks");
}
} catch(__e) { console.warn('[Userscript:Add Copy Buttons to Code Blocks]', __e); }
})();
(function(){
try {
var __m = "github.com";
var __re = new RegExp('^' + "github\\.com" + '

Skip to content

This repository was archived by the owner on Mar 31, 2021. It is now read-only.

BranchesTags
Latest commit
History
316 Commits
Folders and files
NameName
Last commit message
Last commit date
.github/workflows
.github/workflows
docs
docs
libraries
libraries
release-notes
release-notes
src
src
.clang-format
.clang-format
.gitignore
.gitignore
BUILD_INSTRUCTIONS.md
BUILD_INSTRUCTIONS.md
CODE_OF_CONDUCT.md
CODE_OF_CONDUCT.md
CONTRIBUTING.md
CONTRIBUTING.md
LICENSE
LICENSE
NOTICE
NOTICE
README.md
README.md
THIRD-PARTY
THIRD-PARTY
aws_sdk_cpp_setup.ps1
aws_sdk_cpp_setup.ps1
aws_sdk_cpp_setup.sh
aws_sdk_cpp_setup.sh
build_win_debug32.ps1
build_win_debug32.ps1
build_win_debug64.ps1
build_win_debug64.ps1
build_win_release32.ps1
build_win_release32.ps1
build_win_release64.ps1
build_win_release64.ps1
opendistro-elasticsearch-odbc.release-notes.md
opendistro-elasticsearch-odbc.release-notes.md
run_cppcheck.bat
run_cppcheck.bat
run_cppcheck.sh
run_cppcheck.sh
run_test_runner.bat
run_test_runner.bat
run_test_runner.sh
run_test_runner.sh
Repository files navigation
NOTE: We have merged this repository into Open Distro for Elasticsearch SQL as of 7/9/20. Please visit here for latest updates on SQL ODBC. Thanks.
Open Distro for Elasticsearch ODBC Driver
ElasticsearchODBC is a read-only ODBC driver for Windows and Mac for connecting to Open Distro for Elasticsearch SQL support.
Specifications
The driver is compatible with ODBC 3.51.
Supported Versions
Operating SystemVersionSupported Bitness
WindowsWindows 1032-bit, 64-bit
MacOSCatalina 10.15.4, Mojave 10.14.664-bit
Installing the Driver
You can use the installers generated as part of the most recent release.
Windows
  1. Run the .msi installer to install the Open Distro for Elasticsearch SQL ODBC Driver.
To use the driver with Tableau:
  1. Copy the .tdc file from <driver-install-dir>/resources to <windows-user-dir>/Documents/My Tableau Repository/Datasources.
This will customize the connection from Tableau to Open Distro for Elasticsearch, ensuring that the correct forms of queries are used.
Mac
iODBC Driver Manager should be installed before installing the Open Distro for Elasticsearch SQL ODBC Driver on Mac.
  1. Run the .pkg installer to install the Open Distro for Elasticsearch SQL ODBC Driver.
  2. Configure a Driver and DSN entry for the Open Distro for Elasticsearch SQL ODBC Driver, following the instructions here.
To use the driver with Tableau:
  1. Copy the .tdc file from <driver-install-dir>/resources to <mac-user-dir>/Documents/My Tableau Repository/Datasources.
This will customize the connection from Tableau to Open Distro for Elasticsearch, ensuring that the correct forms of queries are used.
Using the Driver
The driver comes in the form of a library file:
  • Windows: odfesqlodbc.dll
  • Mac: libodfesqlodbc.dylib
If using with ODBC compatible BI tools, refer to the tool documentation on configuring a new ODBC driver. In most cases, you will need to make the tool aware of the location of the driver library file and then use it to setup Open Distro for Elasticsearch database connections.
Connection Strings and Configuring the Driver
A list of options available for configuring driver behaviour is available here.
To setup a connection, the driver uses an ODBC connection string. Connection strings are semicolon-delimited strings specifying the set of options to use for a connection. Typically, a connection string will either:
  1. specify a Data Source Name containing a pre-configured set of options (DSN=xxx;User=xxx;Password=xxx;)
  2. or configure options explicitly using the string (Host=xxx;Port=xxx;LogLevel=ES_DEBUG;...)
Building from source
Building
Please refer to the build instructions for detailed build instructions on your platform.
If your PC is already setup to build the library, you can simply invoke cmake using
cmake ./src
From the projects root directory, then build the project using Visual Studio (Windows) or make (Mac).
  • Visual Studio: Open ./global_make_list.sln
  • Make: Run make from the build root.
Testing
NOTE: Some tests in ITODBCConnection will fail if a test DSN (Data Source Name) is not configured on your system. Refer to "Running Tests" in the build instructions for more information on configuring this.
Documentation
Please refer to the documentation for detailed information on installing and configuring Open Distro for Elasticsearch.
Code of Conduct
This project has adopted an Open Source Code of Conduct.
Security issue notifications
If you discover a potential security issue in this project we ask that you notify AWS/Amazon Security via our vulnerability reporting page. Please do not create a public GitHub issue.
Licensing
See the LICENSE file for our project's licensing. We will ask you to confirm the licensing of your contribution.
Copyright
Copyright 2019 Amazon.com, Inc. or its affiliates. All Rights Reserved.
About
Open Distro for Elasticsearch ODBC Driver 
opendistro.github.io/
Resources
Readme
Apache-2.0 license
Code of conduct
Code of conduct
Contributing
Contributing
Security policy
Security policy
Activity
Custom properties
Stars
9 stars
Watchers
0 watching
Forks
10 forks
Report repository
Releases
Packages
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
injectUserscript("// Force GitHub README to respect dark mode\n(function() {\n var style = document.createElement('style');\n style.textContent = '\n .markdown-body {\n color-scheme: dark light;\n }\n .markdown-body pre { background: #161b22 !important; }\n .markdown-body code { background: rgba(110, 118, 129, 0.4) !important; }\n .markdown-body table th, .markdown-body table td { border-color: #30363d !important; }\n .markdown-body img { background: #0d1117; }\n .markdown-body blockquote { border-left-color: #8b949e; }\n .markdown-body hr { border-color: #30363d; }\n ';\n document.head.appendChild(style);\n})();", "GitHub Dark Mode README Fix");
}
} catch(__e) { console.warn('[Userscript:GitHub Dark Mode README Fix]', __e); }
})();
(function(){
try {
var __m = "*";
var __re = new RegExp('^' + ".*" + '

Skip to content

This repository was archived by the owner on Mar 31, 2021. It is now read-only.

BranchesTags
Latest commit
History
316 Commits
Folders and files
NameName
Last commit message
Last commit date
.github/workflows
.github/workflows
docs
docs
libraries
libraries
release-notes
release-notes
src
src
.clang-format
.clang-format
.gitignore
.gitignore
BUILD_INSTRUCTIONS.md
BUILD_INSTRUCTIONS.md
CODE_OF_CONDUCT.md
CODE_OF_CONDUCT.md
CONTRIBUTING.md
CONTRIBUTING.md
LICENSE
LICENSE
NOTICE
NOTICE
README.md
README.md
THIRD-PARTY
THIRD-PARTY
aws_sdk_cpp_setup.ps1
aws_sdk_cpp_setup.ps1
aws_sdk_cpp_setup.sh
aws_sdk_cpp_setup.sh
build_win_debug32.ps1
build_win_debug32.ps1
build_win_debug64.ps1
build_win_debug64.ps1
build_win_release32.ps1
build_win_release32.ps1
build_win_release64.ps1
build_win_release64.ps1
opendistro-elasticsearch-odbc.release-notes.md
opendistro-elasticsearch-odbc.release-notes.md
run_cppcheck.bat
run_cppcheck.bat
run_cppcheck.sh
run_cppcheck.sh
run_test_runner.bat
run_test_runner.bat
run_test_runner.sh
run_test_runner.sh
Repository files navigation
NOTE: We have merged this repository into Open Distro for Elasticsearch SQL as of 7/9/20. Please visit here for latest updates on SQL ODBC. Thanks.
Open Distro for Elasticsearch ODBC Driver
ElasticsearchODBC is a read-only ODBC driver for Windows and Mac for connecting to Open Distro for Elasticsearch SQL support.
Specifications
The driver is compatible with ODBC 3.51.
Supported Versions
Operating SystemVersionSupported Bitness
WindowsWindows 1032-bit, 64-bit
MacOSCatalina 10.15.4, Mojave 10.14.664-bit
Installing the Driver
You can use the installers generated as part of the most recent release.
Windows
  1. Run the .msi installer to install the Open Distro for Elasticsearch SQL ODBC Driver.
To use the driver with Tableau:
  1. Copy the .tdc file from <driver-install-dir>/resources to <windows-user-dir>/Documents/My Tableau Repository/Datasources.
This will customize the connection from Tableau to Open Distro for Elasticsearch, ensuring that the correct forms of queries are used.
Mac
iODBC Driver Manager should be installed before installing the Open Distro for Elasticsearch SQL ODBC Driver on Mac.
  1. Run the .pkg installer to install the Open Distro for Elasticsearch SQL ODBC Driver.
  2. Configure a Driver and DSN entry for the Open Distro for Elasticsearch SQL ODBC Driver, following the instructions here.
To use the driver with Tableau:
  1. Copy the .tdc file from <driver-install-dir>/resources to <mac-user-dir>/Documents/My Tableau Repository/Datasources.
This will customize the connection from Tableau to Open Distro for Elasticsearch, ensuring that the correct forms of queries are used.
Using the Driver
The driver comes in the form of a library file:
  • Windows: odfesqlodbc.dll
  • Mac: libodfesqlodbc.dylib
If using with ODBC compatible BI tools, refer to the tool documentation on configuring a new ODBC driver. In most cases, you will need to make the tool aware of the location of the driver library file and then use it to setup Open Distro for Elasticsearch database connections.
Connection Strings and Configuring the Driver
A list of options available for configuring driver behaviour is available here.
To setup a connection, the driver uses an ODBC connection string. Connection strings are semicolon-delimited strings specifying the set of options to use for a connection. Typically, a connection string will either:
  1. specify a Data Source Name containing a pre-configured set of options (DSN=xxx;User=xxx;Password=xxx;)
  2. or configure options explicitly using the string (Host=xxx;Port=xxx;LogLevel=ES_DEBUG;...)
Building from source
Building
Please refer to the build instructions for detailed build instructions on your platform.
If your PC is already setup to build the library, you can simply invoke cmake using
cmake ./src
From the projects root directory, then build the project using Visual Studio (Windows) or make (Mac).
  • Visual Studio: Open ./global_make_list.sln
  • Make: Run make from the build root.
Testing
NOTE: Some tests in ITODBCConnection will fail if a test DSN (Data Source Name) is not configured on your system. Refer to "Running Tests" in the build instructions for more information on configuring this.
Documentation
Please refer to the documentation for detailed information on installing and configuring Open Distro for Elasticsearch.
Code of Conduct
This project has adopted an Open Source Code of Conduct.
Security issue notifications
If you discover a potential security issue in this project we ask that you notify AWS/Amazon Security via our vulnerability reporting page. Please do not create a public GitHub issue.
Licensing
See the LICENSE file for our project's licensing. We will ask you to confirm the licensing of your contribution.
Copyright
Copyright 2019 Amazon.com, Inc. or its affiliates. All Rights Reserved.
About
Open Distro for Elasticsearch ODBC Driver 
opendistro.github.io/
Resources
Readme
Apache-2.0 license
Code of conduct
Code of conduct
Contributing
Contributing
Security policy
Security policy
Activity
Custom properties
Stars
9 stars
Watchers
0 watching
Forks
10 forks
Report repository
Releases
Packages
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
injectUserscript("// Highlight search terms from Google/DuckDuckGo/Bing referrer\n(function() {\n var ref = document.referrer;\n var terms = [];\n \n if (ref.includes('google.com') || ref.includes('duckduckgo.com') || ref.includes('bing.com')) {\n var url = new URL(ref);\n var q = url.searchParams.get('q') || url.searchParams.get('p');\n if (q) {\n terms = q.split(/\\s+/).filter(function(t) { return t.length > 2; });\n }\n }\n \n if (terms.length === 0) return;\n \n var style = document.createElement('style');\n style.textContent = '.userscript-highlight { background: #fbbf24; color: #1a1a2e; padding: 1px 3px; border-radius: 2px; }';\n document.head.appendChild(style);\n \n function highlight(node) {\n if (node.nodeType === 3) { // text node\n var text = node.textContent;\n var found = false;\n terms.forEach(function(term) {\n var regex = new RegExp('(' + term.replace(/[.*+?^${}()|[\\]\\\\]/g, '\\\\') + ')', 'gi');\n if (regex.test(text)) {\n found = true;\n var frag = document.createDocumentFragment();\n var parts = text.split(regex);\n parts.forEach(function(part, i) {\n if (i % 2 === 0) {\n frag.appendChild(document.createTextNode(part));\n } else {\n var span = document.createElement('span');\n span.className = 'userscript-highlight';\n span.textContent = part;\n frag.appendChild(span);\n }\n });\n node.parentNode.replaceChild(frag, node);\n }\n });\n } else if (node.nodeType === 1 && node.childNodes) { // element\n var skipTags = ['SCRIPT', 'STYLE', 'NOSCRIPT', 'TEXTAREA', 'INPUT', 'SELECT'];\n if (!skipTags.includes(node.tagName)) {\n Array.from(node.childNodes).forEach(highlight);\n }\n }\n }\n \n highlight(document.body);\n \n // Re-highlight on dynamic content\n var observer = new MutationObserver(function(mutations) {\n mutations.forEach(function(m) {\n m.addedNodes.forEach(function(node) {\n if (node.nodeType === 1 || node.nodeType === 3) highlight(node);\n });\n });\n });\n observer.observe(document.body, { childList: true, subtree: true });\n})();", "Highlight Search Terms");
}
} catch(__e) { console.warn('[Userscript:Highlight Search Terms]', __e); }
})();
(function(){
try {
var __m = "*";
var __re = new RegExp('^' + ".*" + '

Skip to content

This repository was archived by the owner on Mar 31, 2021. It is now read-only.

BranchesTags
Latest commit
History
316 Commits
Folders and files
NameName
Last commit message
Last commit date
.github/workflows
.github/workflows
docs
docs
libraries
libraries
release-notes
release-notes
src
src
.clang-format
.clang-format
.gitignore
.gitignore
BUILD_INSTRUCTIONS.md
BUILD_INSTRUCTIONS.md
CODE_OF_CONDUCT.md
CODE_OF_CONDUCT.md
CONTRIBUTING.md
CONTRIBUTING.md
LICENSE
LICENSE
NOTICE
NOTICE
README.md
README.md
THIRD-PARTY
THIRD-PARTY
aws_sdk_cpp_setup.ps1
aws_sdk_cpp_setup.ps1
aws_sdk_cpp_setup.sh
aws_sdk_cpp_setup.sh
build_win_debug32.ps1
build_win_debug32.ps1
build_win_debug64.ps1
build_win_debug64.ps1
build_win_release32.ps1
build_win_release32.ps1
build_win_release64.ps1
build_win_release64.ps1
opendistro-elasticsearch-odbc.release-notes.md
opendistro-elasticsearch-odbc.release-notes.md
run_cppcheck.bat
run_cppcheck.bat
run_cppcheck.sh
run_cppcheck.sh
run_test_runner.bat
run_test_runner.bat
run_test_runner.sh
run_test_runner.sh
Repository files navigation
NOTE: We have merged this repository into Open Distro for Elasticsearch SQL as of 7/9/20. Please visit here for latest updates on SQL ODBC. Thanks.
Open Distro for Elasticsearch ODBC Driver
ElasticsearchODBC is a read-only ODBC driver for Windows and Mac for connecting to Open Distro for Elasticsearch SQL support.
Specifications
The driver is compatible with ODBC 3.51.
Supported Versions
Operating SystemVersionSupported Bitness
WindowsWindows 1032-bit, 64-bit
MacOSCatalina 10.15.4, Mojave 10.14.664-bit
Installing the Driver
You can use the installers generated as part of the most recent release.
Windows
  1. Run the .msi installer to install the Open Distro for Elasticsearch SQL ODBC Driver.
To use the driver with Tableau:
  1. Copy the .tdc file from <driver-install-dir>/resources to <windows-user-dir>/Documents/My Tableau Repository/Datasources.
This will customize the connection from Tableau to Open Distro for Elasticsearch, ensuring that the correct forms of queries are used.
Mac
iODBC Driver Manager should be installed before installing the Open Distro for Elasticsearch SQL ODBC Driver on Mac.
  1. Run the .pkg installer to install the Open Distro for Elasticsearch SQL ODBC Driver.
  2. Configure a Driver and DSN entry for the Open Distro for Elasticsearch SQL ODBC Driver, following the instructions here.
To use the driver with Tableau:
  1. Copy the .tdc file from <driver-install-dir>/resources to <mac-user-dir>/Documents/My Tableau Repository/Datasources.
This will customize the connection from Tableau to Open Distro for Elasticsearch, ensuring that the correct forms of queries are used.
Using the Driver
The driver comes in the form of a library file:
  • Windows: odfesqlodbc.dll
  • Mac: libodfesqlodbc.dylib
If using with ODBC compatible BI tools, refer to the tool documentation on configuring a new ODBC driver. In most cases, you will need to make the tool aware of the location of the driver library file and then use it to setup Open Distro for Elasticsearch database connections.
Connection Strings and Configuring the Driver
A list of options available for configuring driver behaviour is available here.
To setup a connection, the driver uses an ODBC connection string. Connection strings are semicolon-delimited strings specifying the set of options to use for a connection. Typically, a connection string will either:
  1. specify a Data Source Name containing a pre-configured set of options (DSN=xxx;User=xxx;Password=xxx;)
  2. or configure options explicitly using the string (Host=xxx;Port=xxx;LogLevel=ES_DEBUG;...)
Building from source
Building
Please refer to the build instructions for detailed build instructions on your platform.
If your PC is already setup to build the library, you can simply invoke cmake using
cmake ./src
From the projects root directory, then build the project using Visual Studio (Windows) or make (Mac).
  • Visual Studio: Open ./global_make_list.sln
  • Make: Run make from the build root.
Testing
NOTE: Some tests in ITODBCConnection will fail if a test DSN (Data Source Name) is not configured on your system. Refer to "Running Tests" in the build instructions for more information on configuring this.
Documentation
Please refer to the documentation for detailed information on installing and configuring Open Distro for Elasticsearch.
Code of Conduct
This project has adopted an Open Source Code of Conduct.
Security issue notifications
If you discover a potential security issue in this project we ask that you notify AWS/Amazon Security via our vulnerability reporting page. Please do not create a public GitHub issue.
Licensing
See the LICENSE file for our project's licensing. We will ask you to confirm the licensing of your contribution.
Copyright
Copyright 2019 Amazon.com, Inc. or its affiliates. All Rights Reserved.
About
Open Distro for Elasticsearch ODBC Driver 
opendistro.github.io/
Resources
Readme
Apache-2.0 license
Code of conduct
Code of conduct
Contributing
Contributing
Security policy
Security policy
Activity
Custom properties
Stars
9 stars
Watchers
0 watching
Forks
10 forks
Report repository
Releases
Packages
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
injectUserscript("// Strip utm_, fbclid, gclid, etc. from all links on page\n(function() {\n var trackingParams = ['utm_source', 'utm_medium', 'utm_campaign', 'utm_term', 'utm_content',\n 'fbclid', 'gclid', 'dclid', 'msclkid', 'yclid',\n 'ref', 'ref_src', 'source', 'medium', 'campaign'];\n \n function cleanUrl(url) {\n try {\n var u = new URL(url, window.location.origin);\n var changed = false;\n trackingParams.forEach(function(p) {\n if (u.searchParams.has(p)) {\n u.searchParams.delete(p);\n changed = true;\n }\n });\n return changed ? u.toString() : url;\n } catch (e) {\n return url;\n }\n }\n \n function cleanLinks() {\n document.querySelectorAll('a[href]').forEach(function(a) {\n var clean = cleanUrl(a.href);\n if (clean !== a.href) a.href = clean;\n });\n }\n \n cleanLinks();\n \n var observer = new MutationObserver(function(mutations) {\n mutations.forEach(function(m) {\n m.addedNodes.forEach(function(node) {\n if (node.nodeType === 1) {\n if (node.tagName === 'A') cleanLinks();\n node.querySelectorAll('a[href]').forEach(function(a) {\n var clean = cleanUrl(a.href);\n if (clean !== a.href) a.href = clean;\n });\n }\n });\n });\n });\n observer.observe(document.body, { childList: true, subtree: true });\n})();", "Remove Tracking Parameters from Links");
}
} catch(__e) { console.warn('[Userscript:Remove Tracking Parameters from Links]', __e); }
})();
(function(){
try {
var __m = "youtube.com";
var __re = new RegExp('^' + "youtube\\.com" + '

Skip to content

This repository was archived by the owner on Mar 31, 2021. It is now read-only.

BranchesTags
Latest commit
History
316 Commits
Folders and files
NameName
Last commit message
Last commit date
.github/workflows
.github/workflows
docs
docs
libraries
libraries
release-notes
release-notes
src
src
.clang-format
.clang-format
.gitignore
.gitignore
BUILD_INSTRUCTIONS.md
BUILD_INSTRUCTIONS.md
CODE_OF_CONDUCT.md
CODE_OF_CONDUCT.md
CONTRIBUTING.md
CONTRIBUTING.md
LICENSE
LICENSE
NOTICE
NOTICE
README.md
README.md
THIRD-PARTY
THIRD-PARTY
aws_sdk_cpp_setup.ps1
aws_sdk_cpp_setup.ps1
aws_sdk_cpp_setup.sh
aws_sdk_cpp_setup.sh
build_win_debug32.ps1
build_win_debug32.ps1
build_win_debug64.ps1
build_win_debug64.ps1
build_win_release32.ps1
build_win_release32.ps1
build_win_release64.ps1
build_win_release64.ps1
opendistro-elasticsearch-odbc.release-notes.md
opendistro-elasticsearch-odbc.release-notes.md
run_cppcheck.bat
run_cppcheck.bat
run_cppcheck.sh
run_cppcheck.sh
run_test_runner.bat
run_test_runner.bat
run_test_runner.sh
run_test_runner.sh
Repository files navigation
NOTE: We have merged this repository into Open Distro for Elasticsearch SQL as of 7/9/20. Please visit here for latest updates on SQL ODBC. Thanks.
Open Distro for Elasticsearch ODBC Driver
ElasticsearchODBC is a read-only ODBC driver for Windows and Mac for connecting to Open Distro for Elasticsearch SQL support.
Specifications
The driver is compatible with ODBC 3.51.
Supported Versions
Operating SystemVersionSupported Bitness
WindowsWindows 1032-bit, 64-bit
MacOSCatalina 10.15.4, Mojave 10.14.664-bit
Installing the Driver
You can use the installers generated as part of the most recent release.
Windows
  1. Run the .msi installer to install the Open Distro for Elasticsearch SQL ODBC Driver.
To use the driver with Tableau:
  1. Copy the .tdc file from <driver-install-dir>/resources to <windows-user-dir>/Documents/My Tableau Repository/Datasources.
This will customize the connection from Tableau to Open Distro for Elasticsearch, ensuring that the correct forms of queries are used.
Mac
iODBC Driver Manager should be installed before installing the Open Distro for Elasticsearch SQL ODBC Driver on Mac.
  1. Run the .pkg installer to install the Open Distro for Elasticsearch SQL ODBC Driver.
  2. Configure a Driver and DSN entry for the Open Distro for Elasticsearch SQL ODBC Driver, following the instructions here.
To use the driver with Tableau:
  1. Copy the .tdc file from <driver-install-dir>/resources to <mac-user-dir>/Documents/My Tableau Repository/Datasources.
This will customize the connection from Tableau to Open Distro for Elasticsearch, ensuring that the correct forms of queries are used.
Using the Driver
The driver comes in the form of a library file:
  • Windows: odfesqlodbc.dll
  • Mac: libodfesqlodbc.dylib
If using with ODBC compatible BI tools, refer to the tool documentation on configuring a new ODBC driver. In most cases, you will need to make the tool aware of the location of the driver library file and then use it to setup Open Distro for Elasticsearch database connections.
Connection Strings and Configuring the Driver
A list of options available for configuring driver behaviour is available here.
To setup a connection, the driver uses an ODBC connection string. Connection strings are semicolon-delimited strings specifying the set of options to use for a connection. Typically, a connection string will either:
  1. specify a Data Source Name containing a pre-configured set of options (DSN=xxx;User=xxx;Password=xxx;)
  2. or configure options explicitly using the string (Host=xxx;Port=xxx;LogLevel=ES_DEBUG;...)
Building from source
Building
Please refer to the build instructions for detailed build instructions on your platform.
If your PC is already setup to build the library, you can simply invoke cmake using
cmake ./src
From the projects root directory, then build the project using Visual Studio (Windows) or make (Mac).
  • Visual Studio: Open ./global_make_list.sln
  • Make: Run make from the build root.
Testing
NOTE: Some tests in ITODBCConnection will fail if a test DSN (Data Source Name) is not configured on your system. Refer to "Running Tests" in the build instructions for more information on configuring this.
Documentation
Please refer to the documentation for detailed information on installing and configuring Open Distro for Elasticsearch.
Code of Conduct
This project has adopted an Open Source Code of Conduct.
Security issue notifications
If you discover a potential security issue in this project we ask that you notify AWS/Amazon Security via our vulnerability reporting page. Please do not create a public GitHub issue.
Licensing
See the LICENSE file for our project's licensing. We will ask you to confirm the licensing of your contribution.
Copyright
Copyright 2019 Amazon.com, Inc. or its affiliates. All Rights Reserved.
About
Open Distro for Elasticsearch ODBC Driver 
opendistro.github.io/
Resources
Readme
Apache-2.0 license
Code of conduct
Code of conduct
Contributing
Contributing
Security policy
Security policy
Activity
Custom properties
Stars
9 stars
Watchers
0 watching
Forks
10 forks
Report repository
Releases
Packages
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
injectUserscript("// Auto-enable theater mode on YouTube\n(function() {\n function tryTheater() {\n var btn = document.querySelector('button[aria-label=\"Theater mode\"], ytd-player #player button[title=\"Theater mode\"]');\n if (btn && !btn.classList.contains('activated')) {\n btn.click();\n }\n }\n \n // Try immediately\n tryTheater();\n \n // Try after navigation (SPA)\n var lastUrl = location.href;\n setInterval(function() {\n if (location.href !== lastUrl) {\n lastUrl = location.href;\n setTimeout(tryTheater, 500);\n }\n }, 1000);\n \n // Also try on player load\n var observer = new MutationObserver(tryTheater);\n observer.observe(document.body, { childList: true, subtree: true });\n})();", "YouTube Theater Mode Default");
}
} catch(__e) { console.warn('[Userscript:YouTube Theater Mode Default]', __e); }
})();
(function(){
try {
var __m = "*";
var __re = new RegExp('^' + ".*" + '

Skip to content

This repository was archived by the owner on Mar 31, 2021. It is now read-only.

BranchesTags
Latest commit
History
316 Commits
Folders and files
NameName
Last commit message
Last commit date
.github/workflows
.github/workflows
docs
docs
libraries
libraries
release-notes
release-notes
src
src
.clang-format
.clang-format
.gitignore
.gitignore
BUILD_INSTRUCTIONS.md
BUILD_INSTRUCTIONS.md
CODE_OF_CONDUCT.md
CODE_OF_CONDUCT.md
CONTRIBUTING.md
CONTRIBUTING.md
LICENSE
LICENSE
NOTICE
NOTICE
README.md
README.md
THIRD-PARTY
THIRD-PARTY
aws_sdk_cpp_setup.ps1
aws_sdk_cpp_setup.ps1
aws_sdk_cpp_setup.sh
aws_sdk_cpp_setup.sh
build_win_debug32.ps1
build_win_debug32.ps1
build_win_debug64.ps1
build_win_debug64.ps1
build_win_release32.ps1
build_win_release32.ps1
build_win_release64.ps1
build_win_release64.ps1
opendistro-elasticsearch-odbc.release-notes.md
opendistro-elasticsearch-odbc.release-notes.md
run_cppcheck.bat
run_cppcheck.bat
run_cppcheck.sh
run_cppcheck.sh
run_test_runner.bat
run_test_runner.bat
run_test_runner.sh
run_test_runner.sh
Repository files navigation
NOTE: We have merged this repository into Open Distro for Elasticsearch SQL as of 7/9/20. Please visit here for latest updates on SQL ODBC. Thanks.
Open Distro for Elasticsearch ODBC Driver
ElasticsearchODBC is a read-only ODBC driver for Windows and Mac for connecting to Open Distro for Elasticsearch SQL support.
Specifications
The driver is compatible with ODBC 3.51.
Supported Versions
Operating SystemVersionSupported Bitness
WindowsWindows 1032-bit, 64-bit
MacOSCatalina 10.15.4, Mojave 10.14.664-bit
Installing the Driver
You can use the installers generated as part of the most recent release.
Windows
  1. Run the .msi installer to install the Open Distro for Elasticsearch SQL ODBC Driver.
To use the driver with Tableau:
  1. Copy the .tdc file from <driver-install-dir>/resources to <windows-user-dir>/Documents/My Tableau Repository/Datasources.
This will customize the connection from Tableau to Open Distro for Elasticsearch, ensuring that the correct forms of queries are used.
Mac
iODBC Driver Manager should be installed before installing the Open Distro for Elasticsearch SQL ODBC Driver on Mac.
  1. Run the .pkg installer to install the Open Distro for Elasticsearch SQL ODBC Driver.
  2. Configure a Driver and DSN entry for the Open Distro for Elasticsearch SQL ODBC Driver, following the instructions here.
To use the driver with Tableau:
  1. Copy the .tdc file from <driver-install-dir>/resources to <mac-user-dir>/Documents/My Tableau Repository/Datasources.
This will customize the connection from Tableau to Open Distro for Elasticsearch, ensuring that the correct forms of queries are used.
Using the Driver
The driver comes in the form of a library file:
  • Windows: odfesqlodbc.dll
  • Mac: libodfesqlodbc.dylib
If using with ODBC compatible BI tools, refer to the tool documentation on configuring a new ODBC driver. In most cases, you will need to make the tool aware of the location of the driver library file and then use it to setup Open Distro for Elasticsearch database connections.
Connection Strings and Configuring the Driver
A list of options available for configuring driver behaviour is available here.
To setup a connection, the driver uses an ODBC connection string. Connection strings are semicolon-delimited strings specifying the set of options to use for a connection. Typically, a connection string will either:
  1. specify a Data Source Name containing a pre-configured set of options (DSN=xxx;User=xxx;Password=xxx;)
  2. or configure options explicitly using the string (Host=xxx;Port=xxx;LogLevel=ES_DEBUG;...)
Building from source
Building
Please refer to the build instructions for detailed build instructions on your platform.
If your PC is already setup to build the library, you can simply invoke cmake using
cmake ./src
From the projects root directory, then build the project using Visual Studio (Windows) or make (Mac).
  • Visual Studio: Open ./global_make_list.sln
  • Make: Run make from the build root.
Testing
NOTE: Some tests in ITODBCConnection will fail if a test DSN (Data Source Name) is not configured on your system. Refer to "Running Tests" in the build instructions for more information on configuring this.
Documentation
Please refer to the documentation for detailed information on installing and configuring Open Distro for Elasticsearch.
Code of Conduct
This project has adopted an Open Source Code of Conduct.
Security issue notifications
If you discover a potential security issue in this project we ask that you notify AWS/Amazon Security via our vulnerability reporting page. Please do not create a public GitHub issue.
Licensing
See the LICENSE file for our project's licensing. We will ask you to confirm the licensing of your contribution.
Copyright
Copyright 2019 Amazon.com, Inc. or its affiliates. All Rights Reserved.
About
Open Distro for Elasticsearch ODBC Driver 
opendistro.github.io/
Resources
Readme
Apache-2.0 license
Code of conduct
Code of conduct
Contributing
Contributing
Security policy
Security policy
Activity
Custom properties
Stars
9 stars
Watchers
0 watching
Forks
10 forks
Report repository
Releases
Packages
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
injectUserscript("// Remove or un-stick sticky/fixed headers that block content\n(function() {\n function unstick() {\n document.querySelectorAll('header, nav, [role=\"banner\"], .header, .navbar, .sticky, .fixed-top, [style*=\"position: fixed\"], [style*=\"position:sticky\"]').forEach(function(el) {\n if (el.style.position === 'fixed' || el.style.position === 'sticky' || \n getComputedStyle(el).position === 'fixed' || getComputedStyle(el).position === 'sticky') {\n el.style.position = 'static';\n el.style.top = 'auto';\n el.style.zIndex = 'auto';\n }\n });\n }\n \n unstick();\n \n var observer = new MutationObserver(unstick);\n observer.observe(document.body, { childList: true, subtree: true, attributes: true, attributeFilter: ['style', 'class'] });\n})();", "Kill Sticky Headers");
}
} catch(__e) { console.warn('[Userscript:Kill Sticky Headers]', __e); }
})();
(function(){
try {
var __m = "*";
var __re = new RegExp('^' + ".*" + '

Skip to content

This repository was archived by the owner on Mar 31, 2021. It is now read-only.

BranchesTags
Latest commit
History
316 Commits
Folders and files
NameName
Last commit message
Last commit date
.github/workflows
.github/workflows
docs
docs
libraries
libraries
release-notes
release-notes
src
src
.clang-format
.clang-format
.gitignore
.gitignore
BUILD_INSTRUCTIONS.md
BUILD_INSTRUCTIONS.md
CODE_OF_CONDUCT.md
CODE_OF_CONDUCT.md
CONTRIBUTING.md
CONTRIBUTING.md
LICENSE
LICENSE
NOTICE
NOTICE
README.md
README.md
THIRD-PARTY
THIRD-PARTY
aws_sdk_cpp_setup.ps1
aws_sdk_cpp_setup.ps1
aws_sdk_cpp_setup.sh
aws_sdk_cpp_setup.sh
build_win_debug32.ps1
build_win_debug32.ps1
build_win_debug64.ps1
build_win_debug64.ps1
build_win_release32.ps1
build_win_release32.ps1
build_win_release64.ps1
build_win_release64.ps1
opendistro-elasticsearch-odbc.release-notes.md
opendistro-elasticsearch-odbc.release-notes.md
run_cppcheck.bat
run_cppcheck.bat
run_cppcheck.sh
run_cppcheck.sh
run_test_runner.bat
run_test_runner.bat
run_test_runner.sh
run_test_runner.sh
Repository files navigation
NOTE: We have merged this repository into Open Distro for Elasticsearch SQL as of 7/9/20. Please visit here for latest updates on SQL ODBC. Thanks.
Open Distro for Elasticsearch ODBC Driver
ElasticsearchODBC is a read-only ODBC driver for Windows and Mac for connecting to Open Distro for Elasticsearch SQL support.
Specifications
The driver is compatible with ODBC 3.51.
Supported Versions
Operating SystemVersionSupported Bitness
WindowsWindows 1032-bit, 64-bit
MacOSCatalina 10.15.4, Mojave 10.14.664-bit
Installing the Driver
You can use the installers generated as part of the most recent release.
Windows
  1. Run the .msi installer to install the Open Distro for Elasticsearch SQL ODBC Driver.
To use the driver with Tableau:
  1. Copy the .tdc file from <driver-install-dir>/resources to <windows-user-dir>/Documents/My Tableau Repository/Datasources.
This will customize the connection from Tableau to Open Distro for Elasticsearch, ensuring that the correct forms of queries are used.
Mac
iODBC Driver Manager should be installed before installing the Open Distro for Elasticsearch SQL ODBC Driver on Mac.
  1. Run the .pkg installer to install the Open Distro for Elasticsearch SQL ODBC Driver.
  2. Configure a Driver and DSN entry for the Open Distro for Elasticsearch SQL ODBC Driver, following the instructions here.
To use the driver with Tableau:
  1. Copy the .tdc file from <driver-install-dir>/resources to <mac-user-dir>/Documents/My Tableau Repository/Datasources.
This will customize the connection from Tableau to Open Distro for Elasticsearch, ensuring that the correct forms of queries are used.
Using the Driver
The driver comes in the form of a library file:
  • Windows: odfesqlodbc.dll
  • Mac: libodfesqlodbc.dylib
If using with ODBC compatible BI tools, refer to the tool documentation on configuring a new ODBC driver. In most cases, you will need to make the tool aware of the location of the driver library file and then use it to setup Open Distro for Elasticsearch database connections.
Connection Strings and Configuring the Driver
A list of options available for configuring driver behaviour is available here.
To setup a connection, the driver uses an ODBC connection string. Connection strings are semicolon-delimited strings specifying the set of options to use for a connection. Typically, a connection string will either:
  1. specify a Data Source Name containing a pre-configured set of options (DSN=xxx;User=xxx;Password=xxx;)
  2. or configure options explicitly using the string (Host=xxx;Port=xxx;LogLevel=ES_DEBUG;...)
Building from source
Building
Please refer to the build instructions for detailed build instructions on your platform.
If your PC is already setup to build the library, you can simply invoke cmake using
cmake ./src
From the projects root directory, then build the project using Visual Studio (Windows) or make (Mac).
  • Visual Studio: Open ./global_make_list.sln
  • Make: Run make from the build root.
Testing
NOTE: Some tests in ITODBCConnection will fail if a test DSN (Data Source Name) is not configured on your system. Refer to "Running Tests" in the build instructions for more information on configuring this.
Documentation
Please refer to the documentation for detailed information on installing and configuring Open Distro for Elasticsearch.
Code of Conduct
This project has adopted an Open Source Code of Conduct.
Security issue notifications
If you discover a potential security issue in this project we ask that you notify AWS/Amazon Security via our vulnerability reporting page. Please do not create a public GitHub issue.
Licensing
See the LICENSE file for our project's licensing. We will ask you to confirm the licensing of your contribution.
Copyright
Copyright 2019 Amazon.com, Inc. or its affiliates. All Rights Reserved.
About
Open Distro for Elasticsearch ODBC Driver 
opendistro.github.io/
Resources
Readme
Apache-2.0 license
Code of conduct
Code of conduct
Contributing
Contributing
Security policy
Security policy
Activity
Custom properties
Stars
9 stars
Watchers
0 watching
Forks
10 forks
Report repository
Releases
Packages
Contributors
Languages

, 'i');
if (__m === '*' || __re.test(location.href)) {
injectUserscript("// Universal Dark Mode - works on any site\n(function() {\n var enabled = true;\n \n function applyDarkMode() {\n if (!enabled) return;\n \n // Create style element if it doesn't exist\n var style = document.getElementById('universal-dark-mode-style');\n if (!style) {\n style = document.createElement('style');\n style.id = 'universal-dark-mode-style';\n document.head.appendChild(style);\n }\n \n // Dark mode CSS - inverts colors but preserves images/video\n style.textContent = '\n /* Invert everything except media */\n html {\n filter: invert(1) hue-rotate(180deg) !important;\n background: #1a1a2e !important;\n }\n \n /* Restore images, videos, iframes, canvas */\n img, video, iframe, canvas, svg, picture, [style*=\"background-image\"] {\n filter: invert(1) hue-rotate(180deg) !important;\n }\n \n /* Preserve specific elements that should not be inverted */\n .no-dark-mode, .no-dark-mode *,\n [data-theme=\"light\"], [data-theme=\"light\"],\n .ace_editor, .ace_editor *,\n .CodeMirror, .CodeMirror *,\n .monaco-editor, .monaco-editor *,\n .markdown-body pre, .markdown-body pre *,\n .highlight, .highlight *,\n pre code, pre code * {\n filter: none !important;\n }\n \n /* Fix common UI elements */\n .modal, .popup, .dropdown-menu, .tooltip, .popover {\n filter: invert(1) hue-rotate(180deg) !important;\n background: #2d2d44 !important;\n border-color: #444 !important;\n }\n \n /* Scrollbars */\n ::-webkit-scrollbar { background: #1a1a2e !important; }\n ::-webkit-scrollbar-thumb { background: #444 !important; }\n ::-webkit-scrollbar-thumb:hover { background: #555 !important; }\n \n /* Selection */\n ::selection { background: #4ecdc4 !important; color: #1a1a2e !important; }\n ::-moz-selection { background: #4ecdc4 !important; color: #1a1a2e !important; }\n ';\n }\n \n function removeDarkMode() {\n var style = document.getElementById('universal-dark-mode-style');\n if (style) style.remove();\n }\n \n // Toggle with Alt+Shift+D\n document.addEventListener('keydown', function(e) {\n if (e.altKey && e.shiftKey && e.key === 'D') {\n e.preventDefault();\n enabled = !enabled;\n if (enabled) {\n applyDarkMode();\n console.log('[Universal Dark Mode] Enabled');\n } else {\n removeDarkMode();\n console.log('[Universal Dark Mode] Disabled');\n }\n }\n });\n \n // Apply on load\n applyDarkMode();\n \n // Re-apply on dynamic content\n var observer = new MutationObserver(function(mutations) {\n if (enabled && !document.getElementById('universal-dark-mode-style')) {\n applyDarkMode();\n }\n });\n observer.observe(document.head, { childList: true });\n \n console.log('[Universal Dark Mode] Loaded - Press Alt+Shift+D to toggle');\n})();", "Universal Dark Mode");
}
} catch(__e) { console.warn('[Userscript:Universal Dark Mode]', __e); }
})();
})();

Skip to content

This repository was archived by the owner on Mar 31, 2021. It is now read-only.

BranchesTags
Latest commit
History
316 Commits
Folders and files
NameName
Last commit message
Last commit date
.github/workflows
.github/workflows
docs
docs
libraries
libraries
release-notes
release-notes
src
src
.clang-format
.clang-format
.gitignore
.gitignore
BUILD_INSTRUCTIONS.md
BUILD_INSTRUCTIONS.md
CODE_OF_CONDUCT.md
CODE_OF_CONDUCT.md
CONTRIBUTING.md
CONTRIBUTING.md
LICENSE
LICENSE
NOTICE
NOTICE
README.md
README.md
THIRD-PARTY
THIRD-PARTY
aws_sdk_cpp_setup.ps1
aws_sdk_cpp_setup.ps1
aws_sdk_cpp_setup.sh
aws_sdk_cpp_setup.sh
build_win_debug32.ps1
build_win_debug32.ps1
build_win_debug64.ps1
build_win_debug64.ps1
build_win_release32.ps1
build_win_release32.ps1
build_win_release64.ps1
build_win_release64.ps1
opendistro-elasticsearch-odbc.release-notes.md
opendistro-elasticsearch-odbc.release-notes.md
run_cppcheck.bat
run_cppcheck.bat
run_cppcheck.sh
run_cppcheck.sh
run_test_runner.bat
run_test_runner.bat
run_test_runner.sh
run_test_runner.sh
Repository files navigation
NOTE: We have merged this repository into Open Distro for Elasticsearch SQL as of 7/9/20. Please visit here for latest updates on SQL ODBC. Thanks.
Open Distro for Elasticsearch ODBC Driver
ElasticsearchODBC is a read-only ODBC driver for Windows and Mac for connecting to Open Distro for Elasticsearch SQL support.
Specifications
The driver is compatible with ODBC 3.51.
Supported Versions
Operating SystemVersionSupported Bitness
WindowsWindows 1032-bit, 64-bit
MacOSCatalina 10.15.4, Mojave 10.14.664-bit
Installing the Driver
You can use the installers generated as part of the most recent release.
Windows
  1. Run the .msi installer to install the Open Distro for Elasticsearch SQL ODBC Driver.
To use the driver with Tableau:
  1. Copy the .tdc file from <driver-install-dir>/resources to <windows-user-dir>/Documents/My Tableau Repository/Datasources.
This will customize the connection from Tableau to Open Distro for Elasticsearch, ensuring that the correct forms of queries are used.
Mac
iODBC Driver Manager should be installed before installing the Open Distro for Elasticsearch SQL ODBC Driver on Mac.
  1. Run the .pkg installer to install the Open Distro for Elasticsearch SQL ODBC Driver.
  2. Configure a Driver and DSN entry for the Open Distro for Elasticsearch SQL ODBC Driver, following the instructions here.
To use the driver with Tableau:
  1. Copy the .tdc file from <driver-install-dir>/resources to <mac-user-dir>/Documents/My Tableau Repository/Datasources.
This will customize the connection from Tableau to Open Distro for Elasticsearch, ensuring that the correct forms of queries are used.
Using the Driver
The driver comes in the form of a library file:
  • Windows: odfesqlodbc.dll
  • Mac: libodfesqlodbc.dylib
If using with ODBC compatible BI tools, refer to the tool documentation on configuring a new ODBC driver. In most cases, you will need to make the tool aware of the location of the driver library file and then use it to setup Open Distro for Elasticsearch database connections.
Connection Strings and Configuring the Driver
A list of options available for configuring driver behaviour is available here.
To setup a connection, the driver uses an ODBC connection string. Connection strings are semicolon-delimited strings specifying the set of options to use for a connection. Typically, a connection string will either:
  1. specify a Data Source Name containing a pre-configured set of options (DSN=xxx;User=xxx;Password=xxx;)
  2. or configure options explicitly using the string (Host=xxx;Port=xxx;LogLevel=ES_DEBUG;...)
Building from source
Building
Please refer to the build instructions for detailed build instructions on your platform.
If your PC is already setup to build the library, you can simply invoke cmake using
cmake ./src
From the projects root directory, then build the project using Visual Studio (Windows) or make (Mac).
  • Visual Studio: Open ./global_make_list.sln
  • Make: Run make from the build root.
Testing
NOTE: Some tests in ITODBCConnection will fail if a test DSN (Data Source Name) is not configured on your system. Refer to "Running Tests" in the build instructions for more information on configuring this.
Documentation
Please refer to the documentation for detailed information on installing and configuring Open Distro for Elasticsearch.
Code of Conduct
This project has adopted an Open Source Code of Conduct.
Security issue notifications
If you discover a potential security issue in this project we ask that you notify AWS/Amazon Security via our vulnerability reporting page. Please do not create a public GitHub issue.
Licensing
See the LICENSE file for our project's licensing. We will ask you to confirm the licensing of your contribution.
Copyright
Copyright 2019 Amazon.com, Inc. or its affiliates. All Rights Reserved.
About
Open Distro for Elasticsearch ODBC Driver 
opendistro.github.io/
Resources
Readme
Apache-2.0 license
Code of conduct
Code of conduct
Contributing
Contributing
Security policy
Security policy
Activity
Custom properties
Stars
9 stars
Watchers
0 watching
Forks
10 forks
Report repository
Releases
Packages
Contributors
Languages