- Tutorials
- ETL/ELT and Orchestration
- Connection Configurations
- A8.net Connection Configuration
- Connection Configuration for Adobe Marketo Engage
- Amazon DynamoDB Connection Configuration
- Connection Configuration for Amazon Redshift
- Apple Search Ads Connection Configuration
- Connection Configuration for AppsFlyer
- Connection Configuration for Azure Blob Storage
- Connection Configuration for Azure Synapse Analytics
- Connection Configuration for Google BigQuery
- Connection Configuration for Box
- Connection Configuration for Databricks
- Connection Configuration for e-Sales Manager
- Connection Configuration for Facebook Ad Insights
- Facebook Ad Reporting, Conversions, Offline Conversions, Custom Audience Application Creation and Token Acquisition Procedures for Custom Audiences
- freee accounting connection information
- Connection Configuration for GitHub
- Connection Configuration for Google Ad Manager
- Connection Configuration for Google Analytics
- Connection Configuration for Google Analytics 4
- Connection Configuration for Google Cloud Spanner
- Connection Configuration for Google Cloud Storage
- Connection Configuration for Google Drive
- Connection Configuration for Google Play
- Connection Configuration for Google Search Console
- Connection Configuration for Google Sheets
- Connection Configuration for Google Ads
- HTTP/HTTPS Connection Configuration
- HubSpot Connection Configuration
- Connection Configuration for JIRA
- Connection Configuration for KARTE Datahub
- Connection Configuration for kintone
- Connection Configuration for LINE Ads
- Connection Configuration for MongoDB
- Connection Configuration for Microsoft Advertising
- Connection Configuration for Microsoft SQL Server
- Connection Configuration for MySQL
- Connection Configuration for Oracle Database
- Connection Configuration for PostgreSQL
- Connection Configuration for RTB House
- Rtoaster insight+ with Google Account integration Connection Configuration
- S3 Connection Configuration
- Connection Configuration for Salesforce Marketing Cloud Account Engagement
- Connection Configuration for Salesforce
- Sansan接続情報
- Connection Configuration for SHANON MARKETING PLATFORM
- Connection Configuration for Slack
- SmartHRの接続情報
- Connection Configuration for Snowflake
- Square接続情報
- Stripe接続情報
- Tableau Connection Configuration
- Connection Configuration for ValueCommerce
- Connection Configuration for X Ads (Formerly Twitter Ads)
- Connection Configuration for Yahoo! Search Ads and Display Ads (managed)
- Connection Configuration for Zendesk Support
- Zoho Books Connection Configuration
- Connection Configuration for Zoho CRM
- Connection Configuration for Next SFA
- Notes on referencing BigQuery tables generated from SpreadSheets
- Connecting via SSH Tunnel
- Obtain Google Cloud JSON Key
- ETL Configurations
- ETL Configuration List
- Data Sources
- Data Source - A8.net
- Data Source - Adobe Marketo Engage
- Data Source - Amazon Aurora MySQL
- Data Source - Amazon CloudWatch Logs
- Data Source - Amazon DynamoDB
- Data Source - Amazon Redshift
- Data Source - Amazon S3
- Data Source - App Store Connect API
- Data Source - Apple Search Ads
- Data Source - AppsFlyer
- Data Source - Amazon Athena
- Data Source - Azure Blob Storage
- Data Source - Google BigQuery
- Data Source - Box
- Data Source - Cisco Secure Endpoint
- Data Source - Criteo
- Data Source - CrowdStrike
- Data Source - Databricks
- Data Source - Elasticsearch
- Data Source - e-Sales Manager
- Data Source - Facebook Ad Creative
- Data Source - Facebook Lead Ads
- Data Source - Facebook Ad Insights
- Transfer source - freee accounting
- Data Source - FTP/FTPS
- Data Source - GitHub GraphQL API
- Data Source - Google Ad Manager
- Data Source - Google Ads
- Data Source - Google AdSense
- Data Source - Google Analytics
- Data Source - Google Analytics 4
- Data Source - Google Cloud Spanner
- Data Source - Google Cloud Storage
- Data Source - Google Drive
- Data Source - Google Play
- Data Source - Google Search Console
- Data Source - Google Sheets
- Data Source - HTTP/HTTPS
- Data Source - DataSpot
- Data Source - JIRA
- Data Source - KARTE Datahub
- Data Source - kintone
- Data Source - LINE Ads
- Data Source - Microsoft SQL Server
- Data Source - Microsoft Advertising
- Data Source - MongoDB
- Data Source - MySQL
- Data Source - MySQL binlog (CDC)
- Data Source - Oracle Database
- Data Source - PostgreSQL
- Data Source - RDBMS Version Support Chart
- Data Source - Repro
- Data Source - Rtoaster insight+ with Google Account integration
- Data Source - RTB House
- Data Source - Salesforce Report
- Data Source - Salesforce
- Data Source - Salesforce Marketing Cloud Account Engagement
- 転送元 - Sansan
- Data Source - SFTP
- Data Source - Shopify
- Data Source - SHANON MARKETING PLATFORM
- Data Source - Slack
- 転送元 - SmartHR
- Data Source - Snowflake
- 転送元 - Square
- 転送元 - Stripe
- Data Source - Tableau CRM Analytics
- Data Source - TikTok Ads
- Data Source - Treasure Data
- Data Source - X Ads (Formerly Twitter Ads)
- Data Source - TROCCO Web Activity Log
- Data Source - TROCCO
- Data Source - Yahoo! Display Ads (Managed)
- Data Source - ValueCommerce
- Data Source - Yahoo! Search Ads
- Data Source - Zendesk Support
- Data Source - Zoho Books
- Data Source - Zoho CRM
- Data Source - Next SFA
- Data Source - Local Files
- Data Destinations
- Data Destination - Adobe Marketo Engage
- Data Destination - Amazon Redshift
- Data Destination - Amazon S3
- Data Destination - Amazon S3 Parquet
- Data Destination - Azure Blob Storage
- Data Destination - Azure Synapse Analytics
- Data Destination - Google BigQuery
- Data Destination - Box
- Data Destination - Braze
- Data Destination - Databricks
- Data Destination - e-Sales Manager
- Data Destination - Facebook Offline Conversions
- Data Destination - Facebook Custom Audience(Beta Feature)
- Data Destination - Facebook Conversions API
- Data Destination - FTP/FTPS
- Data Destination - Google Ads Conversions
- Data Destination - Google Analytics 4 Measurement Protocol
- Data Destination - Google Analytics Measurement Protocol
- Data Destination - Google Cloud Storage
- Data Destination - Google Drive
- Data Destination - Google Sheets
- Data Destination - Google Offline Conversion
- Data Destination - Data Destination - HubSpot
- Data Destination - KARTE Datahub
- Data Destination - kintone
- Data Destination - LINE Conversion API
- Data Destination - Microsoft SQL Server
- Data Destination - MySQL
- Data Destination - PostgreSQL
- Data Destination - Rtoaster insight+.
- Data Destination - Salesforce
- Data Destination - Salesforce Marketing Cloud
- Data Destination - SFTP
- Data Destination - Snowflake
- Data Destination - Treasure Data
- Data Destination - X Ads (Formerly Twitter Ads) Web Conversions
- Data Destination - Yahoo! JAPAN Ads Display Ads Conversion Measurement API (Beta Feature)
- Data Destination - Zoho CRM
- Common Settings
- Other Settings
- Managed ETL Configurations
- Data Mart
- dbt Integration
- Workflow
- Useful Features
- Connection Configurations
- Data Management
- Data Catalog
- About Data Catalog
- How to Start Using
- Understanding Data (Table Information)
- View and analyze relationships between data (ER diagram, JOIN analysis)
- Defining Data Relationships (see Column Setting)
- Finding data (table/column search)
- Write a query (Query Editor)
- Data Catalog Setting
- Data Store Coordination Management
- List of functions supported by each data store
- Automatic asset capture function
- Automatic metadata acquisition function
- Data Catalog Glossary
- Data Catalog
- Teams
- System Management
- Account Management
- TROCCO Web Activity Log
- FAQ
- Error Handling
- Other General FAQ
- How to resolve the error due to the high volume of transfers from Data Source BigQuery
- How to get the value by specifying the element when the Data Source column's JSON contains an array.
- Can I speed up the transfer rate?
- Retention period for logs of ETL Job system in TROCCO
- How to specify the time zone in the Data Destination column representing the time
- About transferable capacity
- Use of BigQuery Scripts when Creating Data Mart Configuration
- About file compression settings
- How to create a SOQL from the developer console
- Access rights to the created ETL Configuration, Data Mart Configuration, etc.
- Custom Variable Loop Execution
- Efficiently update master tables on DWH without duplication
- Google API Disclosure
- recommended system requirements (software)
- Detailed information about your plan
- More information about Professional Plans
- Maintenance with Downtime
- Release Notes
- List of Release Notes
- リリースノート-2025年01月
- リリースノート-2024年12月
- リリースノート-2024年11月
- Release Notes - October 2024
- Release Notes - Sep 2024
- Release Notes - August 2024
- Release Notes - July 2024
- Release Notes - Jun 2024
- Release Notes - May 2024
- Release Notes - Apr 2024
- Release Notes - Mar 2024
- Release Notes - Feb 2024
- Release Notes - January 2024
- Release Notes - December 2023
- Release Notes - November 2023
- Release Notes - October 2023
- Release Notes - Sep 2023
- Release Notes - August 2023
- Release Notes - July 2023
- Release Notes - Jun 2023
- Release Notes - May 2023
- Release Notes - Apr 2023
- Release Notes - Mar 2023
- Release Notes - Feb 2023
- Release Notes - January 2023
- Release Notes - December 2022
- Release Notes - November 2022
- Release Notes - October 2022
- Release Notes - Sep. 2022
- Release Notes - August 2022
- Release Notes - July 2022
- Release Notes - Jun 2022
- Release Notes - May 2022
- Release Notes - Apr 2022
- Release Notes - Mar 2022
- Announcement
- Terms of Service
Welcome to TROCCO
TROCCO offers a wide range of functions that are essential to the operation of a data analytics platform.
As a first step, let's first transfer data.
This page will walk you through the process of completing the data transfer for your first TROCCO customer.
Please refer to the following page if you have any trouble using TROCCO.
I don't understand the error message
Please refer to the Error Message Collection.
Sometimes you want to know or don't know the TROCCO specifications
Please refer to the page under Other Basic FAQ.
Steps to Data Transfer
Let's use TROCCO to transfer data immediately.
TROCCO allows you to transfer data by following these steps:
1. Create Connection Information
Creates connection information for TROCCO to connect to the source and destination services.
For more information, see Create Connection Information.
2. Data Transfer
Create transfer settings that define how data is transferred and run the job.
For more information, see Transferring Data.
You can configure various useful settings for the transfer settings you create, such as notifications and scheduling.
For more information, see Configuring Transfer Settings Conveniently.
Next Steps in Data Transfer
TROCCO is more than just a tool for transferring data.
We have various functions necessary for the operation of the data analysis platform.
Below are some of the most frequently used features.
Data mart definition
The Data Mart definition allows you to convert and aggregate data by executing queries on data stored in DWH.
For more information, see Processing Data.
Workflow Definition
Workflow definitions allow you to define dependencies (order of execution) between each transfer setting or data mart definition in the form of graphs.
By running the defined workflow, each job can be executed in the order you intended.
For more information, see Configuring Workflows.