TROCCO

TROCCO is a cloud ETL service from primeNumber Inc., a Tokyo data technology company founded in November 2015 with headquarters in Shinagawa. It addresses the effort Japanese enterprises spend building and operating data pipelines, and the company says more than 2,500 customers use TROCCO.

TROCCO centres on data transfer and transformation, with connectors for advertising platforms, SaaS applications, files and storage, databases, ERPs and data warehouses. Users configure transfers in a no-code interface, build data marts with SQL, chain jobs into workflows and manage permissions. Higher plans add CDC, Git integration, programmatic ETL, self-hosted runners, PrivateLink, SSO and audit logs. The same company also offers COMETA, an AI data catalogue and conversational analysis platform.

• No-code data transfer: Configure ETL jobs from ads, SaaS, files, databases and ERPs.
• Data mart builder: Append, replace or custom SQL data marts, including SCD Type 2.
• Workflow orchestration: Chain transfers and transformations into scheduled workflows.
• Managed transfer settings: Bulk-manage many similar transfer jobs from one template.
• Enterprise security: SSO, audit logs, PrivateLink and self-hosted runners on higher plans.
• API and Git integration: TROCCO API and Git integration for programmatic operation.

A Japanese-owned manufacturer or retailer in Vietnam can consolidate ERP, sales and advertising data into BigQuery for group reporting. A digital marketing agency can automate daily ad performance transfers for many clients. An enterprise can schedule data mart builds for BI dashboards without a dedicated engineering team.

Business and data teams can automate transfers from advertising, SaaS and database sources into warehouses without writing pipeline code, reducing initial investment and operating burden. A 30-day trial with Advanced-level features is followed by a free plan with no time limit. Workflow, data quality checks and environment management help keep pipelines reliable as they grow.

Japanese and wider Asian enterprises are building cloud data platforms on Snowflake, BigQuery and Databricks to prepare data for AI, but data engineers remain scarce. Locally supported no-code ETL with Asian-language connectors for advertising and SaaS tools fits companies across the region.

primeNumber Inc. was founded on 19 November 2015, is headquartered at JR Tokyo Meguro Building, Shinagawa, Tokyo, with capital of 100 million yen; CEO Yuki Tanabe. Its company page shows SOC 2 and partner badges for Google Cloud, AWS, Snowflake and Databricks. It launched the primeNumber Autonomous Data Platform in October 2026.