Connecting to Exa

Authentication

Exa uses API key authentication to secure access to their neural search engine and web content retrieval services. Authentication is handled through the APIKey connection property.

Obtaining Your API Key

To get your API key:

1. Visit the Exa dashboard at https://dashboard.exa.ai
2. Register for an account or log in to your existing account
3. Navigate to the API settings section
4. Generate or copy your API key
5. Set the APIKey connection property with your API key value

Required Connection Properties

• APIKey: Your Exa API key obtained from the dashboard (required)

Available Tables

The Exa API Profile provides access to the following powerful search and content retrieval capabilities:

• Search - Execute semantic and keyword searches across the web using Exa's neural search technology. Supports advanced filtering by domain, category, publication date, and search type.
• Contents - Retrieve complete page content, AI-generated summaries, and comprehensive metadata for specific URLs or search result IDs.
• Answer - Generate AI-powered answers to questions using Exa's search results as context, providing accurate and source-backed responses.
• SimilarLinks - Discover web pages similar to a given URL using Exa's advanced similarity matching algorithms.
• ResearchTasks - Access and monitor research tasks created through Exa's research API for complex information gathering workflows.

Connection Examples

Basic Connection String

Profile=C:\profiles\Exa.apip;APIKey=your_exa_api_key_here;

Alternative Connection String Format

Profile=C:\profiles\Exa.apip;ProfileSettings='APIKey=your_exa_api_key_here';

Usage Examples

Search Operations

Basic semantic search:

SELECT * FROM Search WHERE Query = 'artificial intelligence trends 2024'

Advanced search with filters:

SELECT * FROM Search
WHERE Query = 'machine learning research'
  AND NumResults = 50
  AND SearchType = 'neural'
  AND SearchCategory = 'research paper'
  AND StartPublishedDate = '2024-01-01'

Content Retrieval

Get full content for specific URLs:

SELECT * FROM Contents
WHERE Url = 'https://example.com,https://research-site.com'
  AND IncludeText = true

AI-Powered Answers

Generate answers with source citations:

SELECT Answer, Citations FROM Answer
WHERE Query = 'What are the latest developments in quantum computing?'

Similar Content Discovery

Find similar pages:

SELECT * FROM SimilarLinks
WHERE Url = 'https://example.com/article'
  AND NumResults = 20
  AND IncludeDomains = 'research.google.com'

Research Task Management

Monitor research tasks:

SELECT Id, Status, Instructions FROM ResearchTasks

Rate Limits and Costs

Exa API usage is subject to rate limits and costs based on your subscription plan. Monitor your usage through the Exa dashboard. The Search and Contents tables include cost information in the response data to help track API usage costs.

Connection Properties

The connection string properties are the various options that can be used to establish a connection. This section provides a complete list of the options you can configure in the connection string for this provider.

---

Property	Description
APIKey	The API Key from your Exa account.
AuthScheme	The scheme used for authentication. Accepted entry is APIKey. Allowed values are: BASIC, NONE, NTLM, OAUTH, APIKEY, OAUTH_CLIENT