Source
About the Openflow Connector for Salesforce Bulk API
The connector uses public Salesforce REST APIs to replicate data from Salesforce to Snowflake at a user - defined frequency. The connector supports Change Data Capture (CDC) and keeps data in Snowflake in sync with Salesforce.
Openflow Connector for Salesforce Bulk API: Configure the connector
Navigate to the Openflow Overview page. In the Featured connectors section, select View more connectors. On the Openflow connectors page, find Openflow connector for Salesforce Bulk API and select Add to runtime. In the Select runtime…
Openflow Connector for Salesforce Bulk API: Set up Salesforce
The connector authenticates with Salesforce using the OAuth 2.0 JWT Bearer Flow. This requires creating a certificate key pair, configuring an external client app in Salesforce, and authorizing a user to use the app. ImportantSalesforce…
Openflow Connector for Salesforce Bulk API: Set up Snowflake
Feature — Generally AvailableSnowflake connectors are supported in every region where Snowflake Openflow is available.Snowflake Openflow on BYOC deployments are available to all accounts in AWS Commercial Regions only (Commercial…
Resolving S3 Cross-Region Access Errors When Using Salesforce Data Cloud Connector with Snowflake Open Catalog (Polaris)
The issue is typically observed when the S3 bucket and the connector are in different AWS regions. CAUSE: The root cause is a missing or incorrect region configuration in the Open Catalog (Polaris) catalog. Without the region set, the…
StandardSalesforceDataCloudClientService
Deployments are available to all accounts in AWS, Azure, and GCP Commercial regions.Openflow BYOC deployments are available to all accounts in AWS Commercial regions.
Troubleshooting the Openflow Connector for Salesforce Bulk API
Feature — Generally AvailableSnowflake connectors are supported in every region where Snowflake Openflow is available.Snowflake Openflow on BYOC deployments are available to all accounts in AWS Commercial Regions only (Commercial…
Openflow Connector for Salesforce Bulk API: Salesforce formula fields
Retrieves the formula expressions from the Salesforce object metadata via the Describe API. Parses each formula expression and translates it into equivalent Snowflake SQL.
StandardSalesforceClientService
Deployments are available to all accounts in AWS, Azure, and GCP Commercial regions.Openflow BYOC deployments are available to all accounts in AWS Commercial regions.
SalesforceDataCloudOAuthTokenProvider
Retrieves an OAuth2 access token from Salesforce using the configured OAuth2 Access Token Provider and exchanges the token for a Data Cloud API token. The token is then used to authenticate with Salesforce Data Cloud APIs.