IMPORTANT: No additional bug fixes or documentation updates will be released for this version. For the latest information, see the current release documentation.
« Microsoft Power BI Desktop MicroStrategy Desktop »
Elastic Docs ›Elasticsearch Guide [6.6] ›SQL Access ›SQL Client Applications

Microsoft PowerShell

edit

Microsoft PowerShell

edit

This functionality is in technical preview and may be changed or removed in a future release. Elastic will work to fix any issues, but features in technical preview are not subject to the support SLA of official GA features.

You can use the Elasticsearch ODBC driver to access Elasticsearch data from Microsoft PowerShell.

Elastic does not endorse, promote or provide support for this application; for native Elasticsearch integration in this product, please reach out to its vendor.

Prerequisites

edit

Writing a script

edit

While putting the following instructions into a script file is not an absolute requirement, doing so will make it easier to extend and reuse. The following instructions exemplify how to execute a simple SELECT query from an existing index in your Elasticsearch instance, using a DSN configured in advance. Open a new file, select.ps1, and place the following instructions in it:

$connectstring = "DSN=Local Elasticsearch;"
$sql = "SELECT * FROM library"

$conn = New-Object System.Data.Odbc.OdbcConnection($connectstring)
$conn.open()
$cmd = New-Object system.Data.Odbc.OdbcCommand($sql,$conn)
$da = New-Object system.Data.Odbc.OdbcDataAdapter($cmd)
$dt = New-Object system.Data.datatable
$null = $da.fill($dt)
$conn.close()
$dt

Now open a PowerShell shell and simply execute the script:

Run SQL in PowerShellapps ps exed

« Microsoft Power BI Desktop MicroStrategy Desktop »