With open source airbyte, can you pull data from b...
# replication-ask-ai
y
With open source airbyte, can you pull data from bigquery and push it into salesforce?
k
Yes, with open-source Airbyte you can. 1. Pull from BigQuery (source) Airbyte provides a BigQuery source connector. You configure it with a GCP project, a service account that has
BigQuery User
and
BigQuery Data Editor
roles, and the service account JSON key to read data from BigQuery. [[BigQuery source](https://docs.airbyte.com/integrations/sources/bigquery#getting-started)] 2. Push into Salesforce (destination) Airbyte has a Salesforce destination connector that syncs data from your warehouse into Salesforce objects using the Salesforce Bulk API and OAuth 2.0. It supports both Airbyte Cloud and self‑managed (open source) deployments, as long as you’re on Airbyte 1.8+ and have a Salesforce org with API access and a connected app (Client ID/Secret). [[Salesforce destination](https://docs.airbyte.com/integrations/enterprise-connectors/destination-salesforce)] So in a self‑managed (open source) Airbyte instance, you can: - Configure BigQuery as a source. - Configure Salesforce as a destination. - Create a connection from the BigQuery source to the Salesforce destination to move data from BigQuery tables into Salesforce objects. The docs do not show a single end‑to‑end example of “BigQuery → Salesforce” specifically, but they describe each connector and confirm both are supported in self‑managed Airbyte. [[BigQuery source](https://docs.airbyte.com/integrations/sources/bigquery#getting-started); [Salesforce destination setup](https://docs.airbyte.com/integrations/enterprise-connectors/destination-salesforce#setup-guide)]
y
@kapa.ai I don't see salesforce in the destination list in our open source airbyte?
k
A message from kapa.ai
The knowledge sources indicate that the Salesforce destination is an Enterprise connector and requires: - Airbyte version 1.8+ or Airbyte Cloud, and - It is documented under “Enterprise-connectors”, not the general open‑source destinations list. [[Salesforce destination](https://docs.airbyte.com/integrations/enterprise-connectors/destination-salesforce)] Because it’s categorized as an Enterprise connector, it may not appear in the destination list of a pure open‑source/Core deployment. The docs do not explicitly state that it is available in the free open‑source edition, only that it’s available for “Self‑Managed Enterprise” and Cloud. [[Salesforce destination](https://docs.airbyte.com/integrations/enterprise-connectors/destination-salesforce); [Sources/destinations overview](https://docs.airbyte.com/platform/move-data/sources-destinations-connectors)] If you specifically need Salesforce as a destination in a self‑hosted environment, the documented path is to use Self‑Managed Enterprise (which requires a license key) rather than the free open‑source/Core edition. [[Existing instance upgrades](https://docs.airbyte.com/platform/enterprise-setup/upgrading-from-community)]