OpenAsset connector

Use your OpenAsset data for reporting, automation and AI.

Data Panda brings your OpenAsset library together with the data from the rest of your firm. From one place, we turn projects, files, employees and keywords into dashboards, automations, AI workflows and custom apps your studio uses every day.

About OpenAsset

The project photo library built for architects, engineers and contractors.

OpenAsset was started in London in 2003 as a digital asset management product built for one industry: architecture, engineering and construction. The London office opened in 2004, the New York one in 2010, the platform moved fully to cloud SaaS in 2015, and Marlin Equity Partners invested in 2023. The company operates as Axomic Ltd and reached 1,000 customer firms in 2025. The product has stayed close to its original purpose: a place where studio marketing teams can find the right project photo, the right headshot of the right architect, and the right floor plan, without rummaging through a shared drive.

The data model reflects that focus. Files (photos, drawings, PDFs, video) hang off Projects with custom keyword categories per firm, Employees carry their own headshots and role tags, Sizes and AspectRatios let one master file render at the dimensions a proposal template needs, and Categories, Topics and Fields organise the taxonomy. The API exposes all of it: Projects, Files, Employees, Photographers, Keywords, KeywordCategories, Categories, Sizes, Albums, CopyrightHolders, AccessLevels and DataIntegrations. The interesting question once OpenAsset is in a warehouse is not what's in the library. It's which projects ship to a client proposal without a primary photo, which employees are missing a headshot on the bid that goes out tomorrow, and which files keep getting downloaded for proposals on practice areas the firm does not really want to grow.

Ideas

What you can automate with OpenAsset.

Pair with monday.com

Tie OpenAsset projects to delivery boards in monday

OpenAsset Projects, with their codes, locations and keyword categories, are matched to the corresponding monday boards and items so a project that just shot a finished-building photo set is visible on the same board the project team uses for delivery. Marketing can pull a fresh asset list per project without asking the project lead, and the project lead sees which assets exist before requesting another shoot.

Pair with Slack

Notify the studio in Slack when proposal-critical assets land

New OpenAsset uploads tagged to a project that has an open pursuit get pushed into the right Slack channel with a thumbnail and a link, so the marketing coordinator working on that bid sees the new finished-construction photo or drone pass within minutes. The same channel surfaces missing-headshot warnings for any employee on the proposal team.

Pair with HubSpot

Match OpenAsset projects to HubSpot deals

OpenAsset Projects, keywords and asset counts are joined to HubSpot deals so the firm can see which pursuits cite which past work, how often a given project image appears in winning proposals, and which sectors keep going to bid on thin asset coverage. The pipeline view picks up which deals are blocked because the supporting reference project has no usable photography yet.

Pair with Salesforce

Match OpenAsset projects to Salesforce opportunities

OpenAsset Projects and Employees are matched to Salesforce accounts, opportunities and proposal records, so a BD lead opening an opportunity sees the asset coverage of the projects they plan to cite as references. Asset gaps for a key sector or client become a number on the forecast call instead of a Friday-afternoon scramble.

Pair with Exact Online

Reconcile OpenAsset projects with the Exact Online project ledger

OpenAsset Projects are reconciled against the project codes in Exact Online, so the marketing library and the financial ledger agree on which projects exist, which are closed and which were renamed. Studio leadership sees asset coverage next to project margin, instead of running them as two separate spreadsheets that never line up.

Pair with HiBob

Keep OpenAsset employee records in step with HiBob

HiBob employee records, role and start date are matched against OpenAsset Employees, so new architects and engineers get a headshot request triggered on day one and leavers are flagged for asset cleanup. Bids never go out with a portrait of someone who left two years ago, and the marketing team stops chasing HR for a fresh org list before every pitch.

Data model

Tables we make available.

These are the 11 tables we currently pull from OpenAsset into your warehouse. Query them directly in SQL, join them to the rest of your stack, or build reports on top.

Albums
Categories
Copyright Holders
Copyright Policies
Employees
Fields
Files
Keyword Categories
Keywords
Projects
Users

Missing a table you need? We can extend the sync. Tell us what is missing and we will build it for you.

Your existing tools

Your data lands in a warehouse. Your BI tools read from it.

You keep the reporting tool you already have. We connect it to the warehouse where your OpenAsset data lives.

Power BI Microsoft

Fabric Microsoft

Snowflake Data warehouse

BigQuery Google

Tableau Visualisation

Excel Sheets & pivots

Three steps

From OpenAsset to answers in three steps.

Connect securely

OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys.

Land in your warehouse

Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.

Reporting, automation, AI

We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.

Two ways to work with us

Pick the track that fits how you work.

Track 01

Self-serve

We set up the foundation. Your team builds on top.

OpenAsset connector configured and running
Warehouse set up in your cloud account
Clean access for your Power BI, Fabric or Tableau team
Documentation on what's in the data model
Sync monitoring so you're warned before reports break

Best fit Teams that already have a BI analyst or data engineer and want to own the build.

Track 02

Done for you

We build the whole thing, end to end.

Everything in Self-serve
Dashboards built to the questions your team actually asks
Automations between your systems
AI workflows scoped to real tasks your team runs
Custom apps where a dashboard does not cut it
Ongoing delivery at a pace that fits your team

Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.

Before you book

Frequently asked questions.

Who owns the data?

You do. It lands in your warehouse, on your cloud account. We don't resell or aggregate it. If you stop working with us, the warehouse stays yours and keeps running.

How fresh is the data?

Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.

Do I need a warehouse already?

No. If you don't have one, we help you pick one and set it up as part of the first delivery. Common starting points are Snowflake, Microsoft Fabric, or a small Postgres start.

GDPR-compliant

Data stays in the EU

You own the warehouse

A first deliverable live in four to six weeks.

We review your OpenAsset setup and the systems around it. Together we pick the first thing worth building.

Book a call See our other connectors