Data Sources

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 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...

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. constraints Limited transfer capacity 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 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 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 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...

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 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...

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 Help Page for ETL Configuration of Data Setting from CrowdStrike. constraints none in particular Setting items STEP1 Basic settings

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 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. constraints Limited transfer capacity Setting items STEP1 Basic settings STEP1 detailed settings Click on Set Detail...

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 ...

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...

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 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 of Data Setting from MySQL (binlog). constraints none in particular Setting items STEP1 Basic settings

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 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...

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. constraints Limited transfer capacity Setting items STEP1 Ba...

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. constraints Limited transfer capacity Setting items STEP1 Basic settings ...

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. constraints Limited transfer capacity Setting items STEP1 Basic settings If ReportDefinitionService is sel...

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...