About
Pricing
Contact Us
Sign in
TROCCO
TROCCO
COMETA
English
Ja - 日本語
English
Korean
Contents
x
Tutorials
ETL/ELT and Orchestration
Data Management
Teams
System Management
Account Management
TROCCO Web Activity Log
FAQ
Release Notes
Announcement
Terms of Service
Powered by
Connection Configurations
56 Articles
in this category
Share this
Print
Share
Contents
Connection Configurations
56 Articles
in this category
Share
A8.net Connection Configuration
summary This is the help page for setting up Connection Configuration for A8. entry Connection Configuration https://www.a8.net/ Please enter the login ID and****PASS of the advertiser member when logging in from Please prepare a logi...
Connection Configuration for Adobe Marketo Engage
summary This is the help page for setting up Connection Configuration for Adobe Marketo Engage. How to obtain Client ID and Client Secret It can be found on the LaunchPoint in the Adobe Marketo Engage administration page. For more informati...
Amazon DynamoDB Connection Configuration
summary This is the help page for setting up Connection Configuration for Amazon DynamoDB. How to create an AWS Access Key ID and AWS Secret Access Key Group Creation Log in to the IAM console. From the main page, select User Grou...
Connection Configuration for Amazon Redshift
summary This is the help page for setting up Connection Configuration for Amazon Redshift. Authority required for Connection Configuration used for Data Source It is necessary to create a user with the following permissions SELECT TABLE ...
Apple Search Ads Connection Configuration
summary This is the help page for setting up Connection Configuration for Apple Search Ads. Invite Users Log in to the administration screen with Account Admin privileges and invite users with API execution privileges from https://app.search...
Connection Configuration for AppsFlyer
summary Help page for creating Connection Configurations for AppsFlyer. Setting items AppsFlyer API token Please use V2.0 tokens. API tokens can only be obtained by an AppsFlyer admin user (administra...
Connection Configuration for Azure Blob Storage
summary This is the help page for setting up Connection Configuration for Azure Blob Storage. How to Obtain a Storage Account Key Open the Microsoft Azure portal screen. Select a storage account from the left bar and choose the ...
Connection Configuration for Azure Synapse Analytics
summary This is the help page for setting up Connection Configuration for Azure Synapse Analytics. entry
Connection Configuration for Google BigQuery
summary This is a help page for setting up Connection Configuration for Google BigQuery. There are two ways to set up Google BigQuery Connection Configuration in TROCCO: using a Google account or using a service account. This page describes the...
Connection Configuration for Box
summary Help page for creating Connection Configuration for Box. entry precautions Some of the Box API tokens, codes, and URLs have an expiration date. Expiration date of access token An access token ...
Connection Configuration for e-Sales Manager
summary This is the help page for setting up Connection Configuration for e-Sales Manager. How to obtain an API token Click on the top right corner where the name of the account you are logged into is displayed, then click on System Setting...
Connection Configuration for Facebook Ad Insights
summary This is the help page for setting up Connection Configuration for Facebook Ad Insights. Please prepare a Facebook account with access to Facebook ads in advance. constraints Facebook credentials must be re-authenticated every 60 d...
Facebook Ad Reporting, Conversions, Offline Conversions, Custom Audience Application Creation and Token Acquisition Procedures for Custom Audiences
summary Instructions on how to create app tokens for Facebook Ad Reports, Conversions, Offline Conversions, and Custom Audience integration. Creating Apps First, create a Facebook application. Go to Facebook Business Manager > Busine...
Connection Configuration for GitHub
summary This is the help page for setting up GitHub Connection Configuration. summary Authentication to connect to GitHub is done using a personal access token . Obtaining a personal access token See here.
Connection Configuration for Google Ad Manager
summary This is the help page for setting up Connection Configuration for Google Ad Manager. For more detailed information, please refer to the official page. Set JSON Key Refer to Obtaining a Google Cloud JSON Key to obtain a JSON Key....
Connection Configuration for Google Analytics
Google Analytics (Universal Analytics) Service Termination In response to Google's discontinuation of Universal Analytics , this Connector will be discontinued on July 01, 2024 . After 07/01/2024 , it will no ...
Connection Configuration for Google Analytics 4
summary This is the help page for setting up Connection Configuration for Google Analytics 4. There are two ways to set up Connection Configuration for Google Analytics 4 in TROCCO: using a Google account or using a service account. Preparatio...
Connection Configuration for Google Cloud Spanner
summary This is the help page for Google Cloud Spanner Connection Configuration. Set JSON Key Refer to Obtaining a Google Cloud JSON Key to obtain a JSON Key. Service accounts should be assigned the following roles Cloud Spanner >...
Connection Configuration for Google Cloud Storage
summary This is the help page for setting up Connection Configuration for Google Cloud Storage. Set JSON Key Refer to Obtaining a Google Cloud JSON Key to obtain a JSON Key. Service accounts should be assigned the following roles Clo...
Connection Configuration for Google Drive
summary This is the help page for setting up Connection Configuration for Google Drive. Preparation before transfer In order to use Google Drive transfers with TROCCO, the following work is required Grant permissions to email addresses i...
Connection Configuration for Google Play
summary This is a help page for setting up Connection Configuration for Google Play. Set JSON Key Refer to Obtaining a Google Cloud JSON Key to obtain a JSON Key. Service accounts should be assigned the following roles Cloud Storage ...
Connection Configuration for Google Search Console
summary This is the help page for setting up Connection Configuration for Google Search Console. For more detailed information, please refer to the official page. Set JSON Key Refer to Obtaining a Google Cloud JSON Key to obtain a JSON ...
Connection Configuration for Google Sheets
summary This is the help page for Connection Configuration in Google Sheets. There are two ways to set up Connection Configuration for Google Sheets in TROCCO: using a Google account or using a service account. Preparation before transfer If...
Connection Configuration for Google Ads
summary This is the help page for Connection Configuration for Google Ads (Google Ads). In advance, please prepare a Google account with read-only or higher access rights to Google ads. How to authenticate your Google account Connectio...
HTTP/HTTPS Connection Configuration
summary Help page for creating Data Source HTTP/HTTPS Connection Configuration. Use this Connection Configuration when you wish to connect using OAuth 2.0 when retrieving data from HTTP/HTTPS protocol web services. In this article, "HTTP/HTTPS ...
HubSpot Connection Configuration
summary This is the help page for setting up HubSpot's Connection Configuration. Stop using HubSpot API key as authentication method HubSpot API keys will no longer be available as an authentication method to ac...
Connection Configuration for JIRA
summary This is the help page for setting up Connection Configuration in JIRA. entry
Connection Configuration for KARTE Datahub
summary This is the help page for setting up Connection Configuration for KARTE Datahub. About Service Account JSON Keys Please use the service account JSON key issued by KARTE Datahub. For more information, please see KARTE Datahub's TROCCO...
Connection Configuration for kintone
summary This is the help page for setting up Connection Configuration for kintone. In the kintone Connection Configuration, you can choose between two login methods: using a username and password or using a token. About Domain Name You can c...
Connection Configuration for LINE Ads
summary This help page is for creating Connection Configuration for LINE Ads (formerly Line Ads Platform). Setting items How to obtain an API access key Application to use the LINE Ads API In order to obtain an API Access Key, you must ...
Connection Configuration for MongoDB
summary This is the help page for setting up Connection Configuration for MongoDB. entry MongoDB authentication settings MongoDB can be connected to without user authentication settings. However, TROCCO re...
Connection Configuration for Microsoft Advertising
This is the help page for setting up Connection Configuration for Microsoft Advertising. entry If the tenant's settings restrict user consent When you click on Microsoft Account Authentication, the following screen may appear. This wi...
Connection Configuration for Microsoft SQL Server
summary This is a help page for setting up Connection Configuration for Microsoft SQL Server. entry
Connection Configuration for MySQL
summary This is the help page for setting up Connection Configuration for MySQL. entry When SSL is enabled
Connection Configuration for Oracle Database
summary Help page for creating Connection Configuration for Oracle Database. entry Connection method Entry fields when "Specify host name and port number" is selected Entry fields when "Use tnsnames.ora file" is selected
Connection Configuration for PostgreSQL
summary This is the help page for Connection Configuration of PostgreSQL. entry When SSL is enabled
Connection Configuration for RTB House
summary This is the help page for setting up Connection Configuration for RTB House. Connection Configuration Enter Username as your****username and Password****as your password when logging into the RTB House administration page.
Rtoaster insight+ with Google Account integration Connection Configuration
summary This is a help page for setting up Connection Configuration using Rtoaster insight+ with Google Account integration. Prerequisite. Connection Configuration for Rtoaster insight+ with Google Account integration is used to retrieve data ...
S3 Connection Configuration
summary This is a help page on the procedure for using S3 with TROCCO. entry Basic Information Connection Configuration You can choose one of the following as your AWS authentication method IAM role: Obtains temporary authentication...
Connection Configuration for Salesforce Marketing Cloud Account Engagement
summary This is the help page for configuring Connection Configuration for Salesforce Marketing Cloud Account Engagement (formerly Pardot). This page describes how to identify the items required to set up a Salesforce Marketing Cloud Account Eng...
Connection Configuration for Salesforce
summary This is the help page for setting up Connection Configuration in Salesforce. entry elementary item You can choose "OAuth authentication" or "user password authentication" as an authentication method. The setting method differs de...
Connection Configuration for SHANON MARKETING PLATFORM
summary This is the help page for Connection Configuration of SHANON MARKETING PLATFORM. entry How to obtain input items and input procedure Please follow the steps below to obtain and enter your Marketing Platform API key, password and...
Connection Configuration for Slack
summary This is the help page for setting up Connection Configuration for Slack. entry
Connection Configuration for Snowflake
summary Help page for creating a Connection Configuration for Snowflake. In addition, users must be given roles with the necessary permissions before using Snowflake. For more information, see Permissions and Roles below. entry ...
Tableau Connection Configuration
summary This is the help page for setting up Connection Configuration for Tableau. Currently, TROCCO supports the execution of official Tableau Online page update tasks from the workflow function. advance preparation After logging in...
Connection Configuration for X Ads (Formerly Twitter Ads)
summary This is the help page for Connection Configuration for X Ads (Formerly Twitter Ads). Application for Advertising API To create a connection setup for X Ads (Formerly Twitter Ads), you will need a "developer account", a "Twitter applica...
Connection Configuration for Yahoo! Search Ads and Display Ads (managed)
summary This is the help page for Connection Configuration of Yahoo! Search Ads and Display Ads (managed). Search Ads and Display Ads (managed) can be authenticated by using the ID and password used to log in to Yahoo! 1. "Click on "Yahoo Acco...
Connection Configuration for Zendesk Support
summary This is the help page for setting up Connection Configuration for Zendesk Support. Termination of authentication by password access for API With the end of the provision of "password access to the API" ...
Connection Configuration for Zoho CRM
summary This is the help page for Connection Configuration in Zoho CRM. Create Connection Configuration using OAuth 2.0 Authentication. Prerequisite. You must create your own Zoho account. You must be logged in to create Connection Configur...
Connection Configuration for Next SFA
summary This is the help page for setting up Connection Configuration for Next SFA. How to obtain an API key Go to the Basic Settings → Client Settings screen. An API key is issued by turning on API usage. How to obtain an API toke...
Notes on referencing BigQuery tables generated from SpreadSheets
summary Google BigQuery tables generated from Google Sheets must be referenced with Connection Configuration using a service account with the appropriate permissions. The BigQuery tables generated from Google Sheets cannot be referenced with OAu...
Connecting via SSH Tunnel
summary By creating an SSH tunnel between TROCCO and a server provided by the customer, it is possible to connect to the customer's data source via the SSH tunnel. The following Connection Configuration is supported. Amazon Aurora MySQL Ama...
Obtain Google Cloud JSON Key
summary This help page explains the steps to create a JSON Key in Google Cloud. Connection Configuration must be created when connecting TROCCO to Google services such as Google Analytics 4 and Google Sheets. Please refer to this page when crea...
Connection Configuration for Databricks
Summary This will be a help page for creating Connection Configuration for Databricks. Entry Required Authority Databricks must grant the appropriate permissions to the user who issued the Personal Access Token . When using ETL Confi...
Connection Configuration for ValueCommerce
summary This is a help page on the procedure for using ValueCommerce with TROCCO. entry Basic Information
freee accounting connection information
summary Help page for creating freee accounting connection information. Please refer to the free API tutorial for detailed explanations and other information. Prerequisite. You will need to log in with your freee account. entry freee ...