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
Data Sources
75 Articles
in this category
Share this
Print
Share
Contents
Data Sources
75 Articles
in this category
Share
Data Source - A8.net
summary Help page for ETL Configuration of A8.net Report Data Settings. Setting items STEP1 Basic settings
Data Source - Adobe Marketo Engage
summary Help page for ETL Configuration of Data Settings for Adobe Marketo Engage. constraints In order to use the filter on the renewal date, you need to apply for API function activation to the Marketo Support Desk. Please apply for activ...
Data Source - Amazon Aurora MySQL
summary Help Page for ETL Configuration of Data Settings from Amazon Aurora MySQL. Unlike normal MySQL transfers, Aurora outputs a temporary CSV file to S3 and reads the CSV file for the transfer. Compared to the usual MySQL transfer method, th...
Data Source - Amazon CloudWatch Logs
summary This is a help page for ETL Configuration of Log Data Settings managed by Amazon CloudWatch Logs. constraints none in particular Setting items STEP1 Basic settings
Data Source - Amazon DynamoDB
summary Help page for ETL Configuration for transferring items from Amazon DynamoDB. Setting items STEP1 Basic settings
Data Source - Amazon Redshift
summary Help Page for ETL Configuration of Data Settings from Amazon Redshift. constraints none in particular STEP1 Basic settings STEP1 detailed settings Click on Set Details to display the configuration items. ...
Data Source - Amazon S3
summary Help Page for ETL Configuration of Data Settings from Amazon Web Services S3. constraints Limited transfer capacity Setting items STEP1 Basic settings STEP2 Detailed settings
Data Source - App Store Connect API
summary Help Page for ETL Configuration of Report Data Setting from the App Store. Obtainable data Data is retrieved using the App Store Connect API . Financial Reporting" and "Sales and Trends" are available. Each of these reports can be ...
Data Source - Apple Search Ads
summary Help Page for ETL Configuration of Report Data Settings for Apple Search Ads. Setting items STEP1 Basic settings Conditions for data acquisition period There is a limit to the period of time that can be specified for data acqui...
Data Source - AppsFlyer
summary Help page for ETL Configuration to be forwarded from AppsFlyer. Setting items STEP1 Basic settings Regarding data acquisition period Start Date If no time (HH:mm:ss) is specified, 00:00:00 o...
Data Source - Amazon Athena
summary Help Page for ETL Configuration of Data Settings from Amazon Athena. constraints https://github.com/shinji19/embulk-input-athena Setting items STEP1 Basic settings Required Authority The following permissions are required to...
Data Source - Azure Blob Storage
summary Help Page for ETL Configuration of Data Settings from Azure Blob Storage. constraints none in particular Setting items STEP1 Basic settings STEP2 Detailed settings
Data Source - Google BigQuery
summary Help Page for ETL Configuration of Data Settings from Google Cloud Platform's BigQuery. constraints Limited transfer capacity I cannot execute a query against a table with Spreadsheets as an external table. Setting items ST...
Data Source - Box
summary Help Page for ETL Configuration of Data Setting from Box. constraints Some of the Box API tokens, codes, and URLs have an expiration date. See Token and URL Expiration Dates for more information. Expiration date of...
Data Source - Cisco Secure Endpoint
summary Help Page for ETL Configuration of Cisco Secure Endpoint Data Settings. Setting items STEP1 Basic settings Example of data sample for preview [ { "event": "create", "audit_log_type": "Group", "audit_log_id": "eeaaea2b-7bcb-4263...
Data Source - Criteo
summary Help page for ETL Configuration to be forwarded from Criteo. constraints none in particular Setting items STEP1 Basic settings Report type: statistics Report type: transaction_ids
Data Source - CrowdStrike
summary Help Page for ETL Configuration of Data Setting from CrowdStrike. constraints none in particular Setting items STEP1 Basic settings
Data Source - Databricks
Summary This is a help page for ETL Configuration of Data Settings for ETL Configuration from Databricks. Available Cloud Environments Data Source and Data Destination Databricks is available in any of the foll...
Data Source - Elasticsearch
summary Help Page for Data Settings for ETL Configuration from Elasticsearch. Setting items STEP1 Basic settings
Data Source - e-Sales Manager
summary Help Page for ETL Configuration of Data Setting from e-Sales Manager. Setting items STEP1 Basic settings SearchCondition (search query) entry example:. Search and extraction of business card entities The following search queries...
Data Source - Facebook Ad Creative
summary Help Page for ETL Configuration for Retrieving and ETL Configuration of Creative Data for Facebook Ads. constraints Transfers may fail due to access token expiration or other causes. Please re-authenticate with the help of Facebook'...
Data Source - Facebook Lead Ads
summary Help Page for ETL Configuration of Getting Facebook Lead Ads and Data Setting. constraints Transfers may fail due to access token expiration or other causes. Please re-authenticate with the help of Facebook's Connection Configuratio...
Data Source - Facebook Ad Insights
summary This is a help page for ETL Configuration for acquiring Facebook Ads results and Data Setting. Obtaining data from Instagram ads Instagram ad results can also be obtained from the Data Source Facebook Ad...
Transfer source - freee accounting
summary Help page for setting up data transfer from freee accounting. Please refer to the free accounting API reference for detailed explanations and other information. Obtain business office ID The company ID...
Data Source - FTP/FTPS
summary Help Page for ETL Configuration of Data Setting using FTP/FTPS. constraints none in particular Setting items STEP1 Basic settings
Data Source - GitHub GraphQL API
summary Help page for Data Settings using GitHub API v4 (GraphQL) for ETL Configuration. Using the GitHub GraphQL API v4 (GraphQL), you can write a GraphQL query to get the results of various queries as JSON records. Obtainable data All item...
Data Source - Google Ad Manager
summary This is a help page for ETL Configuration of Data Settings managed by Google Ad Manager. constraints Error in execution of ETL Job due to compatibility of items to be acquired Dimension dimension att...
Data Source - Google Ads
summary This is a help page for ETL Configuration of Google Ads (Google Ads) Track Record and Data Setting. Regarding destructive changes associated with the release On Wednesday, May 22, 2024, between 10:00 am...
Data Source - Google AdSense
summary This is a help page for ETL Configuration of Data Settings managed by Google AdSense. Setting items STEP1 Basic settings
Data Source - 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 ...
Data Source - Google Analytics 4
summary Help Page for ETL Configuration of Report Data Setting from Google Analytics 4. constraints Data Sampling Google Analytics 4 has a Data Setting limit on the amount of data that can be collected by a pr...
Data Source - Google Cloud Spanner
summary Help Page for ETL Configuration of Data Settings from Google Cloud Spanner. constraints BYTES type is not supported. Setting items STEP1 Basic settings
Data Source - Google Cloud Storage
summary Help Page for ETL Configuration of Data Settings from Google Cloud Storage on Google Cloud Platform. constraints Limited transfer capacity Setting items STEP1 Basic settings STEP1 detailed settings Click on Set Detail...
Data Source - Google Drive
summary Help Page for ETL Configuration of Data Setting from Google Drive . Various files in a folder can be transferred. Target file format CSV/TSV JSON Lines JSONPath LTSV Microsoft Excel (xlsx or xls file) Setting items...
Data Source - Google Play
summary Help Page for ETL Configuration of Report Data Setting from Google Play. Obtainable data You can retrieve Google Play report data generated in Google Cloud Storage. Reports are generated daily and aggregated in CSV files on a monthl...
Data Source - Google Search Console
summary This is a help page for ETL Configuration of Data Settings managed by Google Search Console. constraints Data that can be transferred Only data older than 3 days can be transferred, starting from the...
Data Source - Google Sheets
summary Help Page for ETL Configuration of Data Setting from Google Sheets. constraints Restrictions on cell display format In Data Source Google Sheets, values are transferred with Display Format > Numb...
Data Source - HTTP/HTTPS
summary This is a help page for Data Setting to retrieve data from HTTP/HTTPS protocol web services. constraints Restriction on connections using OAuth 2.0 The following restrictions apply when using OAuth 2.0...
Data Source - DataSpot
summary Help Page for ETL Configuration of Data Setting from HubSpot. constraints Additional information when using custom properties Data Source HubSpot obtains some of the metadata on the HubSpot side and ...
Data Source - JIRA
summary Help page for ETL Configuration of Data Settings for JIRA Software. constraints none in particular Setting items STEP1 Basic settings STEP1 detailed settings Click on Set Details to display the configuration items. ...
Data Source - KARTE Datahub
summary Help Page for ETL Configuration of Data Setting from KARTE Datahub. For settings on the KARTE Datahub side, see External Service Integration (TROCCO). Setting items STEP1 Basic settings
Data Source - kintone
summary Help page for ETL Configuration of Data Setting from Cybozu's kintone. constraints Because the cursor API is used, specifying a limit or offset clause in the query will result in an error when retrieving data. Any matches to the quer...
Data Source - LINE Ads
summary This is the help page for ETL Configuration of Report Data Settings for LINE Ads (formerly Line Ads Platform). Setting items STEP1 Basic settings Performance Report Requests when setting up custom conversions ...
Data Source - Microsoft SQL Server
summary Help Page for ETL Configuration of Data Setting from Microsoft SQL Server. constraints The SELECT privilege for the object to be transferred must be granted to the Connection Configuration user used for ETL Configuration. (e.g., db...
Data Source - Microsoft Advertising
This is the Help Page for ETL Configuration of Data Setting from Microsoft Advertising. constraints none in particular Setting items STEP1 Basic settings Time zone of data acquisition period The ti...
Data Source - MongoDB
summary Help page for ETL Configuration from MongoDB. constraints none in particular Setting items STEP1 Basic settings
Data Source - MySQL
summary Help Page for ETL Configuration of Data Setting from MySQL. constraints Supported versions of MariaDB We have confirmed the following versions of MariaDB. v11.0 : Transfer is not supported. v11...
Data Source - MySQL binlog (CDC)
summary Help page for ETL Configuration of Data Setting from MySQL (binlog). constraints none in particular Setting items STEP1 Basic settings
Data Source - Oracle Database
summary Help page for ETL Configuration from Oracle Database. Setting items STEP1 Basic settings STEP1 detailed settings Clicking on "Set Details" will display the following configuration items fetch data type specification D...
Data Source - PostgreSQL
summary This is a help page for Data Settings for ETL Configuration from PostgreSQL. constraints none in particular Setting items STEP1 Basic settings STEP2 Detailed settings Data type that needs to be converted to string typ...
Data Source - RDBMS Version Support Chart
summary Corresponding table of driver versions used in the Data Source RDBMS-based Connector. supplement Microsoft SQL Server Compatibility The supported DB versions are as follows For more information, see the JDBC Driver for Microsoft...
Data Source - Repro
summary Help Page for ETL Configuration Settings for Repro's Event Data. Transfers uploads to Amazon Web Services S3. Setting items In order to use Repro as Data Source, it is necessary to obtain necessary information such as S3 bucket path ...
Data Source - Rtoaster insight+ with Google Account integration
summary Help page for ETL Configuration of Data Setting from Rtoaster insight+. Prerequisite. Rtoaster insight+ manages data with Google BigQuery, which is built on the Tokyo region (asia-northeast1) of the Google Cloud Platform (hereinafter r...
Data Source - RTB House
summary Help Page for ETL Configuration of RTB House's Report Data Settings. constraints When multiple sub-campaigns are registered in Data Source data The preview in ETL Configuration STEP 2 shows only one ar...
Data Source - Salesforce Report
summary Help page for ETL Configuration of Record Data Setting from Salesforce Report. constraints Only Connection Configuration for which User/Password Authentication is selected as the Authentication Method can be used. If there are mo...
Data Source - Salesforce
summary This is a help page for ETL Configuration of Data Destination of records managed in Salesforce, such as Opportunities, Leads, Business Partners, and Custom Objects. constraints Limited transfer capacity Setting items STEP1 Ba...
Data Source - Salesforce Marketing Cloud Account Engagement
summary This is a help page for ETL Configuration of Salesforce Marketing Cloud Account Engagement (formerly Pardot) Data Retrieval and Data Transfers. constraints Using Salesforce Marketing Cloud Account Engagement authentication linked wit...
Data Source - SFTP
summary Help Page for ETL Configuration of Data Setting from SFTP. constraints none in particular Setting items STEP1 Basic settings
Data Source - Shopify
summary Help Page for ETL Configuration of Shopify Data Settings. Setting items STEP1 Basic settings Available data metafield API Documentation: https://shopify.dev/api/admin-graphql/2024-01/objects/Metafield#fields schema tr...
Data Source - SHANON MARKETING PLATFORM
summary Help page for ETL Configuration of Report Data Setting from SHANON MARKETING PLATFORM. constraints none in particular Setting items STEP1 Basic settings Validity Conditions for Additional ...
Data Source - Slack
summary Help Page for ETL Configuration of Data Settings for Slack. Setting items STEP1 Basic settings
Data Source - Snowflake
summary Help Page for ETL Configuration of Data Setting from Snowflake. constraints BINARY type is not supported. We have confirmed the transfer of 10 GB worth of CSV data. Setting items STEP1 Basic settings
Data Source - Tableau CRM Analytics
summary This is the help page for ETL Configuration for Transferring Record Data from Tableau CRM Analytics. Setting items STEP1 Basic settings
Data Source - TikTok Ads
summary Help Page for ETL Configuration of Data Settings for TikTok Ads. Get daily reporting data for TikTok Ads . The report types that can be obtained are as follows Setting items STEP1 Basic settings
Data Source - Treasure Data
summary This is a help page for ETL Configuration of Data Settings for ETL Configuration of Data from Treasure Data. constraints none in particular Setting items STEP1 Basic settings
Data Source - X Ads (Formerly Twitter Ads)
summary Help Page for X Ads (Formerly Twitter Ads) Analytics Data Setting for ETL Configuration. Setting items STEP1 Basic settings STEP1 Detailed settings This can be specified when "card" is selected as the acquisition target. Clic...
Data Source - TROCCO Web Activity Log
summary Data Source TROCCO Web Activity Log can transfer data collected by the TROCCO Web Activity Log Collection SDK . This page describes the Data Source TROCCO Web Activity Log Configuration items. About TROCCO Web Activity ...
Data Source - TROCCO
summary Help page for ETL Configuration of Data Settings held in TROCCO. Data Source TROCCO can transfer any of the following data Data Catalog Metadata held in the Data Catalog can be transferred. ETL Configuration , Data Mart C...
Data Source - Yahoo! Display Ads (Managed)
summary Help Page for ETL Configuration of Data Settings for Data Transfer from Yahoo! Display Ads (Managed). YahooAdsAPI is used to retrieve data. constraints Limited transfer capacity Setting items STEP1 Basic settings ...
Data Source - ValueCommerce
summary This is the help page for ETL Configuration of ValueCommerce Data Settings. Obtainable data Retrieve the following items from the ValueCommerce API Affiliate Site :. List of detail (order detail information) fields Advertis...
Data Source - Yahoo! Search Ads
summary Help Page for ETL Configuration of Data Settings from Yahoo! Search Ads. YahooAdsAPI is used to retrieve data. constraints Limited transfer capacity Setting items STEP1 Basic settings If ReportDefinitionService is sel...
Data Source - Zendesk Support
summary This is the Help Page for ETL Configuration of ETL Configuration of Ticket and User Data in Zendesk Support. Setting items STEP1 Basic settings When tickets are selected as the data acquisition target When ticket_metrics ...
Data Source - Zoho CRM
summary Help Page for ETL Configuration of Data Settings from Zoho CRM. constraints There may be a limit to the number of records that can be transferred per day due to the specifications of Zoho CRM's API. Please refer to the official doc...
Data Source - Next SFA
summary Help page for ETL Configuration to be forwarded from Next SFA. Setting items STEP1 Basic settings
Data Source - Local Files
summary This is a help page for ETL Configuration for files that exist on your PC. This Connector should be used for file verification and testing of transfers. Data Source Local Files Specifications Files uplo...