Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.cloud.cdata.com/llms.txt

Use this file to discover all available pages before exploring further.

Prerequisites

Before you can configure and use Agent Bricks with Connect AI, you must first connect a data source to your Connect AI account. See Sources for more information.

Create an OAuth App in CData Connect AI

Agent Bricks uses OAuth 2.0 to authenticate users against the CData Connect AI MCP Server. This requires an OAuth App in your CData Connect AI account. Because the OAuth App requires a callback URL, and the callback URL is not available until after you install the MCP Server in Databricks, you must create the OAuth App with a placeholder callback URL first, then update it after installation.
1
Click the gear icon in the top-right corner of Connect AI to open Settings.
2
Navigate to OAuth Apps and click + Create App. The Create OAuth App dialog appears.
3
Enter the following settings:
  • Name–enter a descriptive name (for example, AgentBricksOAuth).
  • Authentication Flow–select Service-based to use as an agentic platform, or User-based for a user-to-machine connection.
  • Callback URL–enter a placeholder URL (for example, https://placeholder.databricks.com). You will replace this with the real callback URL after installing the MCP Server.
Creating an OAuth App in CData Connect AI
4
Click Confirm. CData Connect AI generates a Client ID and Client Secret.
OAuth App Client Id and Client Secret
5
Copy both the Client ID and Client Secret. You will need them in the next section.

Configure the Connect AI MCP Server

1
Log in to Databricks and go to Databricks Marketplace.
2
In the search bar, enter Connect AI. Click CData Connect AI: Managed MCP Platform for Enterprise Databricks Agents.
Install MCP platform
3
Click Install. A dialog appears:
Install MCP platform dialog
4
Enter the Connection name for the app, such as QueryMCP.
5
Enter the Host, which is the URL for the CData MCP server (https://mcp.cloud.cdata.com).
6
Enter the Base path, which is either /mcp or the path to the custom MCP toolkits (see Toolkits for more information).
7
Enter the Client ID and Client Secret you copied from the OAuth App you created in the previous section.
8
Select the checkbox to accept the terms and conditions, then click Install.
9
In Databricks, go to Agents and find the new MCP server you just created. Copy the Active URL. This is the callback URL.
Callback URL

Update the OAuth App with the Callback URL

Now that you have the callback URL from Databricks, update the OAuth App you created earlier.
1
In Connect AI, click the gear icon to open Settings and navigate to OAuth Apps.
2
Find the OAuth App you created and click the Edit icon.
3
Replace the placeholder Callback URL with the Active URL you copied from Databricks.
Callback URL in OAuth app
4
Click Confirm to save the changes.