# Integrate.io

## Docs

- [Create Account](https://www.integrate.io/docs/api-reference/accounts/create-account.md)
- [Delete Account](https://www.integrate.io/docs/api-reference/accounts/delete-account.md)
- [Get Current Account](https://www.integrate.io/docs/api-reference/accounts/get-current-account.md): Returns the current account information.
- [List Accounts](https://www.integrate.io/docs/api-reference/accounts/list-accounts.md): Returns accounts the authenticated user has access to.
- [Update Account](https://www.integrate.io/docs/api-reference/accounts/update-account.md)
- [Get Account Payment Method](https://www.integrate.io/docs/api-reference/billing/get-account-payment-method.md)
- [Get Invoice Information](https://www.integrate.io/docs/api-reference/billing/get-invoice-information.md)
- [Get Subscription Information](https://www.integrate.io/docs/api-reference/billing/get-subscription-information.md)
- [List Invoices](https://www.integrate.io/docs/api-reference/billing/list-invoices.md)
- [Create Cluster](https://www.integrate.io/docs/api-reference/clusters/create-cluster.md): Creates a new cluster. A cluster is a group of machines (nodes) allocated exclusively to your account. You will need an active cluster to run jobs.
- [Get Cluster Information](https://www.integrate.io/docs/api-reference/clusters/get-cluster-information.md): Returns details for the specified cluster, including its status.
- [List Clusters](https://www.integrate.io/docs/api-reference/clusters/list-clusters.md): Returns a list of clusters associated with the authenticated account.
- [Search Clusters](https://www.integrate.io/docs/api-reference/clusters/search-clusters.md): Search clusters by name or description.
- [Terminate Cluster](https://www.integrate.io/docs/api-reference/clusters/terminate-cluster.md): Terminates the specified cluster, releasing its resources. Use this when all jobs on the cluster are completed.
- [Update Cluster](https://www.integrate.io/docs/api-reference/clusters/update-cluster.md): Updates the specified cluster's settings, such as name, description, or node count.
- [Watch Cluster](https://www.integrate.io/docs/api-reference/clusters/watch-cluster.md): Subscribe to notifications for the specified cluster.
- [Create Connection](https://www.integrate.io/docs/api-reference/connections/create-connection.md): Creates a new connection to a data source or destination.
- [Delete Connection](https://www.integrate.io/docs/api-reference/connections/delete-connection.md)
- [Get Connection Information](https://www.integrate.io/docs/api-reference/connections/get-connection-information.md)
- [Import Connection Schema](https://www.integrate.io/docs/api-reference/connections/import-connection-schema.md): Retrieves the schema (tables, columns) from the specified connection.
- [List Bing Ads Accounts](https://www.integrate.io/docs/api-reference/connections/list-bing-ads-accounts.md)
- [List Bing Ads Columns](https://www.integrate.io/docs/api-reference/connections/list-bing-ads-columns.md)
- [List Connection Types](https://www.integrate.io/docs/api-reference/connections/list-connection-types.md): Returns the list of available connection types.
- [List Connections](https://www.integrate.io/docs/api-reference/connections/list-connections.md): Returns all connections in the account.
- [List Facebook Ads Insights Accounts](https://www.integrate.io/docs/api-reference/connections/list-facebook-ads-insights-accounts.md)
- [List Facebook Ads Insights Fields](https://www.integrate.io/docs/api-reference/connections/list-facebook-ads-insights-fields.md)
- [List Google AdWords Customers](https://www.integrate.io/docs/api-reference/connections/list-google-adwords-customers.md)
- [List Google Analytics Accounts](https://www.integrate.io/docs/api-reference/connections/list-google-analytics-accounts.md)
- [List Salesforce Fields](https://www.integrate.io/docs/api-reference/connections/list-salesforce-fields.md)
- [List Salesforce Objects](https://www.integrate.io/docs/api-reference/connections/list-salesforce-objects.md)
- [Test Connection](https://www.integrate.io/docs/api-reference/connections/test-connection.md): Tests the specified existing connection to verify it can connect.
- [Test New Connection](https://www.integrate.io/docs/api-reference/connections/test-new-connection.md): Tests a new connection before creating it.
- [Update Connection](https://www.integrate.io/docs/api-reference/connections/update-connection.md)
- [Validate Connection](https://www.integrate.io/docs/api-reference/connections/validate-connection.md): Validates the specified connection's configuration.
- [Create Delivery](https://www.integrate.io/docs/api-reference/deliveries/create-delivery.md): Creates a new data delivery blueprint.
- [Delete Delivery](https://www.integrate.io/docs/api-reference/deliveries/delete-delivery.md)
- [Get Delivery Information](https://www.integrate.io/docs/api-reference/deliveries/get-delivery-information.md)
- [List Deliveries](https://www.integrate.io/docs/api-reference/deliveries/list-deliveries.md): Returns all deliveries in the account.
- [Create Hook](https://www.integrate.io/docs/api-reference/hooks/create-hook.md)
- [Delete Hook](https://www.integrate.io/docs/api-reference/hooks/delete-hook.md)
- [Get Hook Information](https://www.integrate.io/docs/api-reference/hooks/get-hook-information.md)
- [List Hook Types](https://www.integrate.io/docs/api-reference/hooks/list-hook-types.md): Returns available webhook event types.
- [List Hooks](https://www.integrate.io/docs/api-reference/hooks/list-hooks.md)
- [Ping Hook](https://www.integrate.io/docs/api-reference/hooks/ping-hook.md): Sends a test ping to the specified webhook.
- [Reset Hook Salt](https://www.integrate.io/docs/api-reference/hooks/reset-hook-salt.md): Resets the signing salt for the specified webhook.
- [Search Hooks](https://www.integrate.io/docs/api-reference/hooks/search-hooks.md)
- [Update Hook](https://www.integrate.io/docs/api-reference/hooks/update-hook.md)
- [Get Job Execution Variables](https://www.integrate.io/docs/api-reference/jobs/get-job-execution-variables.md): Returns the execution variables for the specified job.
- [Get Job Information](https://www.integrate.io/docs/api-reference/jobs/get-job-information.md): Returns details for the specified job, including status, progress, and outputs.
- [List Job Children](https://www.integrate.io/docs/api-reference/jobs/list-job-children.md): Returns child jobs of the specified job.
- [List Jobs](https://www.integrate.io/docs/api-reference/jobs/list-jobs.md): Returns a list of jobs associated with the authenticated account.
- [Preview Job Output](https://www.integrate.io/docs/api-reference/jobs/preview-job-output.md): Returns a preview of the specified job output.
- [Run Job](https://www.integrate.io/docs/api-reference/jobs/run-job.md): Creates and runs a new job. You must specify the cluster to run on and the package whose workflow the job should perform. You can also pass static and dynamic variables.
- [Search Jobs](https://www.integrate.io/docs/api-reference/jobs/search-jobs.md): Search jobs by various criteria.
- [Terminate Job](https://www.integrate.io/docs/api-reference/jobs/terminate-job.md): Terminates the specified job, stopping its execution and releasing resources.
- [Watch Job](https://www.integrate.io/docs/api-reference/jobs/watch-job.md): Subscribe to notifications for the specified job.
- [Add Account Member](https://www.integrate.io/docs/api-reference/members/add-account-member.md)
- [Get Account Member Information](https://www.integrate.io/docs/api-reference/members/get-account-member-information.md)
- [List Account Members](https://www.integrate.io/docs/api-reference/members/list-account-members.md)
- [Remove Account Member](https://www.integrate.io/docs/api-reference/members/remove-account-member.md)
- [Update Account Member Role](https://www.integrate.io/docs/api-reference/members/update-account-member-role.md)
- [List User Notifications](https://www.integrate.io/docs/api-reference/notifications/list-user-notifications.md)
- [Mark Notifications as Read](https://www.integrate.io/docs/api-reference/notifications/mark-notifications-as-read.md)
- [Get Package Validation Information](https://www.integrate.io/docs/api-reference/package-validations/get-package-validation-information.md): Returns the status and result of a specific package validation.
- [List Package Validations](https://www.integrate.io/docs/api-reference/package-validations/list-package-validations.md): Returns a list of validations for the specified package.
- [Run Package Validation](https://www.integrate.io/docs/api-reference/package-validations/run-package-validation.md): Initiates an asynchronous validation of the specified package.
- [Run Package Validation (Synchronous)](https://www.integrate.io/docs/api-reference/package-validations/run-package-validation-synchronous.md): Runs a synchronous validation of the specified package and waits for the result.
- [Create Package](https://www.integrate.io/docs/api-reference/packages/create-package.md): Creates a new data flow package.
- [Delete Package](https://www.integrate.io/docs/api-reference/packages/delete-package.md): Deletes the specified package.
- [Export Package as JSON](https://www.integrate.io/docs/api-reference/packages/export-package-as-json.md): Exports the specified package definition as JSON.
- [Get Package Information](https://www.integrate.io/docs/api-reference/packages/get-package-information.md): Returns details for the specified package.
- [List Packages](https://www.integrate.io/docs/api-reference/packages/list-packages.md): Returns the list of packages in the account.
- [Search Packages](https://www.integrate.io/docs/api-reference/packages/search-packages.md): Search packages by name or description.
- [Update Package](https://www.integrate.io/docs/api-reference/packages/update-package.md): Updates the specified package.
- [Create Public Key](https://www.integrate.io/docs/api-reference/public-keys/create-public-key.md)
- [Delete Public Key](https://www.integrate.io/docs/api-reference/public-keys/delete-public-key.md)
- [Get Public Key Information](https://www.integrate.io/docs/api-reference/public-keys/get-public-key-information.md)
- [List User Public Keys](https://www.integrate.io/docs/api-reference/public-keys/list-user-public-keys.md)
- [Create Schedule](https://www.integrate.io/docs/api-reference/schedules/create-schedule.md): Creates a new schedule to run packages periodically.
- [Delete Schedule](https://www.integrate.io/docs/api-reference/schedules/delete-schedule.md): Deletes the specified schedule.
- [Get Schedule Information](https://www.integrate.io/docs/api-reference/schedules/get-schedule-information.md): Returns details for the specified schedule.
- [List Schedules](https://www.integrate.io/docs/api-reference/schedules/list-schedules.md): Returns all schedules in the account.
- [Run Schedule](https://www.integrate.io/docs/api-reference/schedules/run-schedule.md): Manually triggers the specified schedule to run immediately.
- [Search Schedules](https://www.integrate.io/docs/api-reference/schedules/search-schedules.md)
- [Update Schedule](https://www.integrate.io/docs/api-reference/schedules/update-schedule.md): Updates the specified schedule.
- [Watch Schedule](https://www.integrate.io/docs/api-reference/schedules/watch-schedule.md): Subscribe to notifications for the specified schedule.
- [Get Rate Limit Status](https://www.integrate.io/docs/api-reference/system/get-rate-limit-status.md): Returns current rate limit status. This call does not count against your rate limit.
- [Help](https://www.integrate.io/docs/api-reference/system/help.md): Returns API help information and available endpoints.
- [List Available Account Regions](https://www.integrate.io/docs/api-reference/system/list-available-account-regions.md)
- [List Available Regions](https://www.integrate.io/docs/api-reference/system/list-available-regions.md)
- [List Product Updates](https://www.integrate.io/docs/api-reference/system/list-product-updates.md)
- [List Supported Stacks](https://www.integrate.io/docs/api-reference/system/list-supported-stacks.md)
- [List Supported Time Zones](https://www.integrate.io/docs/api-reference/system/list-supported-time-zones.md)
- [List System Variables](https://www.integrate.io/docs/api-reference/system/list-system-variables.md)
- [Get Authenticated User Information](https://www.integrate.io/docs/api-reference/users/get-authenticated-user-information.md)
- [Regenerate Authenticated User Tokens](https://www.integrate.io/docs/api-reference/users/regenerate-authenticated-user-tokens.md): Regenerates the API key for the authenticated user.
- [Reset User Password](https://www.integrate.io/docs/api-reference/users/reset-user-password.md)
- [Update Authenticated User](https://www.integrate.io/docs/api-reference/users/update-authenticated-user.md)
- [ELT & CDC Documentation](https://www.integrate.io/docs/cdc.md): Replicate data in near real-time with Integrate.io ELT & CDC. Connect 60+ sources to Snowflake, Redshift, BigQuery, and S3 using change data capture.
- [Adobe Analytics source for ELT & CDC](https://www.integrate.io/docs/cdc/adobe-analytics.md): Configure Adobe Analytics as a data source in Integrate.io ELT & CDC. Connect your analytics data for automated replication to your warehouse.
- [AdRoll source for ELT & CDC](https://www.integrate.io/docs/cdc/adroll.md): Configure AdRoll as a data source in Integrate.io ELT & CDC. Replicate display ad, social media, and email campaign data to your warehouse.
- [Airtable source for ELT & CDC](https://www.integrate.io/docs/cdc/airtable.md): Configure Airtable as a data source in Integrate.io ELT & CDC. Replicate your Airtable bases and tables to your data warehouse automatically.
- [Algolia source for ELT & CDC](https://www.integrate.io/docs/cdc/algolia.md): Configure Algolia as a data source in Integrate.io ELT & CDC. Replicate your Algolia search analytics and index data to your data warehouse.
- [Amazon Ads source for ELT & CDC](https://www.integrate.io/docs/cdc/amazon-ads.md): Configure Amazon Ads as a data source in Integrate.io ELT & CDC. Sync advertising campaign and performance data to your data warehouse.
- [Amazon Marketplace source for ELT & CDC](https://www.integrate.io/docs/cdc/amazon-marketplace.md): Configure Amazon Marketplace as a source in Integrate.io ELT & CDC. Replicate orders, inventory, and seller data to your data warehouse.
- [Amazon RDS MySQL source for ELT & CDC](https://www.integrate.io/docs/cdc/amazon-rds-mysql.md): How to configure Amazon RDS MySQL as a CDC source in Integrate.io ELT & CDC, including read-replica setup, user creation, and binary log configuration.
- [Amazon RDS PostgreSQL source for ELT & CDC](https://www.integrate.io/docs/cdc/amazon-rds-postgresql.md): How to configure Amazon RDS PostgreSQL as a CDC source in Integrate.io ELT & CDC, including logical replication, role setup, and table ownership.
- [Amazon Redshift destination for ELT & CDC](https://www.integrate.io/docs/cdc/amazon-redshift.md): Configure Amazon Redshift as a destination in Integrate.io ELT & CDC. Set up your Redshift cluster to receive replicated data from sources.
- [ELT/CDC: Archiving Unused Source and Destination](https://www.integrate.io/docs/cdc/archiving-unused-source-and-destination.md): Archive unused sources and destinations in Integrate.io ELT & CDC. Clean up your workspace by removing inactive pipeline connections.
- [Aurora MySQL source for ELT & CDC](https://www.integrate.io/docs/cdc/aurora-mysql.md): Configure Aurora MySQL as a data source in Integrate.io ELT & CDC. Set up binary log replication from your Aurora MySQL database instances.
- [Aurora PostgreSQL source for ELT & CDC](https://www.integrate.io/docs/cdc/aurora-postgresql.md): Configure Aurora PostgreSQL as a source in Integrate.io ELT & CDC. Set up logical replication from your Aurora PostgreSQL database instances.
- [ELT/CDC: Auto Sync New Tables Feature](https://www.integrate.io/docs/cdc/auto-sync-new-tables-feature.md): Configure the Integrate.io ELT & CDC Auto Sync New Tables feature to automatically detect and replicate newly created source tables without manual setup.
- [ELT/CDC: Available Metrics Types](https://www.integrate.io/docs/cdc/available-metrics-types.md): Explore the available metric types in Integrate.io ELT & CDC monitoring. Track replication delay, sync lag, and pipeline health indicators.
- [Replication delay metric in ELT & CDC](https://www.integrate.io/docs/cdc/available-metrics-types-replication-delay.md): How the Replication Delay metric measures the time since data was last copied from S3 to the destination in Integrate.io ELT & CDC.
- [Sync lag metric in ELT & CDC](https://www.integrate.io/docs/cdc/available-metrics-types-sync-lag-metric.md): Understand the Sync Lag metric in Integrate.io ELT & CDC, how it tracks data volume differences between source and pipeline, and how to interpret values.
- [AWS RDS Oracle source for ELT & CDC](https://www.integrate.io/docs/cdc/aws-rds-oracle.md): Configure AWS RDS Oracle as a data source in Integrate.io ELT & CDC. Set up change data capture from your RDS Oracle database instances.
- [Azure MySQL source for ELT & CDC](https://www.integrate.io/docs/cdc/azure-mysql.md): How to configure Azure MySQL as a CDC source in Integrate.io ELT & CDC, including read-replica setup, user creation, and binary logging.
- [Azure PostgreSQL source for ELT & CDC](https://www.integrate.io/docs/cdc/azure-postgresql.md): Configure Azure Database for PostgreSQL as a source in Integrate.io ELT & CDC. Set up logical replication from your Azure PostgreSQL instances.
- [BigCommerce source for ELT & CDC](https://www.integrate.io/docs/cdc/bigcommerce.md): ELT & CDC uses the Management APIs provided by BigCommerce to sync the data. We typically use the V3 version of the API but fallback to V2 wherever applicable.
- [BigQuery destination for ELT & CDC](https://www.integrate.io/docs/cdc/bigquery.md): Configure Google BigQuery as a destination in Integrate.io ELT & CDC. Set up your BigQuery dataset to receive replicated source data.
- [BigQuery source for ELT & CDC](https://www.integrate.io/docs/cdc/bigquery-source.md): Configure Google BigQuery as a data source in Integrate.io ELT & CDC. Replicate BigQuery datasets and tables to other warehouse destinations.
- [Bing Ads source for ELT & CDC](https://www.integrate.io/docs/cdc/bing-ads.md): Configure Bing Ads as a data source in Integrate.io ELT & CDC. Sync your Microsoft Advertising campaign and performance data to your warehouse.
- [Braintree source for ELT & CDC](https://www.integrate.io/docs/cdc/braintree.md): Configure Braintree as a data source in Integrate.io ELT & CDC. Replicate payment transactions and customer data to your data warehouse.
- [ELT/CDC: All Articles](https://www.integrate.io/docs/cdc/category/all-articles.md): Complete index of all Integrate.io ELT & CDC documentation articles, covering sources, destinations, monitoring, security, and data observability.
- [ELT/CDC: Data Observability](https://www.integrate.io/docs/cdc/category/data-observability.md): Monitor data quality and pipeline health with Integrate.io Data Observability. Set up metrics, alerts, and data stores for replication monitoring.
- [ELT/CDC: Destinations](https://www.integrate.io/docs/cdc/category/destinations.md): Configure destinations in Integrate.io ELT & CDC. Load replicated data to Amazon Redshift, Snowflake, Google BigQuery, or Amazon S3.
- [ELT/CDC: Getting Started](https://www.integrate.io/docs/cdc/category/getting-started.md): Get started with Integrate.io ELT & CDC. Learn about change data capture, initial sync, schema changes, history mode, and key platform features.
- [ELT/CDC: Monitoring](https://www.integrate.io/docs/cdc/category/monitoring.md): Monitor your Integrate.io ELT & CDC pipelines. View data type mappings, track type changes across destinations, and configure alert hooks.
- [ELT/CDC: Security](https://www.integrate.io/docs/cdc/category/security.md): Secure your Integrate.io ELT & CDC connections with IP allowlists, AWS PrivateLink for MySQL and PostgreSQL, and SSH tunnel configurations.
- [ELT/CDC: Sources](https://www.integrate.io/docs/cdc/category/sources.md): Connect to 60+ data sources in Integrate.io ELT & CDC. Set up CDC from PostgreSQL, MySQL, SQL Server, Oracle, Salesforce, Shopify, and more.
- [ELT/CDC: Transforms](https://www.integrate.io/docs/cdc/category/transforms.md): Apply data transformations during replication in Integrate.io ELT & CDC. Use replacement rules and surrogate keys to modify data during sync.
- [ELT/CDC: Configure S3 bucket for Redshift sync](https://www.integrate.io/docs/cdc/configure-your-own-s3-bucket-for-redshift-sync.md): How to set up and configure Amazon Redshift - Configure your own S3 bucket for Redshift Sync as a destination in Integrate.io ELT & CDC.
- [ELT/CDC: Custom Primary Key Feature](https://www.integrate.io/docs/cdc/custom-primary-key-feature.md): Use the custom primary key feature to sync tables without a primary key in Integrate.io ELT & CDC. Define surrogate keys for keyless tables.
- [Cybersource source for ELT & CDC](https://www.integrate.io/docs/cdc/cybersource.md): Configure CyberSource as a data source in Integrate.io ELT & CDC. Replicate payment processing and transaction data to your data warehouse.
- [Data observability alerts in ELT & CDC](https://www.integrate.io/docs/cdc/data-observability-alerts.md): Set up Data Observability alerts in Integrate.io to automatically monitor data quality. Configure metric thresholds and notification rules.
- [Data observability FAQs in ELT & CDC](https://www.integrate.io/docs/cdc/data-observability-faqs.md): Frequently asked questions about Data Observability in Integrate.io. Learn how metrics are collected, scheduled, and monitored for quality.
- [Getting started with data observability](https://www.integrate.io/docs/cdc/data-observability-getting-started.md): This guide will show how to set up an alert metric, define its threshold and receive an alert if it falls outside of this threshold.
- [Data observability metrics in ELT & CDC](https://www.integrate.io/docs/cdc/data-observability-metrics.md): Define and configure Data Observability metrics in Integrate.io. Track data quality measures for your warehouse tables and pipeline outputs.
- [Data stores in ELT & CDC observability](https://www.integrate.io/docs/cdc/data-stores.md): View the supported databases and data warehouses for Data Observability monitoring in Integrate.io, including Snowflake, Redshift, and BigQuery.
- [Data type changes for Redshift in ELT & CDC](https://www.integrate.io/docs/cdc/data-type-changes-redshift.md): If the data type mapping differs on the Redshift side, the following section explains how these changes will be handled by the automatic replication feature.
- [Data type changes for Snowflake in ELT & CDC](https://www.integrate.io/docs/cdc/data-type-changes-snowflake.md): Reference for data type mappings from database sources to Snowflake in Integrate.io ELT & CDC. Understand how types are converted during sync.
- [Data type mapping for BigQuery in ELT & CDC](https://www.integrate.io/docs/cdc/data-type-mapping-bigquery.md): Reference for data type mappings from database sources to Google BigQuery in Integrate.io ELT & CDC. Understand type conversions during sync.
- [Data type mapping for Redshift in ELT & CDC](https://www.integrate.io/docs/cdc/data-type-mapping-redshift.md): Reference for data type mappings from database sources to Amazon Redshift in Integrate.io ELT & CDC. Understand type conversions during sync.
- [Data type mapping across warehouses in ELT & CDC](https://www.integrate.io/docs/cdc/data-type-mapping-redshift-snowflake-and-bigquery.md): Overview of data type mappings across Redshift, Snowflake, and BigQuery destinations in Integrate.io ELT & CDC. Compare type conversions.
- [Data type mapping for Snowflake in ELT & CDC](https://www.integrate.io/docs/cdc/data-type-mapping-snowflake.md): Reference for data type mappings from database sources to Snowflake in Integrate.io ELT & CDC. Understand how source types map on replication.
- [Delighted source for ELT & CDC](https://www.integrate.io/docs/cdc/delighted.md): Configure Delighted as a data source in Integrate.io ELT & CDC. Replicate customer feedback and NPS survey data to your data warehouse.
- [Drip source for ELT & CDC](https://www.integrate.io/docs/cdc/drip.md): Configure Drip as a data source in Integrate.io ELT & CDC. Sync your email marketing automation and subscriber data to your data warehouse.
- [eBay source for ELT & CDC](https://www.integrate.io/docs/cdc/ebay.md): Configure eBay as a data source in Integrate.io ELT & CDC. Replicate your eBay marketplace orders and listing data to your data warehouse.
- [ELT/CDC: ELT & CDC Features and Requirements](https://www.integrate.io/docs/cdc/elt-cdc-features-and-requirements.md): Review the features, supported sources, destinations, and system requirements for Integrate.io ELT & CDC data replication and sync pipelines.
- [EnquireLabs source for ELT & CDC](https://www.integrate.io/docs/cdc/enquirelabs.md): Configure EnquireLabs as a data source in Integrate.io ELT & CDC. Replicate post-purchase survey and attribution data to your data warehouse.
- [ExchangeRates source for ELT & CDC](https://www.integrate.io/docs/cdc/exchangerates.md): Configure ExchangeRates as a data source in Integrate.io ELT & CDC. Sync currency exchange rate data to your data warehouse automatically.
- [Facebook Ads source for ELT & CDC](https://www.integrate.io/docs/cdc/facebook-ads.md): Configure Facebook Ads as a data source in Integrate.io ELT & CDC. Replicate ad campaign performance and spend data to your data warehouse.
- [Facebook Pages source for ELT & CDC](https://www.integrate.io/docs/cdc/facebook-pages.md): Configure Facebook Pages as a data source in Integrate.io ELT & CDC. Sync page insights and engagement metrics to your data warehouse.
- [GitHub source for ELT & CDC](https://www.integrate.io/docs/cdc/github.md): Configure GitHub as a data source in Integrate.io ELT & CDC. Replicate repository, issue, and pull request data to your data warehouse.
- [GitLab source for ELT & CDC](https://www.integrate.io/docs/cdc/gitlab.md): Set up GitLab as a source in Integrate.io ELT & CDC to replicate issues, merge requests, and project data into your warehouse with change data capture.
- [Google Ads source for ELT & CDC](https://www.integrate.io/docs/cdc/google-ads.md): Configure Google Ads as a data source in Integrate.io ELT & CDC. Sync advertising campaign performance and spend data to your data warehouse.
- [Google Ads change log v23 source for ELT & CDC](https://www.integrate.io/docs/cdc/google-ads-change-log-v23.md): Configure Google Ads Change Log as a source in Integrate.io ELT & CDC. Track and replicate account change history to your data warehouse.
- [Google Analytics source for ELT & CDC](https://www.integrate.io/docs/cdc/google-analytics.md): Google Analytics lets you measure your advertising ROI as well as track your Flash, video, and social networking sites and applications.
- [Google Analytics 360 source for ELT & CDC](https://www.integrate.io/docs/cdc/google-analytics-360-ga360.md): Configure Google Analytics 360 (GA360) as a source in Integrate.io ELT & CDC. Replicate premium analytics data to your data warehouse.
- [Google Analytics 4 source for ELT & CDC](https://www.integrate.io/docs/cdc/google-analytics-4.md): Configure Google Analytics 4 as a data source in Integrate.io ELT & CDC. Replicate GA4 event and reporting data to your data warehouse.
- [Google Analytics 4 export source for ELT & CDC](https://www.integrate.io/docs/cdc/google-analytics-4-export-ga4-export.md): Configure Google Analytics 4 Export as a source in Integrate.io ELT & CDC. Replicate raw GA4 event data exports to your data warehouse.
- [Google Cloud SQL MySQL source for ELT & CDC](https://www.integrate.io/docs/cdc/google-cloud-sql.md): How to configure Google Cloud SQL for MySQL as a CDC source in Integrate.io ELT & CDC, including read-replica setup and binary log configuration.
- [Google Cloud SQL PostgreSQL source for ELT & CDC](https://www.integrate.io/docs/cdc/google-cloud-sql-for-posgresql.md): How to configure Google Cloud SQL for PostgreSQL as a CDC source in Integrate.io ELT & CDC, including logical decoding and role setup.
- [Google API privacy policy for ELT & CDC](https://www.integrate.io/docs/cdc/google-privacy-policy.md): Review Integrate.io's Google API Services disclosure covering data access, usage, and transfer policies for OAuth-connected Google integrations.
- [Google Search Console source for ELT & CDC](https://www.integrate.io/docs/cdc/google-search-console.md): Configure Google Search Console as a source in Integrate.io ELT & CDC. Replicate search performance and indexing data to your data warehouse.
- [Google Sheets source for ELT & CDC](https://www.integrate.io/docs/cdc/google-sheets.md): Configure Google Sheets as a data source in Integrate.io ELT & CDC. Replicate spreadsheet data to your data warehouse for analysis.
- [Gorgias source for ELT & CDC](https://www.integrate.io/docs/cdc/gorgias.md): Configure Gorgias as a data source in Integrate.io ELT & CDC. Replicate customer support ticket and helpdesk data to your data warehouse.
- [ELT/CDC: History Mode (SCD Type 2)](https://www.integrate.io/docs/cdc/history-mode-scd-type-2.md): Enable History Mode (SCD Type 2) in Integrate.io ELT & CDC to retain a full audit trail of every record change with effective dates in your destination.
- [Hooks for monitoring in ELT & CDC](https://www.integrate.io/docs/cdc/hooks.md): Set up email alert hooks for pipeline events in Integrate.io ELT & CDC. Configure notifications for sync failures, completions, and errors.
- [ELT/CDC: How Integrate.io ELT & CDC Handles Schema Changes](https://www.integrate.io/docs/cdc/how-integrateio-elt-cdc-handles-schema-changes.md): How Integrate.io ELT & CDC detects and propagates source schema changes including column additions, deletions, type changes, and table renames.
- [Finding your Snowflake account identifier](https://www.integrate.io/docs/cdc/how-to-get-your-snowflake-account-identifier.md): Find your Snowflake account identifier for configuring the Snowflake destination in Integrate.io ELT & CDC. Locate your account URL and region.
- [HubSpot source for ELT & CDC](https://www.integrate.io/docs/cdc/hubspot.md): Configure HubSpot as a data source in Integrate.io ELT & CDC. Replicate CRM contacts, deals, and marketing data to your data warehouse.
- [ELT/CDC: Initial Sync Process](https://www.integrate.io/docs/cdc/initial-sync-process.md): Learn how Integrate.io ELT & CDC performs initial sync using parallel chunking, Avro staging, and resumable transfers for large datasets.
- [IP allowlist for ELT & CDC](https://www.integrate.io/docs/cdc/ip-list.md): Allowlist Integrate.io ELT & CDC by region with the current outbound IP addresses for source and destination connections through your firewall or VPC.
- [JudgeMe source for ELT & CDC](https://www.integrate.io/docs/cdc/judgeme.md): Configure Judge.me as a data source in Integrate.io ELT & CDC. Replicate product review and rating data to your data warehouse for analysis.
- [Klaviyo source for ELT & CDC](https://www.integrate.io/docs/cdc/klaviyo.md): Configure Klaviyo as a data source in Integrate.io ELT & CDC. Sync email marketing campaigns and subscriber data to your data warehouse.
- [Microsoft SQL Server source for ELT & CDC](https://www.integrate.io/docs/cdc/microsoft-sql-server.md): How to set up and configure Microsoft SQL Server as a CDC source in Integrate.io ELT & CDC, including supported providers and prerequisites.
- [ELT/CDC: Snowflake password to key-pair migration](https://www.integrate.io/docs/cdc/migrating-authentication-from-password-to-key-pair.md): Migrate your Snowflake destination from password-based to key-pair authentication in Integrate.io ELT & CDC. Step-by-step migration guide.
- [MySQL source for ELT & CDC](https://www.integrate.io/docs/cdc/mysql.md): How to set up and configure MySQL as a CDC source in Integrate.io ELT & CDC, including supported providers, requirements, and features.
- [NetSuite source for ELT & CDC](https://www.integrate.io/docs/cdc/netsuite.md): Configure NetSuite as a data source in Integrate.io ELT & CDC. Replicate ERP, CRM, and financial data from NetSuite to your data warehouse.
- [Data observability nomenclature in ELT & CDC](https://www.integrate.io/docs/cdc/nomenclature.md): Understand Data Observability alerts and naming conventions in Integrate.io. Learn how thresholds trigger email notifications for metric changes.
- [Onfleet source for ELT & CDC](https://www.integrate.io/docs/cdc/onfleet.md): Configure Onfleet as a data source in Integrate.io ELT & CDC. Sync last-mile delivery management and logistics data to your data warehouse.
- [Oracle CDC source for ELT & CDC](https://www.integrate.io/docs/cdc/oracle-cdc.md): Configure Oracle CDC as a data source in Integrate.io ELT & CDC. Set up change data capture from Oracle databases for real-time replication.
- [Self-hosted Oracle CDC source for ELT & CDC](https://www.integrate.io/docs/cdc/oracle-cdc-self-hosted.md): Configure a self-hosted Oracle database as a CDC source in Integrate.io ELT & CDC. Set up LogMiner-based change data capture for replication.
- [Pinterest source for ELT & CDC](https://www.integrate.io/docs/cdc/pinterest.md): Configure Pinterest as a data source in Integrate.io ELT & CDC. Replicate ad campaigns, pins, boards, and analytics data to your data warehouse.
- [PostgreSQL source for ELT & CDC](https://www.integrate.io/docs/cdc/postgresql.md): How to set up and configure PostgreSQL as a CDC source in Integrate.io ELT & CDC, including supported providers, WAL requirements, and heartbeat setup.
- [PrivateLink setup for PostgreSQL in ELT & CDC](https://www.integrate.io/docs/cdc/postgresql-privatelink-set-up.md): Set up AWS PrivateLink for PostgreSQL database connections in Integrate.io ELT & CDC. Establish a secure private network link for replication.
- [PrivateLink setup for MySQL in ELT & CDC](https://www.integrate.io/docs/cdc/privatelink-set-up.md): Set up AWS PrivateLink for your MySQL database connection in Integrate.io ELT & CDC. Establish a secure private network link for replication.
- [Intuit Quickbooks source for ELT & CDC](https://www.integrate.io/docs/cdc/quickbooks.md): Configure Intuit QuickBooks as a data source in Integrate.io ELT & CDC. Replicate accounting and financial data to your data warehouse.
- [ReCharge source for ELT & CDC](https://www.integrate.io/docs/cdc/recharge.md): Configure ReCharge as a data source in Integrate.io ELT & CDC. Sync subscription billing and recurring payment data to your data warehouse.
- [Replacement rules transform in ELT & CDC](https://www.integrate.io/docs/cdc/replacement-rules.md): Use replacement rules in Integrate.io ELT & CDC to transform data during replication. Replace, mask, or modify character values during sync.
- [Reverse SSH tunnel for ELT & CDC](https://www.integrate.io/docs/cdc/reverse-ssh-tunnel.md): Configure a reverse SSH tunnel in Integrate.io ELT & CDC to securely connect to private databases behind a firewall without opening inbound network ports.
- [Amazon S3 destination bucket setup for ELT & CDC](https://www.integrate.io/docs/cdc/s3-destination.md): How to configure Amazon S3 as a destination in Integrate.io ELT & CDC, including bucket setup, IAM role access via CloudFormation, and connection testing.
- [S3 source for ELT & CDC](https://www.integrate.io/docs/cdc/s3-source.md): Configure Amazon S3 as a data source in Integrate.io ELT & CDC. Replicate files and structured data from S3 buckets to your data warehouse.
- [Salesforce source for ELT & CDC](https://www.integrate.io/docs/cdc/salesforce.md): The Salesforce connector lets you move data between Salesforce and the rest of your stack using Integrate.io’s low-code ETL and CDC platform.
- [Self-hosted MySQL source for ELT & CDC](https://www.integrate.io/docs/cdc/self-hosted-mysql.md): Configure a self-hosted MySQL server as a source in Integrate.io ELT & CDC. Set up binary log replication from your on-premises MySQL database.
- [Self-hosted PostgreSQL source for ELT & CDC](https://www.integrate.io/docs/cdc/self-hosted-postgresql.md): How to configure a self-hosted PostgreSQL instance as a CDC source in Integrate.io ELT & CDC, including WAL setup, role creation, and privileges.
- [Shippo source for ELT & CDC](https://www.integrate.io/docs/cdc/shippo.md): Configure Shippo as a data source in Integrate.io ELT & CDC. Replicate shipping addresses, parcels, refunds, and transaction data to your warehouse.
- [Shopify source for ELT & CDC](https://www.integrate.io/docs/cdc/shopify.md): Configure Shopify as a data source in Integrate.io ELT & CDC. Replicate orders, products, customers, and store data to your data warehouse.
- [Snowflake destination for ELT & CDC](https://www.integrate.io/docs/cdc/snowflake.md): Configure Snowflake as a destination in Integrate.io ELT & CDC. Set up your Snowflake warehouse to receive replicated data from your sources.
- [Square source for ELT & CDC](https://www.integrate.io/docs/cdc/square.md): Configure Square as a data source in Integrate.io ELT & CDC. Replicate point-of-sale transactions and payment data to your data warehouse.
- [SSH tunnel setup for ELT & CDC](https://www.integrate.io/docs/cdc/ssh-tunnel.md): Set up an SSH tunnel in Integrate.io ELT & CDC for secure database connections over untrusted networks. Encrypt data transfers through SSH.
- [Stripe source for ELT & CDC](https://www.integrate.io/docs/cdc/stripe.md): Configure Stripe as a data source in Integrate.io ELT & CDC. Replicate payment, subscription, and customer data to your data warehouse.
- [ELT/CDC: Surrogate Key (_iio_id)](https://www.integrate.io/docs/cdc/surrogate-key-_iio_id.md): Learn about the _iio_id surrogate primary key that Integrate.io generates for source tables without primary keys during ELT & CDC replication.
- [Tiktok Ads source for ELT & CDC](https://www.integrate.io/docs/cdc/tiktok-ads.md): Configure TikTok Ads as a data source in Integrate.io ELT & CDC. Replicate advertising campaign and performance data to your data warehouse.
- [ELT/CDC: What is Data Observability](https://www.integrate.io/docs/cdc/what-is-data-observability.md): Learn what Data Observability is and how it helps teams verify data system health, detect anomalies, and maintain data quality in Integrate.io.
- [What is Integrate.io ELT & CDC](https://www.integrate.io/docs/cdc/what-is-integrateio-cdc.md): Integrate.io ELT & CDC replicates data from databases and SaaS platforms to Snowflake, Redshift, BigQuery, and S3 using change data capture.
- [Yotpo source for ELT & CDC](https://www.integrate.io/docs/cdc/yotpo.md): Configure Yotpo as a data source in Integrate.io ELT & CDC. Replicate product reviews, ratings, and user-generated content to your warehouse.
- [Zenventory source for ELT & CDC](https://www.integrate.io/docs/cdc/zenventory.md): Configure Zenventory as a data source in Integrate.io ELT & CDC. Replicate inventory management and order fulfillment data to your warehouse.
- [ETL & Reverse ETL Documentation](https://www.integrate.io/docs/etl.md): Build visual data pipelines with Integrate.io ETL. Connect 150+ sources and destinations, transform data with built-in components, and schedule automated jobs.
- [ETL: Two-Factor Authentication](https://www.integrate.io/docs/etl/2-factor-authentication.md): Two-factor Authentication is a method of authentication which requires the user to submit two different secrets to complete their login attempt.
- [ETL: ABS](https://www.integrate.io/docs/etl/abs.md): Calculate the absolute value of any numeric expression in your ETL pipeline. Useful for distance calculations and data normalization tasks.
- [ETL: ACOS](https://www.integrate.io/docs/etl/acos.md): Compute the arc cosine (inverse cosine) of a numeric value in radians. Use for trigonometric calculations in ETL data transformations.
- [ETL: AddDuration](https://www.integrate.io/docs/etl/addduration.md): Add a duration string expression to a datetime value and return the resulting datetime. Use ADDDURATION for date arithmetic in ETL pipelines.
- [ETL: Advanced Search](https://www.integrate.io/docs/etl/advanced-search.md): Use advanced search modifiers in Integrate.io ETL to quickly find packages, connections, jobs, and other resources across your account workspace.
- [ETL: Connecting to Azure Blob Storage](https://www.integrate.io/docs/etl/allow-integrateio-etl-access-to-my-data-on-azure-blob-storage.md): Integrate.io ETL can access data residing on Azure Blob Storage. This article details creating the Azure Blob Storage connection in Integrate.io ETL.
- [ETL: Connecting to SFTPToGo](https://www.integrate.io/docs/etl/allowing-access-to-my-file-data-on-sftptogo.md): Connect your SFTPToGo file storage to Integrate.io ETL. Set up SFTP credentials and access permissions for reading file data in pipelines.
- [ETL: Connecting to Amazon RDS](https://www.integrate.io/docs/etl/allowing-integrateio-direct-access-to-relational-databases-on-amazon-web-services-rds.md): Grant Integrate.io ETL direct access to your Amazon RDS databases. Configure security groups and network settings for database connectivity.
- [ETL: Connecting via Universal OAuth](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-any-api-with-oauth.md): Set up a universal OAuth connection in Integrate.io ETL to access any REST API that supports OAuth 2.0 authentication for data extraction.
- [ETL: Connecting to Azure SQL](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-azure-sql-databases.md): Connect Azure SQL Database to Integrate.io ETL for reading and writing data. Configure firewall rules, credentials, and connection settings.
- [ETL: Connecting to Azure Synapse Analytics](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-azure-synapse-analytics.md): Connect Azure Synapse Analytics to Integrate.io ETL for reading and writing analytical data. Configure access and connection settings.
- [ETL: Connecting to Amazon S3](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-data-on-amazon-s3.md): Connect Amazon S3 to Integrate.io ETL for reading and writing data. Configure IAM credentials, bucket policies, and S3 connection settings.
- [ETL: Connecting to DB2](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-db2-databases.md): Connect DB2 databases to Integrate.io ETL for reading and writing data. Configure access credentials, firewall rules, and connection settings.
- [ETL: Connecting to Facebook Ads Insights](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-facebook-ads-insights-data.md): Authorize Integrate.io ETL to access Facebook Ads Insights, configure the connection, and load campaign performance data into your pipelines and warehouse.
- [ETL: Connecting to Google Analytics 4 (GA4)](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-google-analytics-4-ga4.md): Connect Integrate.io ETL to Google Analytics 4 (GA4) to extract events, traffic, and audience metrics into your data pipelines and warehouse.
- [ETL: Connecting to Google Cloud SQL for MySQL](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-google-cloud-sql-for-mysql-databases.md): Connect Google Cloud SQL for MySQL to Integrate.io ETL. Configure database access, firewall rules, and connection settings for data pipelines.
- [ETL: Connecting to Google Cloud SQL for PostgreSQL](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-google-cloud-sql-for-postgresql-databases.md): Connect Google Cloud SQL for PostgreSQL to Integrate.io ETL. Configure access, firewall rules, and connection settings for data pipelines.
- [ETL: Connecting to Gmail](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-google-mail-gmail.md): Authorize Integrate.io ETL to access your Gmail account using OAuth and extract email metadata and contents into your data pipelines for analysis.
- [ETL: Connecting to Heroku Postgres](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-heroku-postgres-databases.md): Connect Heroku Postgres to Integrate.io ETL for reading and writing data. Configure database credentials, SSL, and connection settings.
- [ETL: Connecting to HubSpot](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-hubspot.md): Integrate.io ETL can load data to your HubSpot accounts. This article details creating the HubSpot connection in Integrate.io ETL.
- [ETL: Connecting to HubSpot (Service Token)](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-hubspot-service-token.md): Connect Integrate.io ETL to HubSpot using a service token, configure API access, and load contacts, deals, and marketing data into your pipelines.
- [ETL: Connecting to IBM i (AS/400)](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-ibm-i-as400.md): Connect IBM i (AS/400) databases to Integrate.io ETL for reading data. Configure JDBC access, firewall rules, and connection settings.
- [ETL: Connecting to Microsoft SQL Server](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-microsoft-sql-server-databases.md): Connect Microsoft SQL Server to Integrate.io ETL for reading and writing data. Configure firewall rules, credentials, and connection settings.
- [ETL: Connecting to MongoDB](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-mongodb.md): Connect Integrate.io ETL to MongoDB to extract collections and documents, configure authentication, and load data into your pipelines and warehouse.
- [ETL: Connecting to Amazon Athena](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-amazon-athena-instance.md): Connect Amazon Athena to Integrate.io ETL for querying data. Configure IAM access credentials, S3 output location, and connection settings.
- [ETL: Connecting to Bing Ads](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-bing-ads.md): Authorize Integrate.io ETL to access Bing Ads (Microsoft Advertising) and extract campaign, ad group, and performance data into your pipelines.
- [ETL: Connecting to Dynamics 365](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-dynamics-365.md): Integrate.io ETL can access your Dynamics 365 data. This article details creating the Dynamics 365 connection in Integrate.io ETL.
- [ETL: Connecting to FTPS](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-file-transfer-protocol-secure-ftps.md): Connect an FTPS server to Integrate.io ETL for reading file data. Configure host, port, TLS credentials, and whitelist required IP addresses.
- [ETL: Connecting to Google Ads](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-google-adwords.md): Authorize Integrate.io ETL to access Google Ads (AdWords), configure the connection, and load campaign and conversion data into your pipelines.
- [ETL: Connecting to Google Analytics](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-google-analytics.md): Authorize Integrate.io ETL to access Google Analytics (Universal Analytics) and extract sessions, users, and reporting data into your pipelines.
- [ETL: Connecting to Google Cloud Storage](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-google-cloud-storage-v2.md): Connect Google Cloud Storage to Integrate.io ETL using a service account key. Configure bucket access and GCS connection settings for pipelines.
- [ETL: Connecting to Google Drive](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-google-drive.md): Integrate.io ETL can access your Google Drive data. This article details creating the Google Drive connection in Integrate.io ETL.
- [ETL: Connecting to Google Sheets](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-google-sheets.md): Connect Google Sheets to Integrate.io ETL for reading spreadsheet data. Set up Google OAuth authorization and configure the data connection.
- [ETL: Connecting to Google Sheets (Service Account)](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-google-sheets-service-account.md): Connect Google Sheets to Integrate.io ETL using a Google Cloud service account key. Configure spreadsheet sharing and create the connection for pipelines.
- [ETL: Connecting to HDFS](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-hadoop-distributed-file-system-hdfs.md): Integrate.io ETL can access data residing on any Hadoop distributed file system (HDFS). This article details creating an HDFS connection in Integrate.io ETL.
- [ETL: Connecting to Instagram](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-instagram.md): Connect Instagram to Integrate.io ETL for extracting social media data. Set up the Facebook-Instagram OAuth connection for data pipelines.
- [ETL: Connecting to Intercom](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-intercom.md): Connect Intercom to Integrate.io ETL for reading customer messaging data. Set up API credentials for both free and premium Intercom accounts.
- [ETL: Connecting to LinkedIn](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-linkedin.md): Create a LinkedIn connection in Integrate.io ETL, authorize OAuth access, and build pipelines that read LinkedIn ads, pages, and profile data.
- [ETL: Connecting to Salesforce](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-salesforce.md): Authorize Integrate.io ETL to access Salesforce, configure the connection, and read accounts, opportunities, and custom object data in your pipelines.
- [ETL: Connecting to Salesforce (SOAP)](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-salesforce-soap.md): Connect Integrate.io ETL to Salesforce using the SOAP API, configure authentication, and read object data into your pipelines and warehouse.
- [ETL: Connecting to Salesforce with Customer-Managed OAuth](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-salesforce-using-customer-managed-oauth.md): Connect Integrate.io ETL to Salesforce using customer-managed OAuth credentials and your own connected app for full control over API access.
- [ETL: Connecting to SFTP](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-secure-file-transfer-protocol-sftp.md): Connect any SFTP server to Integrate.io ETL for reading file data. Configure host, port, credentials, and SSH key authentication settings.
- [ETL: Connecting to SharePoint](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-sharepoint.md): Connect Integrate.io ETL to Microsoft SharePoint to read documents, lists, and library data, and load them into your data pipelines and warehouse.
- [ETL: Connecting to Shopify](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-shopify.md): Create a Shopify connection in Integrate.io ETL and build pipelines that read orders, products, customers, and inventory data into your warehouse.
- [ETL: Connecting to Xero](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-xero.md): Connect Xero accounting data to Integrate.io ETL. Set up OAuth authorization and build a data pipeline for reading Xero financial records.
- [ETL: Connecting to YouTube](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-youtube.md): Connect YouTube data to Integrate.io ETL. Set up Google OAuth authorization and configure a pipeline to read YouTube channel and video data.
- [ETL: Connecting to Google BigQuery](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-google-bigquery-dataset.md): Connect Integrate.io ETL to a Google BigQuery dataset, configure service account credentials, and read or write tables in your pipelines.
- [ETL: Connecting to Marketing Cloud (REST)](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-marketing-cloud-rest.md): Connect Salesforce Marketing Cloud (REST API) to Integrate.io ETL. Configure API credentials and connection settings for data extraction.
- [ETL: Connecting to Marketing Cloud (SOAP)](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-marketing-cloud-soap.md): Connect Salesforce Marketing Cloud (SOAP API) to Integrate.io ETL. Configure WSDL credentials and connection settings for data extraction.
- [ETL: Connecting to Amazon Redshift](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-redshift-cluster.md): Connect Integrate.io ETL to your Amazon Redshift cluster, configure security groups and credentials, and read or write data in your pipelines.
- [ETL: Connecting Through a Firewall](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-server-behind-a-firewall.md): Configure firewall rules to allow Integrate.io ETL access to your database server. Whitelist IP addresses or set up SSH tunnel access.
- [ETL: Connecting to Snowflake](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-snowflake-account.md): Connect Integrate.io ETL to your Snowflake account, configure user, role, and warehouse access, and read or write data in your pipelines.
- [ETL: Connecting to MySQL](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-mysql-databases.md): Connect MySQL databases to Integrate.io ETL for reading and writing data. Configure user permissions, firewall rules, and connection settings.
- [ETL: Connecting to NetSuite](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-netsuite.md): Connect Integrate.io ETL to NetSuite using token-based authentication and load record data such as transactions and customers into your pipelines.
- [ETL: Connecting to Oracle](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-oracle-databases.md): Connect Oracle databases to Integrate.io ETL for reading and writing data. Configure user permissions, firewall rules, and connection settings.
- [ETL: Connecting to PostgreSQL](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-postgresql-databases.md): Connect PostgreSQL databases to Integrate.io ETL for reading and writing data. Configure permissions, firewall rules, and connection settings.
- [ETL: Connecting to SAP HANA](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-sap-hana-databases.md): Connect SAP HANA databases to Integrate.io ETL for reading and writing data. Configure user permissions, firewall rules, and connection settings.
- [ETL: Connecting to TikTok Ads](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-tiktok-ads-data.md): Connect TikTok Ads to Integrate.io ETL for syncing advertising data. Configure API credentials and set up the TikTok Ads data connection.
- [ETL: Connecting to NetSuite (SOAP)](https://www.integrate.io/docs/etl/allowing-integrateio-etl-to-access-to-netsuite-soap.md): Connect Integrate.io ETL to NetSuite using the legacy SOAP web services API, configure credentials, and read record data into your pipelines.
- [ETL: API Endpoints with Pagination](https://www.integrate.io/docs/etl/api-endpoints-with-pagination-support.md): The following lists the API endpoints with pagination support that can be used with the Rest API Source or [C]CurlWithPagination functions.
- [ETL: API Ingestion Guide](https://www.integrate.io/docs/etl/api-ingestion-guide-with-integrateio.md): Step-by-step guide to ingesting data from REST APIs using Integrate.io ETL. Configure API sources with authentication, pagination, and mapping.
- [ETL: ASIN](https://www.integrate.io/docs/etl/asin.md): Compute the arc sine (inverse sine) of a numeric value in radians. Use ASIN for trigonometric calculations in ETL data transformations.
- [ETL: ATAN](https://www.integrate.io/docs/etl/atan.md): Compute the arc tangent (inverse tangent) of a numeric value in radians. Use ATAN for trigonometric calculations in ETL data transformations.
- [ETL: BagToString](https://www.integrate.io/docs/etl/bagtostring.md): Join all elements of a bag (array) into a single string with an optional delimiter character. Defaults to underscore if delimiter is omitted.
- [ETL: BagToTuple](https://www.integrate.io/docs/etl/bagtotuple.md): Flatten a bag (array) into a tuple structure so individual items can be referenced by position. Use for data restructuring in ETL pipelines.
- [ETL: Base64Decode](https://www.integrate.io/docs/etl/base64decode.md): Decode a Base64-encoded string into a byte array in your ETL pipeline. Use BASE64DECODE for processing encoded binary data in transformations.
- [ETL: Base64DecodeToString](https://www.integrate.io/docs/etl/base64decodetostring.md): Decode a Base64-encoded string directly into readable text with a specified character encoding. Use for text decoding in ETL data pipelines.
- [ETL: Base64Encode](https://www.integrate.io/docs/etl/base64encode.md): Encode a byte array into Base64 format for safe text transmission. Use BASE64ENCODE for encoding binary data in Integrate.io ETL pipelines.
- [ETL: Base64EncodeToString](https://www.integrate.io/docs/etl/base64encodetostring.md): Encode a byte array into a Base64 string using the standard encoding scheme. Use for preparing binary data for API calls in ETL pipelines.
- [ETL: BinaryCCurl](https://www.integrate.io/docs/etl/binaryccurl.md): Makes a REST API call and returns the binary response received from the server. Requests are authenticated using an Integrate.io ETL connection.
- [ETL: BinaryCurl](https://www.integrate.io/docs/etl/binarycurl.md): Makes a REST API call and returns the binary response received from the server. Requests are made either anonymous or with basic authentication.
- [ETL: BrowserFamily](https://www.integrate.io/docs/etl/browserfamily.md): Extract the browser family name (Chrome, Firefox, Safari) from a user agent string using ua_parser. For web analytics in ETL data pipelines.
- [ETL: BrowserFullName](https://www.integrate.io/docs/etl/browserfullname.md): Extract the full browser name and version string from a user agent string using ua_parser. Use for web analytics in ETL data pipelines.
- [ETL: BrowserMajor](https://www.integrate.io/docs/etl/browsermajor.md): Extract the browser major version number from a user agent string using the ua_parser library. Use for browser analytics in ETL data pipelines.
- [ETL: BrowserMinor](https://www.integrate.io/docs/etl/browserminor.md): Extract the browser minor version number from a user agent string using the ua_parser library. Use for browser analytics in ETL data pipelines.
- [ETL: BrowserPatch](https://www.integrate.io/docs/etl/browserpatch.md): Extract the browser patch or build number from a user agent string using the ua_parser library. Use for detailed browser analysis in ETL jobs.
- [ETL: BrowserVersion](https://www.integrate.io/docs/etl/browserversion.md): Extract the complete browser version string from a user agent string using the ua_parser library. Use for browser reporting in ETL pipelines.
- [ETL: ByteArrayToString](https://www.integrate.io/docs/etl/bytearraytostring.md): Convert a byte array with a specified character encoding into a readable string. Use for binary-to-text conversions in ETL data pipelines.
- [ETL: Account and Security](https://www.integrate.io/docs/etl/category/account-and-security.md): Manage account settings, security controls, two-factor authentication, IP allowlists, and access permissions for your Integrate.io ETL account.
- [ETL: Account Management](https://www.integrate.io/docs/etl/category/account-management.md): Manage your Integrate.io ETL account settings, billing, plans, and team members. Migrate between development and production environments.
- [ETL: Alerts & Monitoring](https://www.integrate.io/docs/etl/category/alerts-and-monitoring.md): Set up alerts and notifications for Integrate.io ETL pipelines. Configure email, Slack, PagerDuty, and webhook hooks for job events.
- [ETL: Alerts and Notifications](https://www.integrate.io/docs/etl/category/alerts-and-notifications.md): Configure email alerts, Slack notifications, PagerDuty hooks, and webhook channels to monitor Integrate.io ETL pipeline runs, failures, and performance.
- [ETL: All Articles](https://www.integrate.io/docs/etl/category/all-articles.md): Complete index of all Integrate.io ETL & Reverse ETL documentation articles, covering sources, destinations, transformations, functions, and more.
- [ETL: API and Webhooks](https://www.integrate.io/docs/etl/category/api-and-webhooks.md): Use the Integrate.io ETL REST API and outbound webhooks to programmatically manage packages, run jobs, and integrate ETL events with external systems.
- [ETL: Clusters](https://www.integrate.io/docs/etl/category/clusters.md): Manage and configure Integrate.io ETL clusters: create clusters, choose node types, control auto-scaling, and run pipeline jobs efficiently at scale.
- [ETL: Configuring Your Environment](https://www.integrate.io/docs/etl/category/configuring-your-integrateio-etl-environment.md): Set up your Integrate.io ETL environment with account preferences, region selection, member roles, billing, and global pipeline configuration options.
- [ETL: Connectivity and Security](https://www.integrate.io/docs/etl/category/connectivity-and-security.md): Connection guides, IP allowlists, SSH tunnels, VPC peering, and security configuration for connecting Integrate.io ETL to your data sources and destinations.
- [ETL: Creating Packages](https://www.integrate.io/docs/etl/category/creating-packages.md): Build Integrate.io ETL packages: design pipelines in the visual designer, configure sources and destinations, and add transformations like joins and filters.
- [ETL: Destinations](https://www.integrate.io/docs/etl/category/destinations.md): Load data to target systems in Integrate.io ETL. Configure destination connectors for Snowflake, Redshift, BigQuery, databases, and cloud storage.
- [ETL: Expressions & Functions](https://www.integrate.io/docs/etl/category/expressions-and-functions.md): Write expressions and use 180+ built-in functions in Integrate.io ETL for string manipulation, date handling, math, JSON/XML processing, and encryption.
- [ETL: Getting Started Guides Overview](https://www.integrate.io/docs/etl/category/getting-started.md): Browse Integrate.io ETL getting started guides covering connections, packages, clusters, jobs, workspaces, terminology, and best practices.
- [ETL: How Do I](https://www.integrate.io/docs/etl/category/how-do-i.md): How-to guides and answers to common questions for getting started with Integrate.io ETL pipelines, transformations, scheduling, and troubleshooting.
- [ETL: New Releases](https://www.integrate.io/docs/etl/category/new-releases.md): Release notes and announcements for new Integrate.io ETL features, connectors, transformations, performance improvements, and platform changes.
- [ETL: Other](https://www.integrate.io/docs/etl/category/other.md): Integrate.io ETL reference guides covering encoding, incremental loading, JSON and XML processing, version control, and other pipeline configuration topics.
- [ETL: Packages & Workflows](https://www.integrate.io/docs/etl/category/packages-and-workflows.md): Create and manage ETL packages and workflows in Integrate.io. Use the visual designer, templates, version control, and workflow components.
- [ETL: Programming and API](https://www.integrate.io/docs/etl/category/programming-and-api.md): Programmatic access to Integrate.io ETL: REST API, SDKs, command-line tools, and code samples for managing packages, jobs, and connections from your apps.
- [ETL: Running and Monitoring Jobs](https://www.integrate.io/docs/etl/category/running-and-monitoring-jobs.md): Run and monitor Integrate.io ETL jobs: track job progress, review logs and errors, debug failed runs, and analyze pipeline performance metrics.
- [ETL: Scheduling and Jobs](https://www.integrate.io/docs/etl/category/scheduling-and-jobs.md): Schedule Integrate.io ETL packages with recurring runs, cron expressions, dependencies, and time-window controls to automate your data pipelines.
- [ETL: Scheduling, Jobs & Clusters](https://www.integrate.io/docs/etl/category/scheduling-jobs-and-clusters.md): Run, schedule, and monitor ETL jobs in Integrate.io. Create clusters, set up recurring schedules, and track job progress and errors.
- [ETL: Security & Access](https://www.integrate.io/docs/etl/category/security-and-access.md): Manage security and access controls for Integrate.io ETL. Set up 2FA, SSO, SSH keys, firewall rules, IP allowlists, and user roles.
- [ETL: Sources](https://www.integrate.io/docs/etl/category/sources.md): Connect to data sources in Integrate.io ETL. Browse 150+ source connectors for databases, cloud storage, SaaS APIs, and file systems.
- [ETL: Transformations](https://www.integrate.io/docs/etl/category/transformations.md): Transform data in Integrate.io ETL pipelines. Use 20 built-in components to filter, join, aggregate, sort, pivot, and reshape data.
- [ETL: Using Clusters](https://www.integrate.io/docs/etl/category/using-clusters.md): Use Integrate.io ETL clusters effectively: select sandbox or production clusters, manage cluster sizes, and assign jobs for cost-efficient pipeline runs.
- [ETL: CBRT](https://www.integrate.io/docs/etl/cbrt.md): Calculate the cube root of a numeric expression in your Integrate.io ETL pipeline. Returns the cube root value for mathematical transformations.
- [ETL: CCurl](https://www.integrate.io/docs/etl/ccurl.md): Makes a REST API call and returns the response received from the server. Requests are authenticated using an Integrate.io ETL connection.
- [ETL: CCurlPoll](https://www.integrate.io/docs/etl/ccurlpoll.md): Continuously poll an authenticated REST API endpoint until a regex pattern matches the response or a timeout is reached. For async API workflows.
- [ETL: CCurlWithPagination](https://www.integrate.io/docs/etl/ccurlwithpagination.md): Make authenticated, paginated REST API calls and aggregate responses from all pages into one result. For multi-page API ingestion with credentials.
- [ETL: CEIL](https://www.integrate.io/docs/etl/ceil.md): Round a numeric expression up to the nearest integer value. Use CEIL for ceiling calculations in Integrate.io ETL data pipeline expressions.
- [ETL: Changing Your Password](https://www.integrate.io/docs/etl/changing-your-password.md): Change your Integrate.io ETL account password. Follow the steps to update your login credentials through the account security settings page.
- [ETL: CityNameFromIP](https://www.integrate.io/docs/etl/citynamefromip.md): Look up and return the city name associated with an IPv4 address in dot-decimal notation. Use for IP-based geolocation in ETL data pipelines.
- [ETL: ClockTime](https://www.integrate.io/docs/etl/clocktime.md): Return the current UTC datetime at the moment each individual record is processed. Use CLOCKTIME for per-record timestamps in ETL pipeline jobs.
- [ETL: COALESCE](https://www.integrate.io/docs/etl/coalesce.md): Return the first non-null argument from a list of expressions. Use COALESCE for null handling and providing default values in ETL pipelines.
- [ETL: Component Previewer](https://www.integrate.io/docs/etl/component-previewer.md): Use Component Previewer in Integrate.io ETL to test and preview data output from individual pipeline components before running a full job.
- [ETL: CONCAT](https://www.integrate.io/docs/etl/concat.md): Join a variable number of string expressions into one combined string. Use CONCAT for building composite fields in Integrate.io ETL pipelines.
- [ETL: Google Analytics 커넥터 설정](https://www.integrate.io/docs/etl/connector-part01-ko.md): Integrate.io ETL의 Connections 화면에서 Google Analytics 커넥터 연결을 만들고 OAuth 인증 정보를 입력하여 데이터 파이프라인의 소스로 설정하는 방법을 단계별 화면과 함께 안내합니다. Integrate.io 사용자 가이드의 한 항목입니다.
- [ETL: Google BigQuery 커넥터에 대한 질문 요약](https://www.integrate.io/docs/etl/connector-part02-ko.md): Integrate.io ETL에서 Google BigQuery 커넥터를 사용할 때 자주 묻는 질문과 답변을 정리합니다. 미리보기 시 청구 동작, OAuth 지원 여부, 인증 정보 관리 방법 등을 다룹니다. 자세한 화면과 예시도 함께 정리했습니다.
- [ETL: Zendesk Support Ticket 데이터를 Redshift에 로드](https://www.integrate.io/docs/etl/connector-part03-ko.md): Integrate.io ETL의 REST API 컴포넌트로 Zendesk Support API에 접근하여 티켓 데이터를 증분(Incremental) 방식으로 추출하고 Amazon Redshift에 적재하는 절차를 자세히 설명합니다. 운영 시 참고할 수 있도록 단계별로 정리했습니다.
- [ETL: ContinentCodeFromIP](https://www.integrate.io/docs/etl/continentcodefromip.md): Look up and return the two-letter continent code for an IPv4 address in dot-decimal notation. Use for geo-analysis in ETL data pipelines.
- [ETL: ContinentNameFromIP](https://www.integrate.io/docs/etl/continentnamefromip.md): Look up and return the continent name for an IPv4 address in dot-decimal notation. Use for geographic analysis in Integrate.io ETL pipelines.
- [ETL: COS](https://www.integrate.io/docs/etl/cos.md): Calculate the trigonometric cosine of a numeric input value in radians. Use COS for geometric and mathematical computations in ETL pipelines.
- [ETL: COSH](https://www.integrate.io/docs/etl/cosh.md): Calculate the hyperbolic cosine of a numeric value in your ETL pipeline. Use COSH for advanced mathematical computations and data transformations.
- [ETL: CountryCodeFromIP](https://www.integrate.io/docs/etl/countrycodefromip.md): Look up and return the ISO 3166-1 alpha-2 country code for an IPv4 address. Use for geographic segmentation in Integrate.io ETL pipelines.
- [ETL: CountryNameFromIP](https://www.integrate.io/docs/etl/countrynamefromip.md): Look up and return the country name for an IPv4 address in dot-decimal notation. Use COUNTRYNAMEFROMIP for geolocation in ETL data pipelines.
- [ETL: Creating a Package from a Template](https://www.integrate.io/docs/etl/create-a-package-from-a-template.md): Create a new Integrate.io ETL package from a pre-built template. Choose from available templates to quickly start common data pipeline patterns.
- [ETL: Creating a Cluster](https://www.integrate.io/docs/etl/creating-a-cluster.md): Create and configure a compute cluster in Integrate.io ETL. Choose instance size, node count, and region for running your data pipeline jobs.
- [ETL: Package Creation Guide](https://www.integrate.io/docs/etl/creating-a-new-package.md): Create a new ETL package using the classic package creation flow in Integrate.io ETL. Configure package settings and define your data pipeline.
- [ETL: Creating a New Package](https://www.integrate.io/docs/etl/creating-a-new-package-in-integrateio-etl.md): Create a new data pipeline package in the Integrate.io ETL visual designer. Configure package settings, add components, and build data flows.
- [ETL: Creating a Workflow](https://www.integrate.io/docs/etl/creating-a-workflow.md): Create workflow packages in Integrate.io ETL to orchestrate multi-step tasks. Define sequential and conditional task execution with error handling.
- [ETL: Salesforce to SFTP Workflow](https://www.integrate.io/docs/etl/creating-an-api-managed-salesforce-to-sftp-workflow.md): Build an API-managed Salesforce-to-SFTP workflow in Integrate.io ETL using the REST API to programmatically run, monitor, and parameterize the pipeline.
- [ETL: CSVSPLIT](https://www.integrate.io/docs/etl/csvsplit.md): Parse a CSV-formatted string into a tuple by splitting on a field delimiter character. Use CSVSPLIT for inline CSV parsing in ETL pipelines.
- [ETL: Curl](https://www.integrate.io/docs/etl/curl.md): Makes a REST API call and returns the response received from the server. Requests are made either anonymous or with basic authentication.
- [ETL: CurlPoll](https://www.integrate.io/docs/etl/curlpoll.md): Continuously poll a REST API endpoint until a response matches a regex pattern or timeout. Use CURLPOLL for async API workflows in ETL jobs.
- [ETL: CurlWithPagination function reference](https://www.integrate.io/docs/etl/curlwithpagination.md): Reference for the CurlWithPagination function. Make paginated REST API calls and combine all page responses into a single aggregated result.
- [ETL: CurrentTime](https://www.integrate.io/docs/etl/currenttime.md): Return the UTC datetime value for when the current job was submitted. Use CURRENTTIME for consistent job-level timestamps across all records.
- [ETL: DateAddDays](https://www.integrate.io/docs/etl/dateadddays.md): Use the DateAddDays expression function in Integrate.io ETL to add or subtract days from a date or timestamp value within your pipeline transformations.
- [ETL: DateDiffDays](https://www.integrate.io/docs/etl/datediffdays.md): Calculate the number of whole days between two datetime values. Use DATEDIFFDAYS for date-range calculations in Integrate.io ETL data pipelines.
- [ETL: DateDiffHours](https://www.integrate.io/docs/etl/datediffhours.md): Calculate the number of whole hours between two datetime values. Use DATEDIFFHOURS for time-range analysis in Integrate.io ETL data pipelines.
- [ETL: DateDiffMinutes](https://www.integrate.io/docs/etl/datediffminutes.md): Calculate the number of whole minutes between two datetime values. Use DATEDIFFMINUTES for duration calculations in Integrate.io ETL pipelines.
- [ETL: DateDiffMonths](https://www.integrate.io/docs/etl/datediffmonths.md): Calculate the number of whole months between two datetime values. Use DATEDIFFMONTHS for period calculations in Integrate.io ETL data pipelines.
- [ETL: DateDiffSeconds](https://www.integrate.io/docs/etl/datediffseconds.md): Calculate the number of whole seconds between two datetime values. Use DATEDIFFSECONDS for precise duration analysis in ETL data pipelines.
- [ETL: DateDiffYears](https://www.integrate.io/docs/etl/datediffyears.md): Calculate the number of whole years between two datetime values. Use DATEDIFFYEARS for age and tenure calculations in Integrate.io ETL pipelines.
- [ETL: DaysBetween](https://www.integrate.io/docs/etl/daysbetween.md): Calculate the number of days between two datetime values using a fractional rounding approach. Compare with DATEDIFFDAYS for different behavior.
- [ETL: Decrypt](https://www.integrate.io/docs/etl/decrypt.md): Decrypt an Integrate.io ETL encrypted string using the specified AWS KMS key ARN and the encryption context used for the encryption.
- [ETL: Defining Connections](https://www.integrate.io/docs/etl/defining-connections.md): Create and manage data connections in Integrate.io ETL. Define access credentials for databases, cloud storage, APIs, and SaaS applications.
- [ETL: DeviceFamily](https://www.integrate.io/docs/etl/devicefamily.md): Extract the device family name (iPhone, iPad, Galaxy) from a user agent string using ua_parser. Use for device analytics in ETL data pipelines.
- [ETL: DistInMilesHaversine](https://www.integrate.io/docs/etl/distinmileshaversine.md): Compute the distance in miles between two latitude-longitude coordinate pairs using the Haversine formula. Use for geo-distance in ETL pipelines.
- [ETL: Dynamic Connections](https://www.integrate.io/docs/etl/dynamic-connections.md): Use dynamic connections in Integrate.io ETL to parameterize data source and destination settings at runtime with variables and expressions.
- [ETL: Editing and Scaling Clusters](https://www.integrate.io/docs/etl/editing-and-scaling-clusters.md): Edit and scale Integrate.io ETL clusters by adjusting instance types, node counts, and configurations to match changing workload requirements.
- [ETL: Email Hooks](https://www.integrate.io/docs/etl/email-hooks.md): Set up email hooks to receive real-time notifications about Integrate.io ETL job and cluster events directly in your inbox. Configure alerts.
- [ETL: Encrypt](https://www.integrate.io/docs/etl/encrypt.md): AES-encrypt a string using a specified AWS KMS key ARN and encryption context. Use ENCRYPT for protecting sensitive fields in ETL data pipelines.
- [ETL: 작업 실행의 장기화를 피하는 방법?](https://www.integrate.io/docs/etl/etc-part01-ko.md): Integrate.io ETL 패키지의 TIMEOUT_IN_SECONDS 변수를 설정하여 작업의 최대 실행 시간을 제한하고, 장기 실행 잡을 방지하면서 알림을 통해 장애를 신속히 파악하고 대응하는 방법을 소개합니다. 데이터 파이프라인 구축 시 참고할 수 있는 가이드입니다.
- [ETL: Xplenty에서 2FA 사용](https://www.integrate.io/docs/etl/etc-part02-ko.md): Integrate.io ETL에서 Google Authenticator, Authy 같은 TOTP 앱을 사용해 2단계 인증(2FA)을 활성화하고 사용자 계정에 시간 기반 일회용 암호 보안을 적용하는 방법을 안내합니다. 처음 사용하시는 분들도 이해하기 쉽게 작성했습니다.
- [ETL: Xplenty 단축키](https://www.integrate.io/docs/etl/etc-part03-ko.md): Integrate.io ETL에서 Connections, Packages, Jobs, Cluster, Schedule 화면 이동과 패키지 디자이너 편집을 더 빠르게 수행할 수 있는 키보드 단축키 모음을 정리해 소개합니다. Integrate.io 한국어 사용자 가이드 항목입니다.
- [ETL: Xplenty에서 JOIN 처리의 고속화 방법](https://www.integrate.io/docs/etl/etc-part04-ko.md): Integrate.io ETL의 Join 컴포넌트에서 Replicated Join, Skewed Join, Merge Join 등 Pig 기반 조인 유형을 데이터셋 특성에 맞게 선택하여 데이터 통합 처리 속도를 크게 향상시키는 방법을 설명합니다.
- [ETL: Xplenty로 XML 데이터 처리](https://www.integrate.io/docs/etl/etc-part05-ko.md): Integrate.io ETL에서 XmlExtract 등 전용 함수를 활용해 XML 형식의 파일 데이터를 손쉽게 파싱하고, CSV나 JSON과 같은 방식으로 데이터 파이프라인 안에서 처리하는 방법을 예제로 설명합니다. 화면 캡처와 함께 단계별로 정리했습니다.
- [ETL: Xplenty Job의 고속화 요령](https://www.integrate.io/docs/etl/etc-part06-ko.md): Integrate.io ETL에서 소량 데이터 작업의 MapReduce 시작·종료 오버헤드를 줄이기 위해 패키지 변수를 설정하여 마스터 노드에서 Pig 스크립트 기반으로 작업을 실행해 잡 처리 속도를 높이는 방법을 소개합니다. 사용자 환경에 맞춰 활용해 보시기 바랍니다.
- [ETL: Xplenty 패키지 및 잡의 검색방법에 대하여](https://www.integrate.io/docs/etl/etc-part07-ko.md): Integrate.io ETL의 패키지 검색창에서 이름, 사용자, 상태, 마지막 실행 시간 등 다양한 검색 태그를 활용하여 많은 패키지와 잡 중에서 원하는 항목을 신속하게 찾는 방법을 단계별 예시와 함께 소개합니다. Integrate.io 사용자 가이드의 한 항목입니다.
- [ETL: Xplenty-Console 사용법](https://www.integrate.io/docs/etl/etc-part08-ko.md): Integrate.io ETL의 X-Console을 사용하여 표현식과 변환 함수의 결과를 실시간으로 테스트하고, 패키지 디자이너 안에서 데이터 파이프라인을 효율적으로 디버깅하는 방법을 단계별로 자세히 설명합니다. 자세한 화면과 예시도 함께 정리했습니다.
- [ETL: Xplenty의 디버깅 방법 - Integrate.io Blog](https://www.integrate.io/docs/etl/etc-part09-ko.md): Integrate.io ETL에서 파일 스토리지 출력, 컴포넌트 프리뷰어, 표현식 검증 등 세 가지 디버깅 방법을 활용하여 ETL 변환 처리에서 발생한 문제의 원인을 빠르게 파악하고 해결하는 방법을 소개합니다. 운영 시 참고할 수 있도록 단계별로 정리했습니다.
- [ETL: Xplenty에서 개인 정보를 마스킹하는 방법](https://www.integrate.io/docs/etl/etc-part10-ko.md): Integrate.io ETL의 표현식 함수와 Select 컴포넌트로 이름, 이메일, 주민등록번호 등 데이터 파이프라인의 개인정보 컬럼을 마스킹하여 민감 정보 유출을 방지하고 데이터 거버넌스를 강화하는 방법을 안내합니다. 데이터 파이프라인 구축 시 참고할 수 있는 가이드입니다.
- [ETL: Xplenty의 장애전달에 대하여](https://www.integrate.io/docs/etl/etc-part11-ko.md): Integrate.io ETL의 클라우드 인프라에서 장애가 발생했을 때 상태 페이지, 이메일 공지, 알림 채널을 통해 문제를 신속하게 파악하고 고객이 운영하는 데이터 파이프라인에 대응하는 장애 전달 체계를 자세히 설명합니다. 처음 사용하시는 분들도 이해하기 쉽게 작성했습니다.
- [ETL: Xplenty의 클러스터와 노드에 대해 알아 봅시다!](https://www.integrate.io/docs/etl/etc-part12-ko.md): Integrate.io ETL에서 데이터 파이프라인 패키지를 실제로 실행하는 클러스터와 노드의 정의, 사용법, 그리고 노드 수에 따른 처리 성능과 비용 변화를 구체적인 예시를 통해 자세히 설명합니다. Integrate.io 한국어 사용자 가이드 항목입니다.
- [ETL: ExecuteBQInsert](https://www.integrate.io/docs/etl/executebqinsert.md): Run a query job in Google BigQuery and write the results to a destination table. Use EXECUTEBQINSERT for in-pipeline BigQuery write operations.
- [ETL: ExecuteSqlBoolean](https://www.integrate.io/docs/etl/executesqlboolean.md): Execute a SQL query that returns a scalar boolean value. If the query returns a dataset, the value of the first column in the first row is returned.
- [ETL: ExecuteSqlDateTime](https://www.integrate.io/docs/etl/executesqldatetime.md): Execute a SQL query that returns a scalar datetime value. If the query returns a dataset, the value of the first column in the first row is returned.
- [ETL: ExecuteSqlDouble](https://www.integrate.io/docs/etl/executesqldouble.md): Execute a SQL query that returns a scalar double value. If the query returns a dataset, the value of the first column in the first row is returned.
- [ETL: ExecuteSqlFloat](https://www.integrate.io/docs/etl/executesqlfloat.md): Execute a SQL query that returns a scalar float value. If the query returns a dataset, the value of the first column in the first row is returned.
- [ETL: ExecuteSqlInt](https://www.integrate.io/docs/etl/executesqlint.md): Execute a SQL query that returns a scalar integer value. If the query returns a dataset, the value of the first column in the first row is returned.
- [ETL: ExecuteSqlLong](https://www.integrate.io/docs/etl/executesqllong.md): Execute a SQL query that returns a scalar long value. If the query returns a dataset, the value of the first column in the first row is returned.
- [ETL: ExecuteSqlNonQuery](https://www.integrate.io/docs/etl/executesqlnonquery.md): Execute SQL DML or DDL statements that modify data or database schema without returning results. Use for in-pipeline database operations in ETL.
- [ETL: ExecuteSqlString](https://www.integrate.io/docs/etl/executesqlstring.md): Execute a SQL query that returns a scalar string value. If the query returns a dataset, the value of the first column in the first row is returned.
- [ETL: EXP](https://www.integrate.io/docs/etl/exp.md): Calculate Euler's number (e) raised to the power of the input expression. Use EXP for exponential growth and decay calculations in ETL jobs.
- [ETL: ExtractQueryStringParam](https://www.integrate.io/docs/etl/extractquerystringparam.md): Extract the value of a specific query string parameter from a URL field. Use for URL parsing and web analytics processing in ETL data pipelines.
- [ETL: ExtractSearchQuery](https://www.integrate.io/docs/etl/extractsearchquery.md): Extract the search query keywords from a search engine URL. Use EXTRACTSEARCHQUERY for search analytics data processing in ETL data pipelines.
- [ETL: ExtractUABrowserID](https://www.integrate.io/docs/etl/extractuabrowserid.md): Return a unique browser identifier from a user agent string. Use EXTRACTUABROWSERID for visitor tracking and web analytics in ETL data pipelines.
- [ETL: ExtractUABrowserName](https://www.integrate.io/docs/etl/extractuabrowsername.md): Return the browser name from a user agent string. Use EXTRACTUABROWSERNAME for web analytics and browser usage reporting in ETL data pipelines.
- [ETL: ExtractUrlPart](https://www.integrate.io/docs/etl/extracturlpart.md): Extract a specific component (host, path, port, query) from a URL field. Use EXTRACTURLPART for URL parsing and analysis in ETL pipelines.
- [ETL: S3, SFTP/FTPS등의 스토리지 연계 기능에 대해](https://www.integrate.io/docs/etl/filestorage-part01-ko.md): Integrate.io ETL이 지원하는 S3, SFTP, FTPS, Azure Blob Storage, Google Cloud Storage, HDFS 등 다양한 파일 스토리지 연계 기능과 와일드카드 검색 같은 유연한 옵션을 자세히 설명합니다.
- [ETL: Excel 데이터를 로드하는 방법](https://www.integrate.io/docs/etl/filestorage-part02-ko.md): Integrate.io ETL의 File Storage 소스 컴포넌트에서 Excel(xls, xlsx) 파일을 변환 없이 그대로 읽어 데이터 파이프라인에서 처리하는 설정 방법과 시트, 행 개수 등 제한 사항을 안내합니다. 화면 캡처와 함께 단계별로 정리했습니다.
- [ETL: Parquet 형식으로 대용량 데이터 저장 용량과 처리 시간을 절약할 수 있습니다!](https://www.integrate.io/docs/etl/filestorage-part03-ko.md): Integrate.io ETL의 FileStorage 데스티네이션에서 Apache Parquet 형식으로 대용량 데이터를 출력하여 저장 용량을 줄이고 후속 처리 시간을 절약하는 설정 방법과 장단점을 단계별로 소개합니다. 사용자 환경에 맞춰 활용해 보시기 바랍니다.
- [ETL: Parquet 형식의 대용량 데이터 불러오기](https://www.integrate.io/docs/etl/filestorage-part04-ko.md): Integrate.io ETL의 File Storage 소스에서 2024년 3월부터 지원하는 Apache Parquet 형식의 대용량 데이터를 읽어 들이고, 다른 패키지와 연동하는 데이터 파이프라인을 구성하는 방법을 자세히 설명합니다.
- [ETL: File Upload 소스로 즉시 ETL을 써보기](https://www.integrate.io/docs/etl/filestorage-part05-ko.md): Integrate.io ETL이 2026년 1월에 출시한 File Upload 소스를 사용하여 외부 스토리지 없이 직접 파일을 업로드하고 새로운 데이터 파이프라인을 빠르게 시도해 볼 수 있는 방법을 소개합니다. Integrate.io 사용자 가이드의 한 항목입니다.
- [ETL: 데이터 전송 후 파일 이동 및 삭제 기능 활용하기](https://www.integrate.io/docs/etl/filestorage-part06-ko.md): Integrate.io ETL의 워크플로 File Mover 태스크와 File Storage Source 컴포넌트의 처리 완료 파일 이동 옵션을 활용하여 데이터 전송 후 원본 파일을 자동으로 이동하거나 삭제하는 방법을 소개합니다. 자세한 화면과 예시도 함께 정리했습니다.
- [ETL: Flatten](https://www.integrate.io/docs/etl/flatten.md): Flatten removes a level of nesting in a record. The result of applying Flatten to a bag is that each item in the bag will appear in a record of its own.
- [ETL: FLOOR](https://www.integrate.io/docs/etl/floor.md): Round a numeric expression down to the nearest integer value. Use FLOOR for truncating decimal values in Integrate.io ETL pipeline expressions.
- [ETL: GetBytes](https://www.integrate.io/docs/etl/getbytes.md): Convert a string input to its byte array representation in a given character encoding. Use GETBYTES for binary data handling in ETL pipelines.
- [ETL: GetDay](https://www.integrate.io/docs/etl/getday.md): Extract the day-of-month component (1 through 31) from a datetime expression. Use GETDAY for date-based filtering and grouping in ETL pipelines.
- [ETL: GetHour](https://www.integrate.io/docs/etl/gethour.md): Extract the hour component (0 through 23) from a datetime expression. Use GETHOUR for time-based filtering and data grouping in ETL pipelines.
- [ETL: GetMilliSecond](https://www.integrate.io/docs/etl/getmillisecond.md): Extract the millisecond component from a datetime expression. Use GETMILLISECOND for sub-second precision timing in Integrate.io ETL pipelines.
- [ETL: GetMinute](https://www.integrate.io/docs/etl/getminute.md): Extract the minute component (0 through 59) from a datetime expression. Use GETMINUTE for time-based grouping in Integrate.io ETL data pipelines.
- [ETL: GetMonth](https://www.integrate.io/docs/etl/getmonth.md): Extract the month component (1 through 12) from a datetime expression. Use GETMONTH for monthly aggregations in Integrate.io ETL data pipelines.
- [ETL: GetSecond](https://www.integrate.io/docs/etl/getsecond.md): Extract the second component (0 through 59) from a datetime expression. Use GETSECOND for time-based analysis in Integrate.io ETL data pipelines.
- [ETL: Getting Started](https://www.integrate.io/docs/etl/getting-started.md): Get started with Integrate.io ETL for cloud data integration. Learn the platform basics, create your first pipeline, and process data at scale.
- [ETL: GetWeek](https://www.integrate.io/docs/etl/getweek.md): Extract the ISO week-of-year number from a datetime expression. Use GETWEEK for weekly reporting and data grouping in ETL pipeline expressions.
- [ETL: GetWeekYear](https://www.integrate.io/docs/etl/getweekyear.md): Extract the ISO week-year value from a datetime expression. Use GETWEEKYEAR for week-based date calculations in Integrate.io ETL data pipelines.
- [ETL: GetYear](https://www.integrate.io/docs/etl/getyear.md): Extract the year component from a datetime expression. Use GETYEAR for annual aggregations, filtering, and date partitioning in ETL pipelines.
- [ETL: Global Variables](https://www.integrate.io/docs/etl/global-variables-account-level.md): Define and manage global variables at the account level in Integrate.io ETL. Share reusable variable values across all packages in your account.
- [ETL: HoursBetween](https://www.integrate.io/docs/etl/hoursbetween.md): Calculate the number of hours between two datetime values using a fractional rounding approach. Compare with DATEDIFFHOURS for alternate behavior.
- [ETL: Encrypting and Decrypting Data](https://www.integrate.io/docs/etl/how-do-i-encrypt-and-decrypt-sensitive-data.md): Encrypt and decrypt sensitive fields in Integrate.io ETL pipelines using AWS Key Management Service (KMS) for field-level data protection.
- [ETL: Import or Export Package JSON](https://www.integrate.io/docs/etl/how-do-i-import-or-export-a-packages-json-source-code.md): Import or export package JSON source code in Integrate.io ETL. Use JSON export for version control, backup, and cross-account pipeline migration.
- [ETL: Moving Data Incrementally Between Databases](https://www.integrate.io/docs/etl/how-do-i-move-data-incrementally-between-databases.md): This article guides you through the process of extracting and loading data incrementally from a database table to another database table.
- [ETL: Processing Different Encodings](https://www.integrate.io/docs/etl/how-do-i-process-a-different-encoding.md): Process source files with non-UTF-8 character encodings in Integrate.io ETL by configuring the encoding option to read CSV, TSV, and text files correctly.
- [ETL: Processing JSON Data](https://www.integrate.io/docs/etl/how-do-i-process-json-data.md): Parse, extract, and transform JSON data in Integrate.io ETL pipelines using built-in functions like JsonExtract, JsonStringToMap, and ToBag.
- [ETL: Processing XML Data](https://www.integrate.io/docs/etl/how-do-i-process-xml-data.md): Parse, extract, and transform XML data in Integrate.io ETL pipelines using XPath expressions and built-in XML processing functions like XPath.
- [ETL: Reading File Storage Data Incrementally](https://www.integrate.io/docs/etl/how-do-i-read-data-from-file-storage-incrementally.md): Design incremental file-reading pipelines in Integrate.io ETL. Process only new or changed files from cloud storage on each scheduled job run.
- [ETL: Selecting File Input Format](https://www.integrate.io/docs/etl/how-do-i-select-my-file-input-format.md): Choose the correct file input format in the File Storage Source component. Configure record delimiters and record types for CSV, JSON, and more.
- [ETL: Package Version Control](https://www.integrate.io/docs/etl/how-do-i-use-package-version-control.md): Use package version control in Integrate.io ETL to track changes, compare versions, and revert to previous package configurations when needed.
- [ETL: Working with Datetime Data](https://www.integrate.io/docs/etl/how-do-i-work-with-datetime-data.md): Work with date and time data in Integrate.io ETL pipelines. Parse, format, convert, and calculate datetime values using built-in ETL functions.
- [ETL: Creating a Delivery](https://www.integrate.io/docs/etl/how-to-create-a-delivery.md): Create a data delivery pipeline in Integrate.io ETL. Configure source-to-destination data movement with scheduling and transformation options.
- [ETL: INDEXOF](https://www.integrate.io/docs/etl/indexof.md): Find the position of the first occurrence of a substring within a string, searching forward from an optional start index. Returns -1 if not found.
- [ETL: Ingesting a Postman API Call](https://www.integrate.io/docs/etl/ingesting-a-working-postman-api-call-with-integrateios-api-connector.md): Convert a working Postman API request into a REST source in Integrate.io ETL: map headers, auth, query parameters, and pagination into the API connector.
- [ETL: INITCAP](https://www.integrate.io/docs/etl/initialcap.md): Capitalize the first letter of each word in a string and lowercase the rest. Word delimiters include whitespace, hyphen, apostrophe, and period.
- [ETL: AI Assistant](https://www.integrate.io/docs/etl/integrateio-ai-assistant.md): Use the Integrate.io AI Assistant to generate and explain ETL expressions, troubleshoot pipeline errors, and accelerate package design with natural language.
- [ETL: Best Practices Guide](https://www.integrate.io/docs/etl/integrateio-best-practices-guide.md): Best practices for designing, scheduling, and operating Integrate.io ETL pipelines: package structure, performance tuning, error handling, and data quality.
- [ETL: Functions Reference](https://www.integrate.io/docs/etl/integrateio-etl-functions.md): Complete reference of all built-in functions in Integrate.io ETL expressions, covering string, math, date, hash, collection, and API functions.
- [ETL: Password Policy](https://www.integrate.io/docs/etl/integrateio-etl-password-policy.md): Review the Integrate.io ETL password policy, including minimum length, complexity, expiration, and reset requirements for user account security.
- [ETL: Support Rates](https://www.integrate.io/docs/etl/integrateio-etl-support-rates.md): View Integrate.io ETL support plan options and billing rates. Compare support tiers for customers on plans without allocated support hours.
- [ETL: ETL Terminology](https://www.integrate.io/docs/etl/integrateio-etl-terminology.md): Learn the key terms and concepts used throughout Integrate.io ETL documentation, including packages, clusters, jobs, connections, and pipelines.
- [ETL: API Reference](https://www.integrate.io/docs/etl/integrateio-etls-api.md): Reference for the Integrate.io ETL REST API: authentication, endpoints for clusters, packages, and jobs, and code examples for automating your ETL workflows.
- [ETL: Clusters Overview](https://www.integrate.io/docs/etl/integrateio-etls-clusters.md): Learn about Integrate.io ETL clusters, the compute environments that run your data pipeline jobs. Understand cluster types, sizing, and lifecycle.
- [ETL: IP Allowlist](https://www.integrate.io/docs/etl/integrateio-etls-ip-list.md): Current Integrate.io ETL outbound IP addresses by region. Allowlist these IPs in your firewall or security group so ETL pipelines can reach your data.
- [ETL: Packages Overview](https://www.integrate.io/docs/etl/integrateio-etls-packages.md): Learn about Integrate.io ETL packages, the core building blocks for data pipelines. Understand package types, components, and design principles.
- [ETL: 중급 Part01: User 변수 사용](https://www.integrate.io/docs/etl/intermediate-part01-ko.md): Integrate.io ETL에서 사용자가 직접 정의하는 User 변수를 사용해 Google Analytics 같은 데이터 소스의 추출 날짜 범위를 동적으로 설정하는 활용 예시와 표현식 작성 방법을 자세히 소개합니다. 운영 시 참고할 수 있도록 단계별로 정리했습니다.
- [ETL: intermediate-part02-ko](https://www.integrate.io/docs/etl/intermediate-part02-ko.md): Integrate.io ETL 중급 가이드 시리즈의 한 편으로, 패키지 변수와 표현식을 활용해 데이터 파이프라인의 동작과 입력 파라미터를 세밀하게 제어하는 중급 사용자 대상의 ETL 활용 기법을 다룹니다. 데이터 파이프라인 구축 시 참고할 수 있는 가이드입니다.
- [ETL: 중급 Part03：정규 표현을 사용해 데이터의 품질보장](https://www.integrate.io/docs/etl/intermediate-part03-ko.md): Integrate.io ETL에서 정규 표현식(Regex) 함수를 사용해 들어오는 CSV 데이터의 형식을 검증하고 예상치 못한 값을 걸러내어 데이터 파이프라인 안에서 데이터 품질을 보장하는 방법을 실제 예제와 함께 설명합니다. 처음 사용하시는 분들도 이해하기 쉽게 작성했습니다.
- [ETL: 중급 Part04:DB관련 설정(Destination편)](https://www.integrate.io/docs/etl/intermediate-part04-ko.md): Integrate.io ETL에서 Database Destination 컴포넌트를 사용할 때 자주 묻는 질문을 다룹니다. 로드 중 에러 시 동작, 트랜잭션과 롤백 처리, 옵션 설정 등을 정리해 자세히 설명합니다. Integrate.io 한국어 사용자 가이드 항목입니다.
- [ETL: 중급 Part05: DB관련 설정(Source편)](https://www.integrate.io/docs/etl/intermediate-part05-ko.md): Integrate.io ETL의 Database 소스 컴포넌트에서 Table 모드와 Query 모드, 소스 스키마 지정, 증분 로드 등 자주 사용되는 설정 옵션과 사용 사례별 권장 구성을 자세히 소개합니다. 화면 캡처와 함께 단계별로 정리했습니다.
- [ETL: 중급 Part06: 워크플로우 기능에 대하여](https://www.integrate.io/docs/etl/intermediate-part06-ko.md): Integrate.io ETL의 워크플로 기능으로 Dataflow 패키지와 SQL 쿼리 작업을 드래그 앤 드롭으로 원하는 순서로 배치하고, 성공·실패 결과에 따라 다른 실행 경로를 트리거하는 방법을 자세히 설명합니다. 사용자 환경에 맞춰 활용해 보시기 바랍니다.
- [ETL: 중급 Part07: 패키지의 Export/Import 기능](https://www.integrate.io/docs/etl/intermediate-part07-ko.md): Integrate.io ETL의 Export 및 Import 기능을 활용하여 패키지 정의를 JSON 형식으로 내보내고 다른 어카운트 환경에 그대로 복사하거나, 변수와 컴포넌트 설정을 수정하여 재사용하는 방법을 자세히 안내합니다. Integrate.io 사용자 가이드의 한 항목입니다.
- [ETL: 중급 Part08: 변수의 참조범위에 대하여](https://www.integrate.io/docs/etl/intermediate-part08-ko.md): Integrate.io ETL에서 시스템 변수, 패키지 변수, 잡 변수의 참조 범위(스코프)를 이해하고, 스케줄러로 잡을 실행할 때 필요한 값을 효율적이고 안전하게 설정하는 방법을 자세히 설명합니다. 자세한 화면과 예시도 함께 정리했습니다.
- [ETL: 중급 Part9：Xplenty의 Rest API로 기존 업무와의 연계(1)](https://www.integrate.io/docs/etl/intermediate-part09-ko.md): Integrate.io ETL의 REST API를 사용하여 패키지 실행, 잡 상태 조회 등 기존 업무 시스템과 자동화된 워크플로로 연계하는 활용 방법을 다루는 첫 번째 가이드로, REST API 개념도 함께 정리합니다. 운영 시 참고할 수 있도록 단계별로 정리했습니다.
- [ETL: 중급 Part10：Xplenty의 Rest API로 기존 업무와의 연계(2)](https://www.integrate.io/docs/etl/intermediate-part10-ko.md): Integrate.io ETL의 비조회형 REST API 엔드포인트를 활용하여 잡 실행, 패키지 업데이트, 클러스터 제어 등을 외부 워크플로에 통합하는 방법을 다루는 두 번째 REST API 활용 가이드입니다. 데이터 파이프라인 구축 시 참고할 수 있는 가이드입니다.
- [ETL: IntervalIntersection](https://www.integrate.io/docs/etl/intervalintersection.md): Calculate the overlap duration in milliseconds between multiple date/time intervals. Use for scheduling and time range analysis in ETL pipelines.
- [ETL: IsBase64](https://www.integrate.io/docs/etl/isbase64.md): Check whether a string expression is valid Base64-encoded content. Returns true or false for input validation in Integrate.io ETL data pipelines.
- [ETL: IsEmpty](https://www.integrate.io/docs/etl/isempty.md): Check if a map or bag is empty, returning true, false, or null accordingly. Use ISEMPTY for conditional logic and data validation in ETL pipelines.
- [ETL: IsISODatetime](https://www.integrate.io/docs/etl/isisodatetime.md): Check whether a string expression conforms to ISO 8601 date time format. Returns true or false for date validation in Integrate.io ETL pipelines.
- [ETL: ISOAddDuration](https://www.integrate.io/docs/etl/isoaddduration.md): Add an ISO 8601 duration expression to an ISO datetime string and return the updated result. Use for date arithmetic in ETL pipeline expressions.
- [ETL: ISODatetimeToString](https://www.integrate.io/docs/etl/isodatetimetostring.md): Format an ISO datetime string using a custom date format pattern. Use ISODATETIMETOSTRING for converting dates to display formats in ETL jobs.
- [ETL: ISODatetimeToTimestampFormat](https://www.integrate.io/docs/etl/isodatetimetotimestampformat.md): Convert an ISO 8601 datetime string to JDBC timestamp format (yyyy-MM-dd HH:mm:ss). Use for database compatibility in ETL pipeline expressions.
- [ETL: ISOSubtractDuration](https://www.integrate.io/docs/etl/isosubtractduration.md): Subtract an ISO 8601 duration from a datetime string and return the result. Use ISOSUBTRACTDURATION for date calculations in ETL data pipelines.
- [ETL: ISOToDay](https://www.integrate.io/docs/etl/isotoday.md): Truncate an ISO datetime string to the start of its day (midnight UTC). Use ISOTODAY for daily grouping and aggregations in ETL data pipelines.
- [ETL: ISOToHour](https://www.integrate.io/docs/etl/isotohour.md): Truncate an ISO datetime string to the start of its hour. Use ISOTOHOUR for hourly aggregations and time bucketing in ETL pipeline expressions.
- [ETL: ISOToMinute](https://www.integrate.io/docs/etl/isotominute.md): Truncate an ISO datetime string to the start of its minute. Use ISOTOMINUTE for minute-level time groupings in Integrate.io ETL data pipelines.
- [ETL: ISOToMonth](https://www.integrate.io/docs/etl/isotomonth.md): Truncate an ISO datetime string to the first day of its month. Use ISOTOMONTH for monthly aggregations in Integrate.io ETL pipeline expressions.
- [ETL: ISOToSecond](https://www.integrate.io/docs/etl/isotosecond.md): Truncate an ISO datetime string to the start of its second. Use ISOTOSECOND for second-level precision groupings in ETL pipeline expressions.
- [ETL: ISOToWeek](https://www.integrate.io/docs/etl/isotoweek.md): Truncate an ISO datetime string to Monday of its week. Use ISOTOWEEK for weekly aggregations and reporting in Integrate.io ETL data pipelines.
- [ETL: ISOToYear](https://www.integrate.io/docs/etl/isotoyear.md): Truncate an ISO datetime string to January 1st of its year. Use ISOTOYEAR for yearly aggregations in Integrate.io ETL pipeline expressions.
- [ETL: JsonExtract](https://www.integrate.io/docs/etl/jsonextract.md): Extracts the value referenced by a JSONPath-like expression json_path from a given JSON string and returns the result as a JSON string.
- [ETL: JsonExtractScalar](https://www.integrate.io/docs/etl/jsonextractscalar.md): Extracts the value referenced by a JSONPath-like expression json_path from a given JSON string and returns the result as a string.
- [ETL: JsonStringToBag](https://www.integrate.io/docs/etl/jsonstringtobag.md): Parse a JSON array string into a bag (array) data structure for iteration. Use JSONSTRINGTOBAG for JSON array processing in ETL data pipelines.
- [ETL: JsonStringToMap](https://www.integrate.io/docs/etl/jsonstringtomap.md): Use the JsonStringToMap expression function in Integrate.io ETL to parse a JSON string into a map field for downstream transformations and field access.
- [ETL: LAST_INDEX_OF](https://www.integrate.io/docs/etl/last-index-of.md): Returns the position of the last occurrence of a search string in a string field, when searching backward from the end of the string.
- [ETL: LatitudeFromIP](https://www.integrate.io/docs/etl/latitudefromip.md): Look up and return the latitude coordinate for an IPv4 address in dot-decimal notation. Use for IP-based geolocation mapping in ETL pipelines.
- [ETL: LCFIRST](https://www.integrate.io/docs/etl/lcfirst.md): Convert the first character of a string to lowercase while preserving the remaining characters. Use LCFIRST for text normalization in ETL jobs.
- [ETL: Length](https://www.integrate.io/docs/etl/length.md): Return the number of characters in a string field value. Use LENGTH for measuring, validating, and filtering string data in ETL data pipelines.
- [ETL: Salesforce Objects Reference](https://www.integrate.io/docs/etl/list-of-salesforce-objects.md): Reference list of supported Salesforce standard and custom objects for data extraction in Integrate.io ETL pipelines using the Salesforce source.
- [ETL: LOG](https://www.integrate.io/docs/etl/log.md): Compute the natural logarithm (base e) of a numeric value in your ETL pipeline. Use LOG for logarithmic data transformations and calculations.
- [ETL: LOG10](https://www.integrate.io/docs/etl/log10.md): Compute the base-10 logarithm of a numeric value in your ETL pipeline. Use LOG10 for order-of-magnitude and decibel calculations in data flows.
- [ETL: LongitudeFromIP](https://www.integrate.io/docs/etl/longitudefromip.md): Look up and return the longitude coordinate for an IPv4 address in dot-decimal notation. Use for IP-based geolocation mapping in ETL pipelines.
- [ETL: LOWER](https://www.integrate.io/docs/etl/lower.md): Convert all characters in a string expression to lowercase. Use LOWER for case-insensitive matching and text normalization in ETL data pipelines.
- [ETL: Managing Account Settings](https://www.integrate.io/docs/etl/managing-your-account-settings.md): View and manage your Integrate.io ETL account settings including organization name, time zone, default region, and notification preferences.
- [ETL: Managing Account Members](https://www.integrate.io/docs/etl/managing-your-integrateio-etl-account-members.md): You can add members to your Integrate.io ETL account to perform activities such as defining packages, creating clusters and running jobs.
- [ETL: Managing SSH Keys](https://www.integrate.io/docs/etl/managing-your-ssh-keys.md): Manage SSH keys for secure database tunnel connections in Integrate.io ETL. Generate, upload, and configure SSH key-based server authentication.
- [ETL: MapToBag](https://www.integrate.io/docs/etl/maptobag.md): Convert a map into a bag of key-value pair maps for iteration. Use MAPTOBAG for processing map entries in Integrate.io ETL pipeline expressions.
- [ETL: MapToQueryString](https://www.integrate.io/docs/etl/maptoquerystring.md): Convert a key-value map into a URL query string format (key1=value1&key2=value2). Use for building URL parameters in Integrate.io ETL pipelines.
- [ETL: MD2](https://www.integrate.io/docs/etl/md2.md): Calculate the MD2 message digest hash of a string value. Use MD2 for legacy checksum generation in Integrate.io ETL pipeline data processing.
- [ETL: MD5](https://www.integrate.io/docs/etl/md5.md): Calculate the MD5 message digest hash of a string value. Use MD5 for checksums, data deduplication, and fingerprinting in ETL data pipelines.
- [ETL: Migrating from Development to Production](https://www.integrate.io/docs/etl/migrate-from-development-to-production.md): Migrate Integrate.io ETL packages and connections from development to production. Export, import, and promote pipeline configurations across accounts.
- [ETL: MilliSecondsBetween](https://www.integrate.io/docs/etl/millisecondsbetween.md): Calculate the number of milliseconds between two datetime values. Use MILLISECONDSBETWEEN for sub-second duration measurement in ETL data pipelines.
- [ETL: MinutesBetween](https://www.integrate.io/docs/etl/minutesbetween.md): Calculate the number of minutes between two datetime values using a fractional rounding method. Compare with DATEDIFFMINUTES for other behavior.
- [ETL: Modifying Personal Settings](https://www.integrate.io/docs/etl/modifying-your-personal-settings.md): Update your personal profile settings in Integrate.io ETL, including your display name, email address, time zone, and notification preferences.
- [ETL: Monitoring Clusters](https://www.integrate.io/docs/etl/monitoring-clusters.md): Monitor the status and health of Integrate.io ETL clusters using the dashboard, API polling, or webhook notifications for real-time updates.
- [ETL: Monitoring Jobs](https://www.integrate.io/docs/etl/monitoring-jobs.md): Monitor Integrate.io ETL jobs: track running, completed, and failed runs, view logs and metrics, and investigate errors to keep pipelines healthy.
- [ETL: MonthsBetween](https://www.integrate.io/docs/etl/monthsbetween.md): Calculate the number of months between two datetime values using a fractional rounding method. Compare with DATEDIFFMONTHS for other approaches.
- [ETL: 초급 Part01 : 데이터 연결 설정 방법](https://www.integrate.io/docs/etl/novice-part01-ko.md): Integrate.io ETL을 처음 사용하는 사용자를 위해 전용(Native) 커넥터를 활용한 연결과 일반 데이터베이스 연결 두 가지 방식으로 데이터 소스 연결을 설정하는 방법을 단계별 화면과 함께 소개합니다. 처음 사용하시는 분들도 이해하기 쉽게 작성했습니다.
- [ETL: 초급 Part02: 데이터 변환 기능의 사용법(1)](https://www.integrate.io/docs/etl/novice-part02-ko.md): Integrate.io ETL에서 가장 많이 사용되는 Select 컴포넌트로 필드 선택, 이름 변경, 표현식 함수를 적용하여 JSON, 텍스트 등 다양한 형식의 원본 데이터를 분석용 형식으로 가공하는 기본 사용법을 소개합니다. Integrate.io 한국어 사용자 가이드 항목입니다.
- [ETL: 초급 Part03 : Xplenty에서 자주 수행되는 문자열 조작](https://www.integrate.io/docs/etl/novice-part03-ko.md): Integrate.io ETL에서 자주 수행되는 문자열 분할, 공백 제거, 결합, 치환 등 일반적인 문자열 변환 처리를 STRSPLIT, REGEX_EXTRACT 같은 함수의 실제 사용 예제와 함께 자세히 설명합니다. 화면 캡처와 함께 단계별로 정리했습니다.
- [ETL: 초급 Part04: 데이터 변환 기능의 사용법(2)](https://www.integrate.io/docs/etl/novice-part04-ko.md): Integrate.io ETL의 Sort, Rank, Filter, Aggregate, Cross Join 등 Select 컴포넌트 외 다양한 변환 컴포넌트의 사용법과 Rank, Dense Rank 같은 옵션별 결과 차이를 예시와 함께 소개합니다.
- [ETL: 초급 Part05: Destination 설정](https://www.integrate.io/docs/etl/novice-part05-ko.md): Integrate.io ETL의 Destination 컴포넌트 종류와 각 데이터베이스, 클라우드 스토리지, SaaS 등 로드 대상별 상세 설정 방법을 ETL을 처음 사용하는 사용자도 이해하기 쉽게 단계별로 소개합니다. 사용자 환경에 맞춰 활용해 보시기 바랍니다.
- [ETL: 초급 Part06: 패키지 확인 및 작업 결과 확인](https://www.integrate.io/docs/etl/novice-part06-ko.md): Integrate.io ETL의 Validate 기능으로 패키지 작성 후 컴포넌트 오류를 사전에 검증하고, 잡 실행 후에는 결과 화면과 로그를 확인하여 데이터 파이프라인 문제를 빠르게 파악하는 방법을 자세히 안내합니다. Integrate.io 사용자 가이드의 한 항목입니다.
- [ETL: 초급 Part07: 블랙박스화하지 않기 위한 메커니즘](https://www.integrate.io/docs/etl/novice-part07-ko.md): Integrate.io ETL에서 컴포넌트 메모, 패키지 설명, 명명 규칙 등을 활용해 데이터 파이프라인이 시간이 지나며 블랙박스화되는 것을 방지하고, 유지보수성과 팀 협업 효율을 높이는 모범 사례를 자세히 설명합니다. 자세한 화면과 예시도 함께 정리했습니다.
- [ETL: 초급 Part08: 스케줄 설정](https://www.integrate.io/docs/etl/novice-part08-ko.md): Integrate.io ETL에서 잡을 정해진 시점에 자동으로 실행하기 위한 간이 및 상세 스케줄 설정 방법과, 클러스터의 노드 수를 지정하여 처리 성능과 비용을 조절하는 방법을 단계별로 소개합니다. 운영 시 참고할 수 있도록 단계별로 정리했습니다.
- [ETL: 초급 Part09: 알림기능에 대하여](https://www.integrate.io/docs/etl/novice-part09-ko.md): Integrate.io ETL의 Service Hook 알림 기능으로 이메일, Slack, Webhook, PagerDuty와 연동하여 잡의 성공·실패 상태를 외부 시스템에 자동으로 전달하고 빠르게 대응하는 방법을 소개합니다. 데이터 파이프라인 구축 시 참고할 수 있는 가이드입니다.
- [ETL: 초급 Part10: 데이터 형식 변환](https://www.integrate.io/docs/etl/novice-part10-ko.md): Integrate.io ETL의 표현식 편집기에서 Chararray, Long, Double, DateTime 등으로 데이터 형식을 변환하는 방법과 BAG/MAP 형 처리 시 주의해야 할 사항을 실제 사용 예시와 함께 정리해 설명합니다.
- [ETL: Xplenty에서 MySQL(RDS 및 Firewall 넘어에 있는 DB)에 연결하는 절차](https://www.integrate.io/docs/etl/onpremise-part01-ko.md): Integrate.io ETL에서 Direct Connection, SSH Tunnel, Reverse SSH Tunnel 세 가지 방법을 사용해 RDS나 방화벽 뒤에 있는 MySQL 등 데이터베이스에 안전하게 연결하는 절차와 SSL 옵션을 자세히 설명합니다.
- [ETL: OsFamily](https://www.integrate.io/docs/etl/osfamily.md): Extract the operating system family name (Windows, macOS, Linux) from a user agent string using ua_parser. For OS analytics in ETL pipelines.
- [ETL: OsFullName](https://www.integrate.io/docs/etl/osfullname.md): Extract the full operating system name and version from a user agent string using ua_parser. Use for OS analytics in Integrate.io ETL pipelines.
- [ETL: OsMajor](https://www.integrate.io/docs/etl/osmajor.md): Extract the operating system major version number from a user agent string using ua_parser. Use for OS version analysis in ETL data pipelines.
- [ETL: OsMinor](https://www.integrate.io/docs/etl/osminor.md): Extract the operating system minor version number from a user agent string using ua_parser. Use for OS version analysis in ETL data pipelines.
- [ETL: OsPatch](https://www.integrate.io/docs/etl/ospatch.md): Extract the operating system patch or build number from a user agent string using ua_parser. Use for detailed OS version tracking in ETL jobs.
- [ETL: OsPatchMinor](https://www.integrate.io/docs/etl/ospatchminor.md): Extract the OS patch minor version number from a user agent string using ua_parser. Use for granular OS version tracking in ETL data pipelines.
- [ETL: OsVersion](https://www.integrate.io/docs/etl/osversion.md): Extract the full operating system version string from a user agent string using ua_parser. Use for OS version reporting in ETL data pipelines.
- [ETL: PagerDuty Hooks](https://www.integrate.io/docs/etl/pagerduty-hooks.md): Send Integrate.io ETL pipeline alerts to PagerDuty by configuring service hooks for job failures, slow runs, and other events to trigger on-call incidents.
- [ETL: ParseDate](https://www.integrate.io/docs/etl/parsedate.md): Convert an input datetime string to a datetime data type using the first matching format from a list of patterns. Flexible date parsing for ETL.
- [ETL: ParseDoubleOrDefault](https://www.integrate.io/docs/etl/parsedoubleordefault.md): Safely convert a string to a double-precision number, returning a default value on parse failure. Use for resilient numeric parsing in ETL jobs.
- [ETL: ParseFloatOrDefault](https://www.integrate.io/docs/etl/parsefloatordefault.md): Safely convert a string to a floating-point number, returning a default value on failure. Use for error-tolerant numeric parsing in ETL pipelines.
- [ETL: ParseIntOrDefault](https://www.integrate.io/docs/etl/parseintordefault.md): Safely convert a string to an integer, returning a specified default value if the conversion fails. Use for resilient numeric parsing in ETL jobs.
- [ETL: ParseLongOrDefault](https://www.integrate.io/docs/etl/parselongordefault.md): Safely convert a string to a long integer, returning a default value if conversion fails. Use for resilient large number parsing in ETL pipelines.
- [ETL: PlatformFamily](https://www.integrate.io/docs/etl/platformfamily.md): Extract the platform family or device category (mobile, desktop, tablet) from a user agent string. For device type analytics in ETL pipelines.
- [ETL: POW](https://www.integrate.io/docs/etl/pow.md): Raise a numeric base value to the power of an exponent in your ETL pipeline. Use POW for exponential calculations and data transformations.
- [ETL: QueryStringToMap](https://www.integrate.io/docs/etl/querystringtomap.md): Parse a URL query string (key1=value1&key2=value2) into a key-value map structure. Use for processing web URL parameters in ETL data pipelines.
- [ETL: RANDOM](https://www.integrate.io/docs/etl/random.md): Generate a pseudo-random floating-point number between 0.0 and 1.0 in your ETL pipeline. Useful for sampling, testing, and data randomization.
- [ETL: REGEX_EXTRACT](https://www.integrate.io/docs/etl/regex-extract.md): Extract matching text from a string using a regular expression, returning the nth occurrence by index. Use for pattern-based parsing in ETL jobs.
- [ETL: REGEX_EXTRACT_ALL](https://www.integrate.io/docs/etl/regex-extract-all.md): Return all capture groups matched by a regular expression pattern as a tuple. Use REGEX_EXTRACT_ALL for multi-group regex parsing in ETL pipelines.
- [ETL: REGEX_FIND_ALL](https://www.integrate.io/docs/etl/regex-find-all.md): Return all substrings matching a regular expression as a bag (array). Use REGEX_FIND_ALL for comprehensive pattern matching in ETL data pipelines.
- [ETL: RegionCodeFromIP](https://www.integrate.io/docs/etl/regioncodefromip.md): Extracts the two character ISO-3166-2 (US or Canada) or FIPS 10-4 code for the state/region from a given IPv4 string (dot-decimal notation).
- [ETL: RegionNameFromIP](https://www.integrate.io/docs/etl/regionnamefromip.md): Look up and return the region, state, or province name for an IPv4 address. Use REGIONNAMEFROMIP for geographic segmentation in ETL pipelines.
- [ETL: REPLACE](https://www.integrate.io/docs/etl/replace.md): Replace all occurrences of a search substring with a new value in a string field. Use REPLACE for text cleanup and formatting in ETL pipelines.
- [ETL: SAP HANA Cloud의 데이터를 OData를 통하여 검색](https://www.integrate.io/docs/etl/restapi-part01-ko.md): Integrate.io ETL의 REST API 컴포넌트로 SAP HANA Cloud Sandbox 환경의 Sales Order OData 서비스에 접근하여 데이터를 조회하고, 인증 정보와 요청 URL을 설정하는 방법을 자세히 안내합니다.
- [ETL: Google Sheet에서 데이터 검색](https://www.integrate.io/docs/etl/restapi-part02-ko.md): Integrate.io ETL의 REST API 컴포넌트를 사용해 Google Sheets에서 시트 ID와 셀 범위를 지정하고 batchGet 엔드포인트를 통해 데이터를 읽어 들이는 방법과 인증 설정 방법을 자세히 설명합니다. 처음 사용하시는 분들도 이해하기 쉽게 작성했습니다.
- [ETL: Hubspot 데이터를 API로 가져오기](https://www.integrate.io/docs/etl/restapi-part03-ko.md): Integrate.io ETL의 REST API 컴포넌트와 HubSpot의 API 키를 사용해 HubSpot에서 Contact 데이터를 검색하고 데이터 파이프라인으로 가져오는 방법과 API 키 발급 절차를 자세히 안내합니다. Integrate.io 한국어 사용자 가이드 항목입니다.
- [ETL: Hubspot 데이터를 API로 갱신하기](https://www.integrate.io/docs/etl/restapi-part04-ko.md): Integrate.io ETL의 Curl 함수와 HubSpot API를 활용하여 S3에 저장된 CSV 형식의 연락처 데이터를 읽고 HubSpot의 Contact 레코드를 일괄 갱신하는 방법을 단계별 화면과 함께 자세히 소개합니다. 화면 캡처와 함께 단계별로 정리했습니다.
- [ETL: Integrate.io의 Curl 함수에 대한 철저한 설명 - Integrate.io Blog](https://www.integrate.io/docs/etl/restapi-part05-ko.md): Integrate.io의 Curl 함수에 대한 철저한 설명을 다룹니다. 데이터 파이프라인 안에서 HTTP 요청을 실행하여 외부 API 데이터로 레코드를 보강하는 다양한 활용 사례를 단계별 데모와 함께 소개합니다. 사용자 환경에 맞춰 활용해 보시기 바랍니다.
- [ETL: Curl Function을 사용한 데이타 갱신](https://www.integrate.io/docs/etl/restapi-part06-ko.md): Integrate.io ETL의 Curl 함수를 사용해 외부 클라우드 애플리케이션의 API를 호출하고, 변환된 데이터를 대상 시스템에 자동으로 갱신(쓰기)하는 다양한 데이터 연계 시나리오를 자세히 소개합니다. Integrate.io 사용자 가이드의 한 항목입니다.
- [ETL: Shopify의 Product에 DB의 제품 데이터를 연결하는 방법은?](https://www.integrate.io/docs/etl/restapi-part07-ko.md): Integrate.io ETL의 Curl 함수를 활용해 데이터베이스에 저장된 상품 마스터 데이터를 추출하고, Shopify Product API로 자동 연동하여 EC 사이트의 재고 운영을 자동화하는 방법을 자세히 설명합니다. 자세한 화면과 예시도 함께 정리했습니다.
- [ETL: Google 드라이브에서 파일 연동](https://www.integrate.io/docs/etl/restapi-part08-ko.md): Integrate.io ETL에서 Google Drive 커넥션을 만들고 텍스트, CSV, TSV 형식의 파일을 읽어 데이터베이스나 파일 스토리지 등 다른 시스템으로 연동하는 절차와 활용 팁을 자세히 안내합니다. 운영 시 참고할 수 있도록 단계별로 정리했습니다.
- [ETL: Extended JSON extraction을 통한 중첩 구조 전개](https://www.integrate.io/docs/etl/restapi-part09-ko.md): Integrate.io ETL의 REST API Source가 새롭게 지원하는 Extended JSON extraction 기능을 사용하여, 중첩된 JSON 응답에서 필요한 필드만 평탄화해 추출하는 방법을 자세한 예시와 함께 설명합니다.
- [ETL: Reverse](https://www.integrate.io/docs/etl/reverse.md): Reverse the order of characters in a string field value. Use REVERSE for string manipulation, palindrome checks, and data transforms in ETL jobs.
- [ETL: ROUND](https://www.integrate.io/docs/etl/round.md): Round a numeric expression to the nearest integer using standard math rounding rules. Use ROUND for numeric formatting in ETL data pipelines.
- [ETL: ROUND_TO](https://www.integrate.io/docs/etl/round-to.md): Round a numeric expression to a specified number of decimal places. Use ROUND_TO for precision control and formatting in ETL pipeline expressions.
- [ETL: Running Jobs](https://www.integrate.io/docs/etl/running-jobs.md): Run a validated package as a job on an Integrate.io ETL cluster. Select the appropriate cluster size, set variables, and monitor job execution.
- [ETL: Salesforce 연결을 설정하는 방법](https://www.integrate.io/docs/etl/salesforce-part01-ko.md): Integrate.io ETL에서 Salesforce 커넥션을 만들고, API 액세스가 가능한 라이선스인지 확인한 후 Production 환경 인증을 진행하여 데이터 파이프라인의 소스로 설정하는 절차를 단계별로 자세히 안내합니다. 데이터 파이프라인 구축 시 참고할 수 있는 가이드입니다.
- [ETL: Salesforce 연결 Q&A](https://www.integrate.io/docs/etl/salesforce-part02-ko.md): Integrate.io ETL의 Salesforce 연동에 관한 자주 묻는 질문을 다룹니다. Bulk API v1과 v2 차이, 사용자 정의 객체 지정 가능 여부, SOQL 쿼리 모드 사용법 등을 정리해 자세히 설명합니다. 처음 사용하시는 분들도 이해하기 쉽게 작성했습니다.
- [ETL: Salesforce에 데이터를 쓸 때 오류가 발생한 작업의 원인조사](https://www.integrate.io/docs/etl/salesforce-part03-ko.md): Integrate.io ETL에서 Salesforce에 데이터를 로드할 때 Bulk API 오류로 잡이 실패하는 경우, Salesforce의 일괄 데이터 읽기 작업 화면에서 오류 세부사항과 원인을 조사하는 절차를 자세히 안내합니다. Integrate.io 한국어 사용자 가이드
- [ETL: Salesforce 데이터 업데이트 팁 모음](https://www.integrate.io/docs/etl/salesforce-part04-ko.md): Integrate.io ETL에서 Salesforce에 데이터를 갱신(Upsert)할 때 자주 발생하는 Date 형식 처리, NULL 값 입력, 외부 ID 매칭 등 사례별 주의사항과 해결 팁을 정리하여 자세히 소개합니다. 화면 캡처와 함께 단계별로 정리했습니다.
- [ETL: Integrate.io + Heroku Connect로 Salesforce 연동](https://www.integrate.io/docs/etl/salesforce-part05-ko.md): Integrate.io와 Heroku Connect, Heroku Postgres를 함께 사용해 Salesforce 데이터를 유연하게 양방향 연동하는 방법을 데모 동영상과 함께 살펴보는 한국어 블로그 번역 가이드. 통합 사례 포함. 운영 노하우 포함.
- [ETL: Salesforce PK Chunking](https://www.integrate.io/docs/etl/salesforce-pk-chunking.md): Enable PK Chunking for large Salesforce data extractions in Integrate.io ETL. Improve query performance when extracting millions of records.
- [ETL: Scheduling Package Execution](https://www.integrate.io/docs/etl/scheduling-package-execution.md): Schedule Integrate.io ETL package execution with one-time runs, recurring intervals, cron expressions, and time-zone settings to automate pipelines.
- [ETL: SecondsBetween](https://www.integrate.io/docs/etl/secondsbetween.md): Calculate the number of seconds between two datetime values using a fractional rounding approach. Compare with DATEDIFFSECONDS for differences.
- [ETL: Selecting a Plan](https://www.integrate.io/docs/etl/selecting-a-plan.md): Compare Integrate.io ETL plans, choose the right tier for your data volume and feature needs, and learn how to upgrade, downgrade, or change billing.
- [ETL: Selecting an Account](https://www.integrate.io/docs/etl/selecting-the-account-to-work-in.md): Switch between multiple Integrate.io ETL accounts using the Launchpad. Select the organization you want to work in for your current session.
- [ETL: Service Hooks](https://www.integrate.io/docs/etl/service-hooks.md): Configure service hooks in Integrate.io ETL to send pipeline events such as job successes and failures to Slack, PagerDuty, webhooks, and other tools.
- [ETL: Reverse SSH Tunnel from Windows](https://www.integrate.io/docs/etl/set-up-a-reverse-ssh-tunnel-from-windows.md): Set up a reverse SSH tunnel from Windows to securely connect Integrate.io ETL to databases behind firewalls using PuTTY or OpenSSH clients.
- [ETL: Setting Account Member Roles](https://www.integrate.io/docs/etl/setting-account-member-roles.md): Assign and manage account member roles in Integrate.io ETL. Understand admin, member, and viewer permissions for team access control.
- [ETL: SHA1](https://www.integrate.io/docs/etl/sha1.md): Calculate the SHA-1 cryptographic hash of a string value. Use SHA1 for checksums, data integrity verification, and fingerprinting in ETL jobs.
- [ETL: SHA256](https://www.integrate.io/docs/etl/sha256.md): Calculate the SHA-256 cryptographic hash of a string value. Use SHA256 for secure hashing, data integrity, and token generation in ETL pipelines.
- [ETL: SHA256WithRSA](https://www.integrate.io/docs/etl/sha256withrsa.md): Sign an input string with an RSA private key using SHA256withRSA. Use for JWT authentication and secure API integrations in ETL data pipelines.
- [ETL: SHA384](https://www.integrate.io/docs/etl/sha384.md): Calculate the SHA-384 cryptographic hash of a string value. Use SHA384 for secure hashing and data integrity verification in ETL data pipelines.
- [ETL: SHA512](https://www.integrate.io/docs/etl/sha512.md): Calculate the SHA-512 cryptographic hash of a string value. Use SHA512 for secure hashing and data integrity verification in ETL data pipelines.
- [ETL: Signing Out](https://www.integrate.io/docs/etl/signing-out-from-integrateio-etl.md): Sign out of your Integrate.io ETL account session. Follow the steps to securely log out from the web console and terminate your active session.
- [ETL: SIN](https://www.integrate.io/docs/etl/sin.md): Calculate the trigonometric sine of a numeric input value in radians. Use SIN for geometric and mathematical computations in ETL data pipelines.
- [ETL: Single Sign-On](https://www.integrate.io/docs/etl/single-sign-on.md): Configure single sign-on (SSO) for your Integrate.io ETL account using SAML 2.0. Integrate with your identity provider for team authentication.
- [ETL: SINH](https://www.integrate.io/docs/etl/sinh.md): Calculate the hyperbolic sine of a numeric value in your ETL pipeline. Use SINH for advanced mathematical computations and data transformations.
- [ETL: SIZE](https://www.integrate.io/docs/etl/size.md): Return the element count of a bag, tuple, or map, or the character length for strings. Use SIZE for data validation in ETL pipeline expressions.
- [ETL: Slack Hooks](https://www.integrate.io/docs/etl/slack-hooks.md): Set up Slack hooks for real-time Integrate.io ETL notifications. Receive job status, cluster events, and pipeline error alerts in your channels.
- [ETL: Sleep](https://www.integrate.io/docs/etl/sleep.md): Pause pipeline execution for a specified number of milliseconds. Use SLEEP to add delays between API calls or rate-limited operations in ETL jobs.
- [ETL: SPRINTF](https://www.integrate.io/docs/etl/sprintf.md): Format values using printf-style templates with the Java formatter library. Use SPRINTF for custom string formatting in ETL pipeline expressions.
- [ETL: SQRT](https://www.integrate.io/docs/etl/sqrt.md): Calculate the positive square root of a numeric expression in your ETL pipeline. Use SQRT for mathematical computations and data transformations.
- [ETL: StringToISODatetime](https://www.integrate.io/docs/etl/stringtoisodatetime.md): Convert a non-ISO datetime string to ISO 8601 format using a specified format pattern. Use for date standardization in Integrate.io ETL pipelines.
- [ETL: STRSPLIT](https://www.integrate.io/docs/etl/strsplit.md): Split a string into a tuple of substrings using a specified delimiter character. Use STRSPLIT for parsing delimited text data in ETL pipelines.
- [ETL: STRSPLITTOBAG](https://www.integrate.io/docs/etl/strsplittobag.md): Split a string into a bag (array) of substrings using a specified delimiter. Use STRSPLITTOBAG for parsing multi-value fields in ETL data pipelines.
- [ETL: SUBSTRING](https://www.integrate.io/docs/etl/substring.md): Extract a portion of a string field by specifying start position and optional length. Use SUBSTRING for text parsing in ETL pipeline expressions.
- [ETL: SubtractDuration](https://www.integrate.io/docs/etl/subtractduration.md): Subtract a duration string expression from a datetime value and return the result. Use SUBTRACTDURATION for date arithmetic in ETL data pipelines.
- [ETL: SwitchTimeZone](https://www.integrate.io/docs/etl/switchtimezone.md): Use the SwitchTimezone expression function in Integrate.io ETL to convert datetime values between time zones inside your pipeline transformations.
- [ETL: System and Pre-Defined Variables](https://www.integrate.io/docs/etl/system-and-pre-defined-variables.md): Reference for system and pre-defined variables in Integrate.io ETL expressions. Access job ID, package name, cluster info, and runtime metadata.
- [ETL: TAN](https://www.integrate.io/docs/etl/tan.md): Calculate the trigonometric tangent of a numeric input in radians. Use TAN for geometric and mathematical computations in ETL pipeline expressions.
- [ETL: TANH](https://www.integrate.io/docs/etl/tanh.md): Calculate the hyperbolic tangent of a numeric value in your ETL pipeline. Use TANH for sigmoid-like mathematical transformations in data processing.
- [ETL: Xplenty : 지금 사용할 수있는 편리한 템플릿 목록](https://www.integrate.io/docs/etl/templates-part01-ko.md): Integrate.io ETL이 제공하는 사전 정의 템플릿 목록을 소개하고, Adroll 등 다양한 마케팅 데이터 소스를 Redshift 같은 DWH로 신속하게 통합하는 데 활용하는 방법을 자세히 설명합니다. Integrate.io 사용자 가이드의 한 항목입니다.
- [ETL: Xplenty에서 Youtube Report API 데이터 가져오기](https://www.integrate.io/docs/etl/templates-part02-ko.md): Integrate.io ETL의 템플릿 기능을 활용해 YouTube Reporting API에서 다양한 매개변수를 지정하고 채널 통계와 시청 데이터를 추출하는 데이터 파이프라인을 빠르게 구축하는 방법을 자세히 설명합니다. 자세한 화면과 예시도 함께 정리했습니다.
- [ETL: Xplenty 템플릿을 사용하여 간편하게 데이터 연계 : Taboola> 데이터 웨어 하우스편](https://www.integrate.io/docs/etl/templates-part03-ko.md): Integrate.io ETL의 사전 정의 템플릿을 사용하여 Taboola의 광고 캠페인 데이터를 Redshift, BigQuery, Snowflake 같은 데이터 웨어하우스나 데이터베이스로 손쉽게 통합하는 방법을 자세히 소개합니다.
- [ETL: 클라우드 ETL 'Xplenty'를 사용한 Shopify 데이터 획득부터 시각화까지](https://www.integrate.io/docs/etl/templates-part04-ko.md): Integrate.io ETL을 사용해 Shopify의 REST API로 데이터를 추출하고 Google Data Studio로 시각화하기까지의 두 편의 일본어 블로그 내용을 한국어 가이드로 한 번에 정리해 소개합니다. 운영 시 참고할 수 있도록 단계별로 정리했습니다.
- [ETL: Terminating a Cluster](https://www.integrate.io/docs/etl/terminating-a-cluster.md): Terminate an Integrate.io ETL cluster to stop all running jobs and release compute resources. Understand the effects of cluster termination.
- [ETL: TimestampFormatToISODatetime](https://www.integrate.io/docs/etl/timestampformattoisodatetime.md): Convert a JDBC timestamp format string (yyyy-MM-dd HH:mm:ss) to ISO 8601 format. Use for date standardization in Integrate.io ETL pipelines.
- [ETL: Viewing Job Progress Details](https://www.integrate.io/docs/etl/to-view-job-progress-details.md): View detailed job progress in Integrate.io ETL, including per-component task status, record counts, and real-time execution metrics for each step.
- [ETL: TOBAG](https://www.integrate.io/docs/etl/tobag.md): Convert one or more expressions into a bag (array) data type. Use TOBAG for creating collections from individual values in ETL data pipelines.
- [ETL: ToDate](https://www.integrate.io/docs/etl/todate.md): Convert an input string to a datetime data type based on a specified format pattern. Use TODATE for date parsing in Integrate.io ETL pipelines.
- [ETL: ToDateCustomFormats](https://www.integrate.io/docs/etl/todatecustomformats.md): Convert a datetime string to datetime data type using the first matching format from a list of custom patterns. Flexible date parsing for ETL jobs.
- [ETL: ToHexString](https://www.integrate.io/docs/etl/tohexstring.md): Convert an integer argument to its hexadecimal string representation in base 16. Use TOHEXSTRING for encoding and data formatting in ETL pipelines.
- [ETL: ToJson](https://www.integrate.io/docs/etl/tojson.md): Serialize any input value into a JSON-formatted string. Use TOJSON for JSON output formatting and API payload construction in ETL data pipelines.
- [ETL: TOKENIZE](https://www.integrate.io/docs/etl/tokenize.md): Use the Tokenize expression function in Integrate.io ETL to split a string into tokens by delimiter for parsing CSV-like fields and array transformations.
- [ETL: TOMAP](https://www.integrate.io/docs/etl/tomap.md): Convert key-value expression pairs into a map data type structure. Use TOMAP for building lookup structures in Integrate.io ETL data pipelines.
- [ETL: ToMilliSeconds](https://www.integrate.io/docs/etl/tomilliseconds.md): Convert a datetime value to the number of milliseconds elapsed since the Unix epoch (1970-01-01T00:00:00Z). Use for timestamp arithmetic in ETL.
- [ETL: ToString](https://www.integrate.io/docs/etl/tostring.md): Convert a datetime field to an ISO-8601 string or a custom date format. Use TOSTRING for date formatting and output preparation in ETL pipelines.
- [ETL: TOTUPLE](https://www.integrate.io/docs/etl/totuple.md): Convert one or more expressions into a tuple data type. Use TOTUPLE for grouping related values into structured records in ETL data pipelines.
- [ETL: ToUnixTime](https://www.integrate.io/docs/etl/tounixtime.md): Convert a datetime value to Unix time (seconds since epoch). Use TOUNIXTIME for timestamp conversions and epoch calculations in ETL data pipelines.
- [ETL: TRIM](https://www.integrate.io/docs/etl/trim.md): Remove leading and trailing whitespace characters from a string field value. Use TRIM for cleaning and normalizing imported text data in ETL jobs.
- [ETL: UCFIRST](https://www.integrate.io/docs/etl/ucfirst.md): Convert the first character of a string to uppercase while preserving the remaining characters. Use UCFIRST for text formatting in ETL pipelines.
- [ETL: UPPER](https://www.integrate.io/docs/etl/upper.md): Convert all characters in a string expression to uppercase. Use UPPER for case normalization and standardization in Integrate.io ETL data pipelines.
- [ETL: URLDecode](https://www.integrate.io/docs/etl/urldecode.md): Decode a URL-encoded (percent-encoded) string back to its original form. Use URLDECODE for processing web data in Integrate.io ETL data pipelines.
- [ETL: URLEncode](https://www.integrate.io/docs/etl/urlencode.md): Encode a string expression for safe use in URLs using percent encoding. Use URLENCODE for building API query parameters in ETL data pipelines.
- [ETL: User Management](https://www.integrate.io/docs/etl/user-management-overview.md): Overview of user roles and permissions in Integrate.io ETL. Understand admin, member, and viewer access levels for team and account management.
- [ETL: Using and Setting Variables](https://www.integrate.io/docs/etl/using-and-setting-variables-in-your-packages.md): Define, set, and use variables in Integrate.io ETL packages. Pass runtime parameters to jobs and reference dynamic values in your expressions.
- [ETL: Aggregate Transformation](https://www.integrate.io/docs/etl/using-components-aggregate-transformation.md): Use the Aggregate transformation to group data by fields and apply functions like Count, Average, Min, and Max in your ETL pipeline.
- [ETL: AI Transformation](https://www.integrate.io/docs/etl/using-components-ai-transformation.md): Use the AI Transformation to apply LLM-powered data processing to fields in your Integrate.io ETL pipeline. Supports custom prompts and models.
- [ETL: Amazon Redshift Destination](https://www.integrate.io/docs/etl/using-components-amazon-redshift-destination.md): Configure the Amazon Redshift destination component to write pipeline output data into Redshift tables in your Integrate.io ETL pipeline.
- [ETL: Amazon Redshift Source](https://www.integrate.io/docs/etl/using-components-amazon-redshift-source.md): Configure the Amazon Redshift source component to read data from Redshift tables and views in your Integrate.io ETL data pipeline.
- [ETL: Assert Transformation](https://www.integrate.io/docs/etl/using-components-assert-transformation.md): Use the Assert transformation to validate that all records meet specified conditions. Non-compliant records cause the ETL job to fail with errors.
- [ETL: Bing Ads Source](https://www.integrate.io/docs/etl/using-components-bing-ads-source.md): Configure the Bing Ads source component to read Microsoft Advertising report data in your Integrate.io ETL pipeline. Supports campaign metrics.
- [ETL: CDC Database Source](https://www.integrate.io/docs/etl/using-components-cdc-database-source.md): Configure the CDC Database source component to read change data capture records from databases in your Integrate.io ETL data pipeline.
- [ETL: Clone Transformation](https://www.integrate.io/docs/etl/using-components-clone-transformation.md): Use the Clone component to split a dataflow into two (or more) dataflows in order to apply multiple transformations to the same data.
- [ETL: Crisp Chat Source](https://www.integrate.io/docs/etl/using-components-crisp-chat-source.md): Configure the Crisp Chat source component in Integrate.io ETL to extract conversations, contacts, and chat events into your data pipelines and warehouse.
- [ETL: Cross Join Transformation](https://www.integrate.io/docs/etl/using-components-cross-join-transformation.md): Use the Cross Join transformation to produce a Cartesian product by combining every record from two inputs in your ETL data pipeline.
- [ETL: Cube Transformation](https://www.integrate.io/docs/etl/using-components-cube-transformation.md): Use the Cube and Rollup transformation to group data by field combinations and apply aggregate functions like Count, Average, Min, and Max.
- [ETL: Database Destination](https://www.integrate.io/docs/etl/using-components-database-destination.md): Configure the Database destination to write data into PostgreSQL, MySQL, SQL Server, Oracle, or DB2 tables in your Integrate.io ETL pipeline.
- [ETL: Database Source](https://www.integrate.io/docs/etl/using-components-database-source.md): Configure the Database source to read data from PostgreSQL, MySQL, SQL Server, Oracle, or DB2 tables and views in your Integrate.io ETL pipeline.
- [ETL: Distinct Transformation](https://www.integrate.io/docs/etl/using-components-distinct-transformation.md): Use the Distinct transformation to remove duplicate records from your data, keeping only unique rows based on all field values in ETL pipelines.
- [ETL: Execute SQL](https://www.integrate.io/docs/etl/using-components-execute-sql-workflow.md): The Execute SQL workflow component runs a SQL statement as a step in your workflow. Use it to perform database operations between package executions.
- [ETL: Facebook Ads Destination](https://www.integrate.io/docs/etl/using-components-facebook-ads-destination.md): Use the Facebook destination component to store the output of a data flow in Facebook cloud object. The destination component uses Facebook ads API.
- [ETL: Facebook Ads Insights Source](https://www.integrate.io/docs/etl/using-components-facebook-ads-insights-source.md): Configure the Facebook Ads Insights source component to read ad performance and campaign report data in your Integrate.io ETL data pipeline.
- [ETL: File Mover](https://www.integrate.io/docs/etl/using-components-file-mover-workflow.md): Configure the File Mover workflow component to move or rename files between storage locations as an automated step in your ETL workflow.
- [ETL: File Storage Destination](https://www.integrate.io/docs/etl/using-components-file-storage-destination.md): Configure the File Storage destination to write data to Amazon S3, Google Cloud Storage, Azure Blob Storage, or SFTP in your ETL pipeline.
- [ETL: File Storage Source](https://www.integrate.io/docs/etl/using-components-file-storage-source.md): Configure the File Storage source to read files from Amazon S3, Google Cloud Storage, Azure Blob Storage, or SFTP servers in your ETL pipeline.
- [ETL: Filter Transformation](https://www.integrate.io/docs/etl/using-components-filter-transformation.md): Use the Filter transformation to include or exclude records based on conditional expressions. Define rules to control data flow in pipelines.
- [ETL: Google Ads Destination](https://www.integrate.io/docs/etl/using-components-google-ads-destination.md): Use Google Ads destination component to store the output from data flow in Google Ads Object. The destination component uses Google Ads API.
- [ETL: Google Ads Source](https://www.integrate.io/docs/etl/using-components-google-ads-source.md): Configure the Google Ads source component to read advertising report data from your Google Ads account in Integrate.io ETL data pipelines.
- [ETL: Google Analytics 4 (GA4) Source](https://www.integrate.io/docs/etl/using-components-google-analytics-4-ga4-source.md): Configure the Google Analytics 4 source component to read analytics report data from your GA4 property in Integrate.io ETL data pipelines.
- [ETL: Google Analytics Source](https://www.integrate.io/docs/etl/using-components-google-analytics-source.md): Configure the Google Analytics source component to read web analytics report data from your GA account in Integrate.io ETL data pipelines.
- [ETL: Google BigQuery Destination](https://www.integrate.io/docs/etl/using-components-google-bigquery-destination.md): Configure the Google BigQuery destination to write data flow output into BigQuery tables via Cloud Storage staging in your ETL data pipeline.
- [ETL: Google BigQuery Source](https://www.integrate.io/docs/etl/using-components-google-bigquery-source.md): Configure the Google BigQuery source component to read data from BigQuery tables or run queries in your Integrate.io ETL data pipeline.
- [ETL: Google Cloud Spanner Source](https://www.integrate.io/docs/etl/using-components-google-cloud-spanner-source.md): Configure the Google Cloud Spanner source component to read data from Spanner tables or queries in your Integrate.io ETL data pipeline.
- [ETL: Gmail Source](https://www.integrate.io/docs/etl/using-components-google-mail-gmail-source.md): Configure the Gmail source component in Integrate.io ETL to extract email messages, threads, and labels using OAuth into your data pipelines.
- [ETL: Google Sheets Destination](https://www.integrate.io/docs/etl/using-components-google-sheets-destination.md): Configure the Google Sheets destination component in Integrate.io ETL to write pipeline output to a spreadsheet with OAuth, target range, and append modes.
- [ETL: Google Sheets Source](https://www.integrate.io/docs/etl/using-components-google-sheets-source.md): Configure the Google Sheets source component in Integrate.io ETL to read spreadsheet data with OAuth authentication, sheet selection, and cell range options.
- [ETL: Google Spanner Destination](https://www.integrate.io/docs/etl/using-components-google-spanner-destination.md): Configure the Google Cloud Spanner destination component to write data flow output into a Spanner table in your Integrate.io ETL pipeline.
- [ETL: HubSpot Destination](https://www.integrate.io/docs/etl/using-components-hubspot-destination.md): Configure the HubSpot destination component to write data flow output into HubSpot CRM objects in your Integrate.io ETL data pipeline.
- [ETL: Join Transformation](https://www.integrate.io/docs/etl/using-components-join-transformation.md): Use the Join transformation to combine records from two inputs based on matching key fields. Supports inner, left, right, and full outer joins.
- [ETL: Limit Transformation](https://www.integrate.io/docs/etl/using-components-limit-transformation.md): Use the Limit transformation to cap output records globally or per partition. Get top-N items, remove duplicates, or subset data for testing.
- [ETL: MongoDB Destination](https://www.integrate.io/docs/etl/using-components-mongodb-destination.md): Configure the MongoDB destination component to write data flow output into a MongoDB collection in your Integrate.io ETL data pipeline.
- [ETL: MongoDB Source](https://www.integrate.io/docs/etl/using-components-mongodb-source.md): Configure the MongoDB source component to read data from MongoDB collections and run queries in your Integrate.io ETL data pipeline.
- [ETL: Mouseflow Source](https://www.integrate.io/docs/etl/using-components-mouseflow-source.md): Configure the Mouseflow source component in Integrate.io ETL to read websites, recordings, funnels, forms, and feedback into your data pipeline.
- [ETL: Netsuite SOAP Destination](https://www.integrate.io/docs/etl/using-components-netsuite-soap-destination.md): Configure the NetSuite SOAP destination component to write data into NetSuite objects via the SOAP API in your Integrate.io ETL pipeline.
- [ETL: NetSuite Source](https://www.integrate.io/docs/etl/using-components-netsuite-source.md): Use the NetSuite source component to read NetSuite standard and custom records (tables) using the NetSuite JDBC drivers (SuiteAnalytics Connect).
- [ETL: PDF to CSV](https://www.integrate.io/docs/etl/using-components-pdf-to-csv-workflow.md): Configure the PDF to CSV workflow component to convert PDF files into CSV format as an automated step in your Integrate.io ETL workflow.
- [ETL: Pivot Transformation](https://www.integrate.io/docs/etl/using-components-pivot-transformation.md): Use the Pivot transformation to transpose rows into columns, converting unique field values into separate output columns in ETL pipelines.
- [ETL: Python Transformation](https://www.integrate.io/docs/etl/using-components-python-transformation.md): Use the Python Transformation to run custom Python code for data processing as part of your Integrate.io ETL pipeline. Supports pandas.
- [ETL: Rank Transformation](https://www.integrate.io/docs/etl/using-components-rank-transformation.md): Use the Rank component to sort input data by one or more fields, in an ascending or descending order and add a rank field that reflects the sort order.
- [ETL: REST API Destination](https://www.integrate.io/docs/etl/using-components-rest-api-destination.md): How to configure the REST API component to write data in your Integrate.io ETL pipeline.
- [ETL: REST API Source](https://www.integrate.io/docs/etl/using-components-rest-api-source.md): Configure the REST API source component to read data from HTTP endpoints and web services. Supports pagination and authentication methods.
- [ETL: Run Package](https://www.integrate.io/docs/etl/using-components-run-package-workflow.md): Use the Run Package workflow component to execute another package as a sub-task within your Integrate.io ETL workflow. Chain pipeline steps.
- [ETL: Salesforce Destination](https://www.integrate.io/docs/etl/using-components-salesforce-destination.md): Configure the Salesforce destination to write data into Salesforce Sales Cloud objects via the Bulk API in your Integrate.io ETL data pipeline.
- [ETL: Salesforce Source](https://www.integrate.io/docs/etl/using-components-salesforce-source.md): Configure the Salesforce source to read standard and custom objects using the Bulk API. Supports SOQL queries and incremental data loading.
- [ETL: Sample Transformation](https://www.integrate.io/docs/etl/using-components-sample-transformation.md): Use the Sample transformation to return a random percentage of input records for testing or data sampling in your Integrate.io ETL pipeline.
- [ETL: Select Transformation](https://www.integrate.io/docs/etl/using-components-select-transformation.md): Configure the Select transformation in Integrate.io ETL to choose, rename, reorder, and compute fields with expressions before passing data downstream.
- [ETL: SharePoint Source](https://www.integrate.io/docs/etl/using-components-sharepoint-source.md): Configure the SharePoint source component in Integrate.io ETL to read documents and list items from Microsoft SharePoint into your data pipelines.
- [ETL: Snowflake Destination](https://www.integrate.io/docs/etl/using-components-snowflake-destination.md): Configure the Snowflake destination to write data into Snowflake tables via S3 staging and the COPY command in your Integrate.io ETL pipeline.
- [ETL: Snowflake Source](https://www.integrate.io/docs/etl/using-components-snowflake-source.md): Configure the Snowflake source component to read data from Snowflake tables and views in your Integrate.io ETL data pipeline for processing.
- [ETL: Sort Transformation](https://www.integrate.io/docs/etl/using-components-sort-transformation.md): Use the Sort transformation to order records by one or more fields in ascending or descending order in your Integrate.io ETL data pipeline.
- [ETL: Split Transformation](https://www.integrate.io/docs/etl/using-components-split-transformation.md): Use the Split transformation to divide a single data stream into multiple output streams based on conditional rules in your ETL pipeline.
- [ETL: SugarCRM Source](https://www.integrate.io/docs/etl/using-components-sugarcrm-source.md): How to configure the SugarCRM component to read CRM data (Accounts, Contacts, Leads, and custom modules) in your Integrate.io ETL pipeline.
- [ETL: TikTok Ads Destination](https://www.integrate.io/docs/etl/using-components-tiktok-ads-destination.md): Use the TiktokAds destination component to store the output of a data flow in TiktokAds cloud object. The destination component uses TiktokAds API.
- [ETL: Union Transformation](https://www.integrate.io/docs/etl/using-components-union-transformation.md): Use the Union transformation to merge records from two inputs with identical schemas into a single output stream in your ETL data pipeline.
- [ETL: Unpivot Transformation](https://www.integrate.io/docs/etl/using-components-unpivot-transformation.md): Use the Unpivot transformation to transpose columns into rows, converting multiple columns into key-value pairs in your ETL data pipeline.
- [ETL: Window Transformation](https://www.integrate.io/docs/etl/using-components-window-transformation.md): Use the Window transformation to apply SQL-style window functions like ranking, moving averages, and running totals to your ETL pipeline data.
- [ETL: Using Expressions](https://www.integrate.io/docs/etl/using-expressions-in-integrateio-etl.md): Learn how to write and use expressions in Integrate.io ETL pipelines. Build formulas with functions, operators, and field references in components.
- [ETL: ISO 8601 String Functions](https://www.integrate.io/docs/etl/using-iso-8601-string-functions.md): Guide to using ISO 8601 datetime string functions in Integrate.io ETL. Parse, format, truncate, and manipulate ISO dates in pipeline expressions.
- [ETL: Pattern Matching in Source Paths](https://www.integrate.io/docs/etl/using-pattern-matching-in-source-component-paths.md): Use glob pattern matching in file storage source component paths to select multiple files. Supports wildcards and pattern-based file selection.
- [ETL: UUID](https://www.integrate.io/docs/etl/uuid.md): Generate a universally unique identifier (UUID) string value. Use UUID for creating unique record identifiers in Integrate.io ETL pipeline jobs.
- [ETL: Validating a Package](https://www.integrate.io/docs/etl/validating-a-package.md): Validate your Integrate.io ETL package before running it. Check for configuration errors, missing connections, and component issues automatically.
- [ETL: Viewing All Jobs in the Account](https://www.integrate.io/docs/etl/viewing-all-jobs-in-the-account.md): View and filter all jobs running or completed across every cluster in your Integrate.io ETL account. Monitor pipeline job status from one page.
- [ETL: Billing and Account Usage](https://www.integrate.io/docs/etl/viewing-and-modifying-your-billing-information-and-account-usage.md): View and update your Integrate.io ETL billing details, credit card information, and account usage metrics from the account settings page.
- [ETL: Web and Email Notifications](https://www.integrate.io/docs/etl/viewing-and-setting-web-and-email-notifications.md): Configure web and email notifications for cluster and job events in Integrate.io ETL. Choose which pipeline events trigger alerts to your inbox.
- [ETL: Viewing Completed Task Outputs](https://www.integrate.io/docs/etl/viewing-completed-tasks-outputs.md): View output data from completed tasks in an Integrate.io ETL job. Inspect records processed by each component after job execution finishes.
- [ETL: Viewing Job Error Details](https://www.integrate.io/docs/etl/viewing-job-error-details-for-failed-jobs.md): View detailed error messages and stack traces for failed Integrate.io ETL jobs. Diagnose pipeline failures using job error details and logs.
- [ETL: WeeksBetween](https://www.integrate.io/docs/etl/weeksbetween.md): Calculate the number of weeks between two datetime values. Use WEEKSBETWEEN for weekly period analysis and reporting in ETL pipeline expressions.
- [ETL: Package Designer](https://www.integrate.io/docs/etl/working-in-the-new-package-designer.md): Use the Integrate.io ETL package designer to build and configure data pipelines visually. Edit package name, description, and component layout.
- [ETL: Working in the Package Designer](https://www.integrate.io/docs/etl/working-in-the-package-designer.md): Use the Integrate.io ETL package designer to build pipelines visually: add sources, transformations, and destinations, and connect components on the canvas.
- [ETL: Workspaces](https://www.integrate.io/docs/etl/workspaces.md): Learn about Integrate.io ETL workspaces for organizing packages, connections, and team resources. Separate environments for your data projects.
- [ETL: XPath](https://www.integrate.io/docs/etl/xpath.md): Extract data from an XML document using an XPath expression. Use XPATH for XML parsing and data extraction in Integrate.io ETL data pipelines.
- [ETL: XPathToBag](https://www.integrate.io/docs/etl/xpathtobag.md): Extract all matching nodes from an XML document as a bag using an XPath expression. Use XPATHTOBAG for XML array extraction in ETL data pipelines.
- [ETL: YearsBetween](https://www.integrate.io/docs/etl/yearsbetween.md): Calculate the number of years between two datetime values using a fractional rounding approach. Compare with DATEDIFFYEARS for different behavior.

## OpenAPI Specs

- [integrateio-openapi](https://www.integrate.io/docs/integrateio-openapi.yaml)
- [openapi](https://www.integrate.io/docs/api-reference/openapi.json)

## Optional

- [Contact Us](mailto:support@integrate.io)
- [Blog](https://www.integrate.io/blog/)