Query Live NetSuite SuiteAnalytics Data in Zed Editor via CData Connect AI

Zed is a high-performance, open-source code editor built for speed and collaboration. Its built-in AI agent panel supports LLM-powered interactions and MCP (Model Context Protocol) tool integrations, enabling developers to access live external data sources directly within the editor.

By integrating Zed with CData Connect AI through the built-in MCP (Model Context Protocol) Server, the Zed AI agent gains governed, real-time access to live NetSuite SuiteAnalytics data. This enables developers to query schemas, retrieve records, and explore NetSuite SuiteAnalytics data without leaving the editor or writing custom integration code.

This article explains how to configure NetSuite SuiteAnalytics connectivity in Connect AI, register the CData MCP Server in Zed, and query live NetSuite SuiteAnalytics data from the Zed agent panel.

Step 1: Configure NetSuite SuiteAnalytics connectivity for Zed

Connectivity to NetSuite SuiteAnalytics from Zed is made possible through CData Connect AI's Remote MCP Server. To interact with NetSuite SuiteAnalytics data from Zed, start by creating and configuring a NetSuite SuiteAnalytics connection in CData Connect AI.

1. Log into Connect AI, click Sources, and then click Add Connection

2. Select NetSuite SuiteAnalytics from the Add Connection panel

3. Enter the necessary authentication properties to connect to NetSuite SuiteAnalytics.

   Prerequisites

   Before you can connect to NetSuite SuiteAnalytics, you must set up SuiteAnalytics Connect in your NetSuite account:

   1. Enable the Connect Service feature.

      1. Ensure that your Account Administrator has enabled your Account and Role with the Connect Service feature.

      2. Navigate to Setup > Company > Enable Features.

      3. Click the Analytics tab and check the SuiteAnalytics Connect box.

   2. Add the SuiteAnalytics Connect permission to an existing Role, and note the Role ID for later.

   3. Find the Settings portlet on your home page and click Set Up SuiteAnalytics Connect, then click Your Configuration to view your service host and account ID. These settings map directly to the Server and Account Id properties.

   Add the NetSuite SuiteAnalytics Connection

   1. Open the Sources page of the Connect Cloud dashboard.

   2. Click Add Connection and select NetSuite SuiteAnalytics from the list of connectors.

   3. Enter a Connection Name of your choice.

   Authenticate to NetSuite SuiteAnalytics

   Set the following required properties:

   • Server: The Service Host value you found when setting up SuiteAnalytics Connect.

   • Account Id: The Account ID value you found when setting up SuiteAnalytics Connect.

   • Role Id: The internal ID of the login role you granted the SuiteAnalytics Connect permission.

   Next, choose one of the supported authentication methods:

   Basic authentication

   • User: The username you use to authenticate to your NetSuite account.

   • Password: The password associated with that account.

   Token-based authentication

   • Consumer Key and Consumer Secret: Generated when you create your integration record in NetSuite.

   • Token Key and Token Secret: The access token and secret generated for that integration.

   After you enter your credentials, click Save & Test to validate the connection.

   
4. Click Save & Test
5. Navigate to the Permissions tab and update user-based permissions

Add a Personal Access Token

A Personal Access Token (PAT) is used to authenticate the connection to Connect AI from Zed. It is best practice to create a separate PAT for each integration to maintain granular access control.

1. Click the gear icon () at the top right of the Connect AI app to open Settings
2. On the Settings page, go to the Access Tokens section and click Create PAT
3. Give the PAT a descriptive name and click Create

4. Copy the token when displayed and store it securely. It will not be shown again

With the NetSuite SuiteAnalytics connection configured and a PAT generated, Zed can now connect to NetSuite SuiteAnalytics data through Connect AI.

Step 2: Configure Connect AI in Zed

Now, let's register the CData Connect AI MCP endpoint in Zed so that the built-in AI agent can discover and call live data tools.

1. Download and install Zed
2. Open the agent panel by pressing Ctrl + Shift + /, or by clicking the sparkle icon at the bottom right of the editor
3. In the agent panel, click the ... (toggle agent menu) and select Add Custom Server from the dropdown
4. Select the Configure Remote option to configure CData's MCP
5. An Add MCP Server dialog opens displaying a remote server configuration template. Replace the placeholder content with the following JSON:

   {
       "cdata": {
           "url": "https://mcp.cloud.cdata.com/mcp",
           "headers": {
               "Authorization": "Basic your_base64_encoded_email_PAT"
           }
       }
   }
           

   Note: Combine your Connect AI email and PAT in the format email:PAT, Base64 encode the combined string, and prefix it with Basic. For example, given [email protected]:ABC123...XYZ, the header value becomes something like: Basic dXNlckBteWRvbWFpbjphSzkvbVB4Mi9Rcjd2TjQ...

   
6. Click Add Server or press Ctrl + Enter to register the MCP server

Configure an LLM provider

Zed requires at least one LLM provider to power the agent's reasoning. Configure a provider so the agent can interpret queries and call MCP tools through Connect AI.

1. Click the ... (toggle agent menu) and select Settings
2. Under LLM Providers, expand your preferred provider (e.g., Anthropic, OpenAI, Google AI) and enter your API key
3. Under Model Context Protocol (MCP) Servers, confirm that cdata appears with a green dot and the toggle is enabled

With the MCP server registered and an LLM provider configured, the Zed agent is ready to query live NetSuite SuiteAnalytics data through Connect AI.

Step 3: Query live NetSuite SuiteAnalytics data from the Zed agent

With the integration complete, use the Zed agent panel to explore and interact with live NetSuite SuiteAnalytics data through natural language prompts.

1. Open the agent panel using Ctrl + Shift + / and start a new thread
2. Enter a prompt to interact with your data, for example:
   • List all catalogs in my cdata connection
   • Show the available schemas and tables for NetSuite SuiteAnalytics
   • Query the top 5 records from a table in NetSuite SuiteAnalytics data
3. The agent calls the CData Connect AI MCP Server and returns live results from NetSuite SuiteAnalytics data

At this point, your Zed agent communicates with the CData Connect AI MCP Server and retrieves live NetSuite SuiteAnalytics data through remote MCP tools directly from the editor.

Get CData Connect AI

To access hundreds of SaaS, Big Data, and NoSQL sources directly from your cloud applications, try CData Connect AI today! Start a free 14-day trial of CData Connect AI today, and as always, our world-class Support Team is available to assist you with any questions you may have.