Connection Configurations
- 111 Articles
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...
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...
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...
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 ...
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...
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...
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 ...
summary
This is the help page for setting up Connection Configuration for Azure Synapse Analytics.
entry
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 ...
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...
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...
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...
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...
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 ...
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.
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....
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 ...
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...
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...
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 >...
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...
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...
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 ...
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 ...
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...
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...
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 ...
summary
This is the help page for setting up HubSpot's Connection Configuration.
Setting items
elementary item
How to obtain setting item information
OAuth Authentication Procedure
Authorization required for OAuth auth...
summary
This is the help page for setting up Connection Configuration in JIRA.
entry
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...
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...
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 ...
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...
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...
summary
This is a help page for setting up Connection Configuration for Microsoft SQL Server.
entry
summary
This is the help page for setting up Connection Configuration for MySQL.
entry
When SSL is enabled
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
summary
This is the help page for Connection Configuration of PostgreSQL.
entry
When SSL is enabled
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.
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 ...
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...
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...
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...
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...
summary
This is the help page for setting up Connection Configuration for Slack.
entry
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
...
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...
summary
This is a help page on the procedure for using ValueCommerce with TROCCO.
entry
Basic Information
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...
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...
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" ...
This page describes the settings (Connection Configuration) for connecting to Zoho Books.
For information on transfer settings, see Data Source - Zoho Books .
Notes and Restrictions on Use
Available Data Center
As of January 2025, TROCCO...
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...
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...
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 Redshift
Azure S...
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...
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...