Skip to main content

Elasticsearch Connector

Connect Elasticsearch clusters to Infino for unified querying with natural language, SQL, and Query DSL.

Prerequisites

  • Elasticsearch Cluster (self-hosted or cloud)
  • Cluster URL and port
  • Authentication Credentials (username/password or API key)

Required Permissions

  • Read access to target indices
  • cluster:monitor/main for cluster health
  • indices:data/read/search for querying data

Connection Setup

Access Connector

Navigate to Data → Connectors and search for "Elasticsearch" or browse the Database category.

Connection Configuration

  1. Click Elasticsearch connector - Opens connection modal
  2. Enter cluster URL - Your Elasticsearch endpoint (e.g., https://my-cluster.es.io:9200)
  3. Provide credentials - Username/password or API key
  4. Test connection - Verify connectivity and permissions
  5. Save connection - Create reusable connection

Authentication Options

  • Basic Authentication - Username and password
  • API Key - More secure for programmatic access
  • SSL/TLS - Encrypted connections

Using the Connection

Query Indices

Once connected, access Elasticsearch indices via:

  • Fino AI Assistant (Home) - Ask natural language questions
  • Query → Query Console - Execute Query DSL or SQL
  • Dashboards → Visualizations - Build charts from Elasticsearch data
  • Data → Explorer - Browse schemas and sample documents

Browse Indices

Navigate to Data → Sources to view all available Elasticsearch indices.

Optional: Import to Infino

Use Data → Sources to import specific Elasticsearch indices into Infino for:

  • Correlation with other data sources
  • Exploratory staging
  • Data enrichment workflows

Connection Management

Monitor Connection

Go to Data → Sources to:

  • View connection status and health
  • See last used timestamp
  • Import data if needed
  • Delete or reconfigure connection

Troubleshooting

  • Connection failed: Verify cluster URL and credentials
  • No indices visible: Check user permissions on target indices
  • Query errors: Ensure read permissions on indices
  • SSL errors: Verify certificate configuration