Partner ｜ TROCCO
Automates data linkage and operation to support stability of the analytics platform
What Is TROCCO?
TROCCO is a data linkage (ETL/ELT) platform that collects and integrates fragmented data scattered across companies and automatically connects it to an analytics platform.
It automates data transfer from various data sources, including SaaS applications, business systems and databases used in the company, and builds stable data pipelines on cloud-based data warehouses (DWH) such as BigQuery and Snowflake.
It can manage job scheduling, monitor execution, and handle data transformation, enabling continuous data utilization while minimizing operational burden.
The next-generation data pipeline achievable with TROCCO
Automating data collection and integration
TROCCO collects data scattered across the company, including advertising, CRM, SaaS, and business systems data, and automatically connects it to the analytics platform.
Integrating data across different formats and storage locations involves considerable manual work and operational costs, but TROCCO supports a wide range of SaaS and databases, and can automate linkage while accounting for differences in data sources.
It reduces the effort required to build an analytics platform, shortening the time until data utilization.
An all-in-one platform for everything from data linkage to processing
In addition to data linkage, TROCCO can also perform simple data processing and transformation for analysis.
By integrating SQL and other transformation processing into jobs, post-import formatting is streamlined to quickly provide data that is ready for analysis.
Data pipeline operation that eliminates dependency on specialists
As a no-code ETL/ELT platform, TROCCO enables everything from data linkage configuration to operational management within a GUI (dashboard) and can operate with minimal specialized development.
It is easy to use not only for engineers but also for analysts and business users, enabling smooth workflow from data preparation to utilization.
An operational platform that supports nonstop data linkage
The platform features administrative functions designed for the continuous operation of data linkage, including job management, error notification, and permissions management.
It also helps ensure a prompt response when problems occur, without missing batch failures or processing delays.
An administrative system that ensures data reliability
The system manages data update history and processing logs, and includes mechanisms to detect anomalies.
Combined with permissions management, it is capable of tracking data change history and usage to achieve highly reliable operation.
Can be used safely in an internal network environment
“Self-hosted Runner”
TROCCO’s Self-hosted Runner is a tool that can execute data transfer processing on an internal network.
By deploying a runner in an on-premise environment or within a VPC, data linkage can be done safely without exposing your data to the public internet. A key feature is that it enables data pipelines to be built while maintaining governance, even for companies in highly regulated industries such as finance and healthcare.
A data pipeline
that takes your AI usage
to the next level
Making the most of generative AI and advanced analytics in business operations requires a platform capable of continuous utilization of up-to-date, reliable data.
TROCCO supports everything from data collection and integration to operational management and governance, creating a data linkage platform that is easy to use for AI and analytics. As a data platform that goes beyond BI and reporting and is designed for AI use cases such as retrieval-augmented generation (RAG), it supports continuous data utilization.
Overall view of a data pipeline using TROCCO
TROCCO is compatible with around 200 services, including advertising media, CRM, databases, and storage services.
It integrates a wide range of data sources to create a data pipeline that serves as the core of an analytics platform.
DATUM STUDIO Capabilities
With a team of over 150 data scientists and data engineers, DATUM STUDIO has introduced TROCCO mainly at companies in Japan.
In recognition of its extensive track record and knowledge, DATUM STUDIO received numerous awards sponsored by primeNumber, Inc., the developer and provider of TROCCO.
Our data engineers, who are well-versed in TROCCO and data utilization, assist clients in everything from coordination of all data within the company to operational design, and support development of platforms for accelerating data-driven business.
Frequently Asked Questions
- QWhat role does TROCCO play?
- ATROCCO is an ETL/ELT platform that collects data from diverse data sources and automatically moves it into a cloud data warehouse (DWH).
It mainly handles extraction and loading of data, while also performing simple transformations as needed. In full-scale transformation and modeling for analysis, it is commonly used in combination with tools such as dbt.
It efficiently aggregates SaaS and business systems data, and enables building and operation of stable analytics platforms.
- QWhat are the advantages of adopting TROCCO?
- A
One of the key features of TROCCO is that the dashboard and documents are available in Japanese, which lowers the hurdles to adoption and operation for Japanese companies.
Settings and error checks are also in Japanese, so learning costs and the risk of dependency on specialists can also be reduced.
At DATUM STUDIO, we work alongside clients to help them get the most out of TROCCO, providing everything from implementation design to establishment of the operational framework and in-house development support.
- QWhat are the key security features of TROCCO?
- A
Since Japan can be set as the data region, data can be integrated and managed in a form that is compliant with the Personal Information Protection Act and other relevant laws and aligned with the security standards of each company.
In addition, TROCCO is an AWS PrivateLink Ready Partner, and meets AWS technical validation standards.
AWS PrivateLink lets you build a secure network that connects data sources and destinations without exposing your data to the public internet.
- QCan TROCCO be implemented with our existing data warehouse?
- A
Yes.
TROCCO supports major cloud data warehouses such as BigQuery and Snowflake, and can be integrated smoothly into your existing analytics platform.
From connection with existing systems to implementation design, DATUM STUDIO proposes solutions tailored to each client’s environment.
- QTo what extent can data linkage be automated with TROCCO?
- A
With TROCCO, data linkage from SaaS and databases can be set as a scheduled job, and data collection and updating can be automated.
TROCCO monitors scheduling and execution and has error notification functions to support stable operation.
It eliminates manual data extraction and updating, enabling continuous and efficient data utilization.
- QWhat kind of jobs can be streamlined by introducing TROCCO?
- A
By introducing TROCCO, data collection and integration can be automated, reducing the operational costs and workload of the analytics platform.
For example, you can streamline tasks such as data import from various SaaS and business systems, regular data updates, and job monitoring and notification.
This reduces manual data extraction and processing for faster access to data.
Note: The content on this page is based on information available as of March 2026. Please feel free to contact us for the latest updates.
Team comprising over 150 data scientists Proven track record across industries and sectors
DATUM STUDIO has a team of more than 150 data scientists and a proven track record of using AI in the resolution of management issues for companies in a broad range of industries and sectors. To help you achieve your business goals, we can flexibly respond to needs from problem identification to planning for optimal data utilization, proof of concept (PoC), infrastructure building, AI model construction, continuous integration (CI), continuous delivery (CD), and continuous training (CT).
