Data Sources
- 120 Articles
summary
Help page for ETL Configuration of A8.net Report Data Settings.
Setting items
STEP1 Basic settings
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...
summary
Help Page for ETL Configuration of Data Settings from Amazon Athena.
constraints
https://github.com/trocco-io/embulk-input-athena
Setting items
STEP1 Basic settings
Required Authority
The following permissions are required t...
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
summary
Help page for ETL Configuration for transferring items from Amazon DynamoDB.
Setting items
STEP1 Basic settings
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.
...
summary
Help Page for ETL Configuration of Data Settings from Amazon Web Services S3.
Setting items
STEP1 Basic settings
STEP2 Detailed settings
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 ...
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...
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...
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
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...
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
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...
summary
Help Page for Data Settings for ETL Configuration from Elasticsearch.
Setting items
STEP1 Basic settings
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...
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'...
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...
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...
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...
summary
Help Page for ETL Configuration of Data Setting using FTP/FTPS.
constraints
none in particular
Setting items
STEP1 Basic settings
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...
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...
summary
This is a help page for ETL Configuration of Google Ads (Google Ads) Track Record and Data Setting.
constraints
For fields that can be specified
The specified value of a field from which data can be ...
summary
This is a help page for ETL Configuration of Data Settings managed by Google AdSense.
Setting items
STEP1 Basic settings
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
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...
summary
Help Page for ETL Configuration of Data Settings from Google Cloud Platform's BigQuery.
constraints
I cannot execute a query against a table with Spreadsheets as an external table.
Setting items
STEP1 Basic settings
STEP1 ...
summary
Help Page for ETL Configuration of Data Settings from Google Cloud Spanner.
constraints
BYTES type is not supported.
Setting items
STEP1 Basic settings
summary
Help Page for ETL Configuration of Data Settings from Google Cloud Storage on Google Cloud Platform.
Setting items
STEP1 Basic settings
STEP1 detailed settings
Click on Set Details to display the configuration items.
Requ...
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...
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...
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...
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...
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...
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 ...
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.
...
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
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...
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
...
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...
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...
summary
Help page for ETL Configuration from MongoDB.
constraints
none in particular
Setting items
STEP1 Basic settings
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...
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...
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...
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 ...
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...
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...
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...
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.
Setting items
STEP1 Basic settings
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...
summary
Help Page for ETL Configuration of Data Setting from SFTP.
constraints
none in particular
Setting items
STEP1 Basic settings
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 ...
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...
summary
Help Page for ETL Configuration of Data Settings for Slack.
Setting items
STEP1 Basic settings
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
summary
This is the help page for ETL Configuration for Transferring Record Data from Tableau CRM Analytics.
Setting items
STEP1 Basic settings
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
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
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...
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 ...
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...
summary
Help Page for ETL Configuration of Data Settings for Data Transfer from Yahoo! Display Ads (Managed).
YahooAdsAPI is used to retrieve data.
Setting items
STEP1 Basic settings
About columns
Due to...
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...
summary
Help Page for ETL Configuration of Data Settings from Yahoo! Search Ads.
YahooAdsAPI is used to retrieve data.
Setting items
STEP1 Basic settings
If ReportDefinitionService is selected
Loading report templa...
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 ...
This page describes the settings (ETL Configuration) for retrieving data from Zoho Books.
For connection settings, please refer to Zoho Books Connection Configuration .
Settings
STEP1 Basic Settings
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...
summary
Help page for ETL Configuration to be forwarded from Next SFA.
Setting items
STEP1 Basic settings
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...
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...