.tv-fallback{font-family:ui-monospace,SFMono-Regular,Menlo,Consolas,monospace;padding:2rem;color:#86efac;background:#030712;line-height:1.6}.tv-fallback a{color:#4ade80}.tv-fallback h1,.tv-fallback h2,.tv-fallback h3{color:#bbf7d0}.tv-fallback ul{padding-left:1.25rem}.tv-fallback li{margin-bottom:.5rem}

tvsguide.io · Projects · Fivetran Carta Connector

Fivetran Carta Connector

Custom Fivetran connector for Carta equity management

A custom Fivetran connector for extracting data from Carta's API and loading it into BigQuery. Syncs comprehensive equity management data including firms, funds, investments, certificates, convertible notes, warrants, and cap tables.

Features modular architecture with specialized processor classes, OAuth 2.0 authentication, error handling with graceful degradation, and fund performance metrics including IRR, MOIC, DPI, RVPI, and TVPI.

Tech: Python, Fivetran SDK, OAuth 2.0, GitHub Actions

Features

Syncs cap tables, certificates, warrants, and convertible notes
Fund performance metrics (IRR, MOIC, DPI, RVPI, TVPI)
Modular processor classes for each data type
Resilient design with graceful error handling
OAuth 2.0 Client Credentials authentication

More from the portfolio

This project is part of tvsguide.io, the personal portfolio of Tim Veil — software engineer and CIO at Two Bear Capital, previously at StarTree, Cockroach Labs, and Hortonworks. The full collection covers distributed systems, data infrastructure, JDBC drivers, AI services, build pipelines, real-time analytics, and a couple of personal apps. Each project ships with source code, tech notes, and links to live deployments where applicable.

BigQuery JDBC Driver — Modern JDBC driver for Google BigQuery, optimized for database IDEs with fast metadata support
Flight Chop — Passenger focused platform helping travelers understand turbulence and other conditions that may impact their flight
Leaves of Blocks — Free SwiftUI iOS puzzle game with no ads, no tracking, and no in-app purchases
Bloviate — Java library for generating realistic test data for databases
Quantum Beacon — Pipeline for analyzing company domains for Post-Quantum Cryptography (PQC) support
BenchBase — Multi-DBMS SQL benchmarking framework via JDBC
Two Bear Tracker — Portfolio tracking application with comprehensive analytics monitoring capabilities
Two Bear Capital API — Three-phase AI extraction API for VC pitch decks with Claude Sonnet 4.5
Two Bear Capital MCP Server — Model Context Protocol server for enterprise data access
Bear Stack — Modern monorepo template with clean architecture patterns
Fivetran Affinity Connector — Custom Fivetran connector for Affinity CRM data sync
Fivetran Standard Metrics Connector — Custom Fivetran connector for portfolio company metrics
Fivetran dbt — dbt project transforming multi-source data into BigQuery
Pinot TestContainers Example — Integration testing framework for Apache Pinot using TestContainers
CockroachDB Remote Client — Docker container for one-time CockroachDB administrative tasks
CockroachDB Single Node — CI/CD optimized Docker image for CockroachDB testing
CockroachDB Dynamic Certs — Dynamic certificate generator for secure CockroachDB deployments
CockroachDB Dynamic HAProxy — Dynamic HAProxy load balancer for CockroachDB clusters
CockroachDB Spring Examples — Spring Boot examples for connecting to CockroachDB

Browse the project index, read about Tim's background, follow the blog, or return to the homepage. Source code lives on GitHub; professional history is on LinkedIn.