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. You can use…
Troubleshooting the Openflow Connector for Salesforce Bulk API
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 regions).
StandardSalesforceClientService
Provides connection service to Salesforce APIs Tags preview, salesforce Properties In the list below required Properties are shown with an asterisk (*). Other properties are considered optional. The table also indicates any default values,…
Set up the Openflow Connector for PostgreSQL
Ensure that you have reviewed About Openflow Connector for PostgreSQL. Ensure that you have reviewed the supported PostgreSQL versions. Recommended: Ensure that you add only one connector instance per runtime. Ensure that you have Set up…
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. Generates a CREATE OR REPLACE VIEW statement that combines…
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…
StandardSalesforceDataCloudClientService
Provides connection service to Salesforce Data Cloud APIs Tags daas, data cloud, preview, salesforce Properties In the list below required Properties are shown with an asterisk (*). Other properties are considered optional. The table also…
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…
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.
Region compatibility issues when connecting salesforce data cloud to snowflake
Identify the region where your Salesforce Data Cloud is hosted and confirm it aligns with your Snowflake account’s region. The Data Cloud in a region works with Snowflake - supported cloud platforms in that region and other regions on the…