# 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. Set up change data capture from PostgreSQL, MySQL, Salesforce, and 60+ sources to Snowflake, Redshift, BigQuery, and S3.
- [ELT/CDC: Sources - Adobe Analytics](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.
- [ELT/CDC: Sources - AdRoll](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.
- [ELT/CDC: Sources - Airtable](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.
- [ELT/CDC: Sources - Algolia](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.
- [ELT/CDC: Sources - Amazon Ads](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.
- [ELT/CDC: Sources - Amazon Marketplace](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.
- [ELT/CDC: Sources - MySQL - Amazon RDS MySQL](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.
- [ELT/CDC: Sources - PostgreSQL - Amazon RDS PostgreSQL](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.
- [ELT/CDC: Destinations - Amazon Redshift](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.
- [ELT/CDC: Sources - MySQL - Aurora MySQL](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.
- [ELT/CDC: Sources - Aurora PostgreSQL](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): How to use the Auto Sync New Tables feature to automatically detect and replicate new tables in Integrate.io ELT and CDC.
- [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.
- [ELT/CDC: Available Metrics Types - Replication Delay](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.
- [ELT/CDC: Available Metrics Types - Sync Lag Metric](https://www.integrate.io/docs/cdc/available-metrics-types-sync-lag-metric.md): How the Sync Lag metric measures the data volume difference between source and pipeline in Integrate.io ELT & CDC.
- [ELT/CDC: Sources - AWS RDS Oracle](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.
- [ELT/CDC: Sources - Azure MySQL](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.
- [ELT/CDC: Sources - PostgreSQL - Azure PostgreSQL](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.
- [ELT/CDC: Sources - BigCommerce](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.
- [ELT/CDC: Destinations - BigQuery](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.
- [ELT/CDC: Sources - BigQuery](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.
- [ELT/CDC: Sources - Bing Ads](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.
- [ELT/CDC: Sources - Braintree](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.
- [ELT/CDC: Sources - Cybersource](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.
- [ELT/CDC: Data Observability - Alerts](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.
- [ELT/CDC: Data Observability - FAQs](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.
- [ELT/CDC: Data Observability - Getting Started](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.
- [ELT/CDC: Data Observability - Metrics](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.
- [ELT/CDC: Data Observability - Data Stores](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.
- [ELT/CDC: Monitoring - Data Type Changes - Redshift](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.
- [ELT/CDC: Monitoring - Data Type Changes - Snowflake](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.
- [ELT/CDC: Monitoring - Data Type Mapping - BigQuery](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.
- [ELT/CDC: Monitoring - Data Type Mapping - Redshift](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.
- [ELT/CDC: Monitoring - Data Type Mapping](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.
- [ELT/CDC: Monitoring - Data Type Mapping - Snowflake](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.
- [ELT/CDC: Sources - Delighted](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.
- [ELT/CDC: Sources - Drip](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.
- [ELT/CDC: Sources - eBay](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.
- [ELT/CDC: Sources - EnquireLabs](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.
- [ELT/CDC: Sources - ExchangeRates](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.
- [ELT/CDC: Sources - Facebook Ads](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.
- [ELT/CDC: Sources - Facebook Pages](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.
- [ELT/CDC: Sources - GitHub](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.
- [ELT/CDC: Sources - GitLab](https://www.integrate.io/docs/cdc/gitlab.md): How to set up and configure GitLab as a data source in Integrate.io ELT & CDC.
- [ELT/CDC: Sources - Google Ads](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.
- [ELT/CDC: Sources - Google Ads Change Log](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.
- [ELT/CDC: Sources - Google Analytics](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.
- [ELT/CDC: Sources - Google Analytics 360 (GA360)](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.
- [ELT/CDC: Sources - Google Analytics 4](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.
- [ELT/CDC: Sources - Google Analytics 4 Export (GA4 Export)](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.
- [ELT/CDC: Sources - Google Cloud SQL MySQL](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.
- [ELT/CDC: Sources - Google Cloud SQL for PostgreSQL](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.
- [ELT/CDC: Security - Google Privacy Policy](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.
- [ELT/CDC: Sources - Google Search Console](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.
- [ELT/CDC: Sources - Google Sheets](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.
- [ELT/CDC: Sources - Gorgias](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): How to enable History Mode (SCD Type 2) in Integrate.io ELT & CDC to track a complete history of all record changes over time.
- [ELT/CDC: Monitoring - Hooks](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 and CDC handles schema changes such as column additions, deletions, and renames during replication.
- [ELT/CDC: Destinations - 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.
- [ELT/CDC: Sources - HubSpot](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.
- [ELT/CDC: Security - IP List](https://www.integrate.io/docs/cdc/ip-list.md): IP addresses to allowlist for Integrate.io CDC access to your source and destination by region.
- [ELT/CDC: Sources - JudgeMe](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.
- [ELT/CDC: Sources - Klaviyo](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.
- [ELT/CDC: Sources - Microsoft SQL Server](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.
- [ELT/CDC: Sources - MySQL](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.
- [ELT/CDC: Sources - NetSuite](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.
- [ELT/CDC: Data Observability - Nomenclature](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.
- [ELT/CDC: Sources - Onfleet](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.
- [ELT/CDC: Sources - Oracle 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.
- [ELT/CDC: Sources - Oracle CDC - Self-hosted](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.
- [ELT/CDC: Sources - PostgreSQL](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.
- [ELT/CDC: Security - PrivateLink setup for Postgresql](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.
- [ELT/CDC: Security - PrivateLink setup for MySQL](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.
- [ELT/CDC: Sources - Intuit Quickbooks](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.
- [ELT/CDC: Sources - ReCharge](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.
- [ELT/CDC: Transforms - Replacement Rules](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.
- [ELT/CDC: Security - Reverse SSH Tunnel](https://www.integrate.io/docs/cdc/reverse-ssh-tunnel.md): How to set up a reverse SSH tunnel for secure database connections in Integrate.io ELT & CDC.
- [ELT/CDC: Destinations - Amazon S3 Setting up your Bucket](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.
- [ELT/CDC: Sources - S3](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.
- [ELT/CDC: Sources - Salesforce](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.
- [ELT/CDC: Sources - MySQL - Self-hosted MySQL](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.
- [ELT/CDC: Sources - Self-hosted PostgreSQL](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.
- [ELT/CDC: Sources - Shippo](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.
- [ELT/CDC: Sources - Shopify](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.
- [ELT/CDC: Destinations - Snowflake](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.
- [ELT/CDC: Sources - Square](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.
- [ELT/CDC: Security - SSH Tunnel](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.
- [ELT/CDC: Sources - Stripe](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.
- [ELT/CDC: Sources - Tiktok Ads](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.
- [ELT/CDC: Getting Started - 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.
- [ELT/CDC: Sources - Yotpo](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.
- [ELT/CDC: Sources - Zenventory](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): How to connect Integrate.io ETL to Facebook Ads Insights for reading data in your pipelines.
- [ETL: Connecting to Google Analytics 4 (GA4)](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-google-analytics-4-ga4.md): How to connect Integrate.io ETL to Google Analytics 4 for reading data in your pipelines.
- [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): How to connect Integrate.io ETL to your Gmail account using OAuth for reading email data.
- [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): How to connect Integrate.io ETL to HubSpot using a service token for API access.
- [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): How to connect Integrate.io ETL to MongoDB for reading data in your pipelines.
- [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): How to connect Integrate.io ETL to Bing Ads for reading data in 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): How to connect Integrate.io ETL to Google Ads for reading data in your pipelines.
- [ETL: Connecting to Google Analytics](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-google-analytics.md): How to connect Integrate.io ETL to Google Analytics for reading data in 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 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): How to create a LinkedIn connection and build a data pipeline to read LinkedIn data in Integrate.io ETL.
- [ETL: Connecting to Salesforce](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-salesforce.md): How to connect Integrate.io ETL to Salesforce for reading 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): How to connect Integrate.io ETL to Salesforce via SOAP for reading data in your pipelines.
- [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): How to connect Integrate.io ETL to Salesforce using customer-managed OAuth credentials.
- [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): How to connect Integrate.io ETL to Microsoft SharePoint for reading document and list data.
- [ETL: Connecting to Shopify](https://www.integrate.io/docs/etl/allowing-integrateio-etl-access-to-my-data-on-shopify.md): How to create a Shopify connection and build a data pipeline to read Shopify data in Integrate.io ETL.
- [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): How to connect Integrate.io ETL to Google BigQuery for reading data 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): How to connect Integrate.io ETL to Amazon Redshift for reading 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): How to connect Integrate.io ETL to Snowflake for reading and writing 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): How to connect Integrate.io ETL to NetSuite for reading data in 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): How to connect Integrate.io ETL to NetSuite via SOAP for reading data in 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): Security settings, access controls, and account configuration for Integrate.io ETL.
- [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 alerts and notification channels for monitoring Integrate.io ETL pipelines.
- [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): API access and webhook integrations for Integrate.io ETL.
- [ETL: Clusters](https://www.integrate.io/docs/etl/category/clusters.md): Managing and configuring clusters for running Integrate.io ETL jobs.
- [ETL: Configuring Your Environment](https://www.integrate.io/docs/etl/category/configuring-your-integrateio-etl-environment.md): Account settings and environment configuration for Integrate.io ETL.
- [ETL: Connectivity and Security](https://www.integrate.io/docs/etl/category/connectivity-and-security.md): Connection guides and security configuration for Integrate.io ETL data sources.
- [ETL: Creating Packages](https://www.integrate.io/docs/etl/category/creating-packages.md): How to create and configure data pipeline packages in Integrate.io ETL.
- [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](https://www.integrate.io/docs/etl/category/getting-started.md): Get started with Integrate.io ETL. Learn core concepts like connections, packages, clusters, and jobs, and build your first data pipeline.
- [ETL: How Do I](https://www.integrate.io/docs/etl/category/how-do-i.md): Common questions and getting started guides for Integrate.io ETL.
- [ETL: New Releases](https://www.integrate.io/docs/etl/category/new-releases.md): Release notes and new feature announcements for Integrate.io ETL.
- [ETL: Other](https://www.integrate.io/docs/etl/category/other.md): Additional resources and reference material for Integrate.io ETL.
- [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, API usage, and webhook configuration for Integrate.io ETL.
- [ETL: Running and Monitoring Jobs](https://www.integrate.io/docs/etl/category/running-and-monitoring-jobs.md): How to run, monitor, and troubleshoot jobs in Integrate.io ETL.
- [ETL: Scheduling and Jobs](https://www.integrate.io/docs/etl/category/scheduling-and-jobs.md): Scheduling, running, and managing jobs in Integrate.io ETL.
- [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): How to provision and manage clusters for Integrate.io ETL pipelines.
- [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)
- [ETL: Google BigQuery 커넥터에 대한 질문 요약](https://www.integrate.io/docs/etl/connector-part02-ko.md)
- [ETL: Zendesk Support Ticket 데이터를 Redshift에 로드](https://www.integrate.io/docs/etl/connector-part03-ko.md)
- [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): How to create an API-managed workflow that extracts Salesforce data and delivers it to SFTP.
- [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: CCurlWithPagination](https://www.integrate.io/docs/etl/curlwithpagination.md): Make paginated REST API calls and combine all page responses into a single result. Use CURLWITHPAGINATION for multi-page API data ingestion.
- [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): Returns a datetime value that is the result of adding a specified number of days to a datetime expression.
- [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)
- [ETL: Xplenty에서 2FA 사용](https://www.integrate.io/docs/etl/etc-part02-ko.md)
- [ETL: Xplenty 단축키](https://www.integrate.io/docs/etl/etc-part03-ko.md)
- [ETL: Xplenty에서 JOIN 처리의 고속화 방법](https://www.integrate.io/docs/etl/etc-part04-ko.md)
- [ETL: Xplenty로 XML 데이터 처리](https://www.integrate.io/docs/etl/etc-part05-ko.md)
- [ETL: Xplenty Job의 고속화 요령](https://www.integrate.io/docs/etl/etc-part06-ko.md)
- [ETL: Xplenty 패키지 및 잡의 검색방법에 대하여](https://www.integrate.io/docs/etl/etc-part07-ko.md)
- [ETL: Xplenty-Console 사용법](https://www.integrate.io/docs/etl/etc-part08-ko.md)
- [ETL: Xplenty의 디버깅 방법 - Integrate.io Blog](https://www.integrate.io/docs/etl/etc-part09-ko.md)
- [ETL: Xplenty에서 개인 정보를 마스킹하는 방법](https://www.integrate.io/docs/etl/etc-part10-ko.md)
- [ETL: Xplenty의 장애전달에 대하여](https://www.integrate.io/docs/etl/etc-part11-ko.md)
- [ETL: Xplenty의 클러스터와 노드에 대해 알아 봅시다!](https://www.integrate.io/docs/etl/etc-part12-ko.md)
- [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)
- [ETL: Excel 데이터를 로드하는 방법](https://www.integrate.io/docs/etl/filestorage-part02-ko.md)
- [ETL: Parquet 형식으로 대용량 데이터 저장 용량과 처리 시간을 절약할 수 있습니다!](https://www.integrate.io/docs/etl/filestorage-part03-ko.md)
- [ETL: Parquet 형식의 대용량 데이터 불러오기](https://www.integrate.io/docs/etl/filestorage-part04-ko.md)
- [ETL: File Upload 소스로 즉시 ETL을 써보기](https://www.integrate.io/docs/etl/filestorage-part05-ko.md)
- [ETL: 데이터 전송 후 파일 이동 및 삭제 기능 활용하기](https://www.integrate.io/docs/etl/filestorage-part06-ko.md)
- [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): How to process non-UTF-8 character encodings in Integrate.io ETL using binary data conversion.
- [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): How to translate a working Postman API call into an Integrate.io ETL REST API source component.
- [ETL: AI Assistant](https://www.integrate.io/docs/etl/integrateio-ai-assistant.md): How to use the Integrate.io ETL AI Assistant to get help building and troubleshooting data pipelines.
- [ETL: Best Practices Guide](https://www.integrate.io/docs/etl/integrateio-best-practices-guide.md): Best practices for building efficient, reliable data pipelines in Integrate.io ETL.
- [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): Password requirements and security recommendations for Integrate.io ETL accounts.
- [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 documentation for the Integrate.io ETL REST API.
- [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): List of Integrate.io ETL IP addresses to allowlist in your firewall for direct database or SFTP access.
- [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)
- [ETL: intermediate-part02-ko](https://www.integrate.io/docs/etl/intermediate-part02-ko.md)
- [ETL: 중급 Part03：정규 표현을 사용해 데이터의 품질보장](https://www.integrate.io/docs/etl/intermediate-part03-ko.md)
- [ETL: 중급 Part04:DB관련 설정(Destination편)](https://www.integrate.io/docs/etl/intermediate-part04-ko.md)
- [ETL: 중급 Part05: DB관련 설정(Source편)](https://www.integrate.io/docs/etl/intermediate-part05-ko.md)
- [ETL: 중급 Part06: 워크플로우 기능에 대하여](https://www.integrate.io/docs/etl/intermediate-part06-ko.md)
- [ETL: 중급 Part07: 패키지의 Export/Import 기능](https://www.integrate.io/docs/etl/intermediate-part07-ko.md)
- [ETL: 중급 Part08: 변수의 참조범위에 대하여](https://www.integrate.io/docs/etl/intermediate-part08-ko.md)
- [ETL: 중급 Part9：Xplenty의 Rest API로 기존 업무와의 연계(1)](https://www.integrate.io/docs/etl/intermediate-part09-ko.md)
- [ETL: 중급 Part10：Xplenty의 Rest API로 기존 업무와의 연계(2)](https://www.integrate.io/docs/etl/intermediate-part10-ko.md)
- [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): Converts a JSON object string to a map of key-value pairs.
- [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): How to monitor running and completed jobs using the dashboard, cluster pages, API, or webhooks.
- [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)
- [ETL: 초급 Part02: 데이터 변환 기능의 사용법(1)](https://www.integrate.io/docs/etl/novice-part02-ko.md)
- [ETL: 초급 Part03 : Xplenty에서 자주 수행되는 문자열 조작](https://www.integrate.io/docs/etl/novice-part03-ko.md)
- [ETL: 초급 Part04: 데이터 변환 기능의 사용법(2)](https://www.integrate.io/docs/etl/novice-part04-ko.md)
- [ETL: 초급 Part05: Destination 설정](https://www.integrate.io/docs/etl/novice-part05-ko.md)
- [ETL: 초급 Part06: 패키지 확인 및 작업 결과 확인](https://www.integrate.io/docs/etl/novice-part06-ko.md)
- [ETL: 초급 Part07: 블랙박스화하지 않기 위한 메커니즘](https://www.integrate.io/docs/etl/novice-part07-ko.md)
- [ETL: 초급 Part08: 스케줄 설정](https://www.integrate.io/docs/etl/novice-part08-ko.md)
- [ETL: 초급 Part09: 알림기능에 대하여](https://www.integrate.io/docs/etl/novice-part09-ko.md)
- [ETL: 초급 Part10: 데이터 형식 변환](https://www.integrate.io/docs/etl/novice-part10-ko.md)
- [ETL: Xplenty에서 MySQL(RDS 및 Firewall 넘어에 있는 DB)에 연결하는 절차](https://www.integrate.io/docs/etl/onpremise-part01-ko.md)
- [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): How to integrate PagerDuty with Integrate.io ETL to receive real-time incident alerts for account activity.
- [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)
- [ETL: Google Sheet에서 데이터 검색](https://www.integrate.io/docs/etl/restapi-part02-ko.md)
- [ETL: Hubspot 데이터를 API로 가져오기](https://www.integrate.io/docs/etl/restapi-part03-ko.md)
- [ETL: Hubspot 데이터를 API로 갱신하기](https://www.integrate.io/docs/etl/restapi-part04-ko.md)
- [ETL: Integrate.io의 Curl 함수에 대한 철저한 설명 - Integrate.io Blog](https://www.integrate.io/docs/etl/restapi-part05-ko.md)
- [ETL: Curl Function을 사용한 데이타 갱신](https://www.integrate.io/docs/etl/restapi-part06-ko.md)
- [ETL: Shopify의 Product에 DB의 제품 데이터를 연결하는 방법은?](https://www.integrate.io/docs/etl/restapi-part07-ko.md)
- [ETL: Google 드라이브에서 파일 연동](https://www.integrate.io/docs/etl/restapi-part08-ko.md)
- [ETL: Extended JSON extraction을 통한 중첩 구조 전개](https://www.integrate.io/docs/etl/restapi-part09-ko.md)
- [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)
- [ETL: Salesforce 연결 Q&A](https://www.integrate.io/docs/etl/salesforce-part02-ko.md)
- [ETL: Salesforce에 데이터를 쓸 때 오류가 발생한 작업의 원인조사](https://www.integrate.io/docs/etl/salesforce-part03-ko.md)
- [ETL: Salesforce 데이터 업데이트 팁 모음](https://www.integrate.io/docs/etl/salesforce-part04-ko.md)
- [ETL: Integrate.io + Heroku Connect : Salesforce와 데이터 연동을 유연하게 (동영상 포함) - integrate.io Blog](https://www.integrate.io/docs/etl/salesforce-part05-ko.md)
- [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): How to schedule ETL packages to run automatically on a recurring basis in Integrate.io.
- [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): How to select and change your Integrate.io ETL plan based on cluster and node requirements.
- [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): How to configure webhook-based service hooks in Integrate.io ETL to receive API notifications for cluster and job events.
- [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): Changes a datetime value from its original time zone to a specified target time zone.
- [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)
- [ETL: Xplenty에서 Youtube Report API 데이터 가져오기](https://www.integrate.io/docs/etl/templates-part02-ko.md)
- [ETL: Xplenty 템플릿을 사용하여 간편하게 데이터 연계 : Taboola> 데이터 웨어 하우스편](https://www.integrate.io/docs/etl/templates-part03-ko.md)
- [ETL: 클라우드 ETL 'Xplenty'를 사용한 Shopify 데이터 획득부터 시각화까지](https://www.integrate.io/docs/etl/templates-part04-ko.md)
- [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): Splits a string into a bag of tokens using a specified delimiter or default separators.
- [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): How to configure the Crisp Chat component to read data in your Integrate.io ETL pipeline.
- [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): How to configure the Gmail component to read data in your Integrate.io ETL pipeline.
- [ETL: Google Sheets Destination](https://www.integrate.io/docs/etl/using-components-google-sheets-destination.md): How to configure the Google Sheets component to write data in your Integrate.io ETL pipeline.
- [ETL: Google Sheets Source](https://www.integrate.io/docs/etl/using-components-google-sheets-source.md): How to configure the Google Sheets component to read data in your Integrate.io ETL pipeline.
- [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: 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 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 with Curl as Rest API Destination](https://www.integrate.io/docs/etl/using-components-select-rest-api-destination.md): Configure the REST API destination to write data to any HTTP endpoint. Step-by-step tutorial using HubSpot contacts as a working example.
- [ETL: Select Transformation](https://www.integrate.io/docs/etl/using-components-select-transformation.md): How to configure the Select transformation to choose, rename, and reorder fields in your Integrate.io ETL pipeline.
- [ETL: SharePoint Source](https://www.integrate.io/docs/etl/using-components-sharepoint-source.md): How to configure the SharePoint component to read data in your Integrate.io ETL pipeline.
- [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: 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): How to build and configure data pipelines using the Integrate.io ETL package designer.
- [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/)