.DkNUKaKx_ZLAT4m.webp?dpl=dpl_2g7utNqo1QcVopVsXyXRGLPAkqY1){kind=small}
Connectors / Finance · HTTP Connector
Automate Vena Solutions with Tray.ai
Create a job, export intersection values and export a Vena Table in Vena Solutions. Connect Vena Solutions to the rest of your finance stack with Tray.ai.
What can you do with Vena Solutions on Tray.ai?
Vena is a financial planning and analysis platform built around Excel, used for budgeting, forecasting, consolidation and reporting on a central data model. Tray.ai connects to Vena Solutions through the HTTP Connector, so your workflows can call the Vena Solutions API alongside the rest of your stack.
- Start a job with data in Vena to load monthly actuals from your accounting system.
- Export a Vena Table and load it into your data warehouse for reporting.
- Get job status from Vena and alert finance in your team chat when a data load fails.
- Connects through
- HTTP Connector
- Authentication
- Basic authentication
- Base URL
- https://{hub}.vena.io/api/public/v1
Set it up
Connect Vena Solutions to Tray.ai
Each step uses Vena Solutions's own API details, from its documentation.
Step 1
Save Vena Solutions's username and password
Save the credentials Vena Solutions gives you as a Tray.ai authentication. The HTTP Client sends them as basic auth. They stay out of the workflow and out of the logs.
Step 2
Point the HTTP Client at the API
Add an HTTP Client step and use https://{hub}.vena.io/api/public/v1 as the base URL. Or paste a cURL example from Vena Solutions's API docs, and Tray.ai fills in the method, URL, and headers.
Step 3
Start with “List ETL templates”
It's one of 13 documented actions, under ETL templates. The response comes back as data the next step can map into your other apps.
Step 4
Hand it to an AI agent
Wrap “Get an ETL template” and “Start a job with data” in workflows, and Tray.ai's Agent Gateway for MCP publishes them as governed tools Claude and other AI agents can call.
Give your AI agents Vena Solutions tools
Build an MCP server on Vena Solutions in Agent Gateway and choose which actions your agents can call. Every call runs with access control and an audit trail. How Agent Gateway works
- List ETL templates
- Start a job with data
- Export intersection values
- List Vena Tables
- Get an ETL template
- Start a job with a file
- Create a job
- Get job status
What the Vena Solutions API covers
4 resources and 13 documented actions, each one a call the HTTP Connector can make from a Tray.ai workflow. Connecting it takes a few clicks: here's how.
ETL templates
- List ETL templates
- Get an ETL template
ETL jobs
- Start a job with data
- Start a job with a file
- Create a job
- Get job status
- Submit a job
- Cancel a job
Model data
- Export intersection values
- Export the model hierarchy
Vena Tables
- List Vena Tables
- Get a Vena Table
- Export a Vena Table
Checked against Vena Solutions's own documentation on 2026-10-22
How Tray.ai makes this work
Vena Solutions plugs into the whole Tray.ai platform
Intelligent Integration
Integrate and automate across 10,000+ apps, databases, APIs, and services with visual workflows, error handling, and observability.
Learn more →Agent Builder
Build AI agents that read, write, and take action in Vena Solutions — with guardrails, audit, and human-in-the-loop.
Learn more →Agent Gateway for MCP
Expose Vena Solutions actions as governed MCP tools — observable, rate-limited, authenticated.
Learn more →Tray Helix
Build apps on Vena Solutions data with your AI assistant, then deploy, run, and govern them on Tray.ai.
Learn more →More finance apps on Tray.ai
Dedicated connectors and other apps Tray.ai reaches in the same category. See every finance connector →
Frequently asked questions
What can a Tray.ai workflow do in Vena Solutions?
+
The Vena Solutions API documents 13 actions across 4 resources (ETL templates, ETL jobs, Model data, Vena Tables). For example: List ETL templates; Start a job with data; Export intersection values. A workflow can make any documented call through the HTTP Connector.
How does Tray.ai authenticate with Vena Solutions?
+
The Vena Solutions API uses basic authentication. You save it once as a Tray.ai authentication, and the HTTP Connector adds it to every request.
See Vena Solutions working against your stack.
We'll walk through a tailored demo with your systems plugged in.
Thanks — someone from our team will be in touch soon.