Connecting Salesforce to Snowflake in Informatica involves configuring connections for both systems within the Informatica Intelligent Cloud Services (IICS) platform. Here’s a breakdown of the steps:

1. Install the Snowflake Connector (if not already installed):

• In IICS, navigate to Administrator > Add-On Connectors.²
• Search for “Snowflake” and ensure the Snowflake Data Cloud Connector is installed. If not, you may need to start a free trial or contact your Informatica administrator.

2. Create a Salesforce Connection:

• Navigate to Administrator > Connections.³
• Click New Connection.
• In the “New Connection” window:
  • Connection Name: Provide a descriptive name for your Salesforce connection (e.g., Salesforce_Source).⁴
  • Type: Select Salesforce.
  • Runtime Environment: Choose the Secure Agent or Hosted Agent where the connection will run.⁵
  • Authentication: Select the authentication method:
    • Password: Enter your Salesforce Username, Password, and Security Token.
    • OAuth: You’ll need to configure a Connected App in Salesforce and provide the Consumer Key, Consumer Secret, and authorize the connection.⁶
  • Service URL: The default is usually https://login.salesforce.com/services/Soap/u/API_VERSION (replace API_VERSION with the desired Salesforce API version).
  • Click Test Connection to verify the details.
  • Click Save.

3. Create a Snowflake Connection:

• Navigate to Administrator > Connections.
• Click New Connection.
• In the “New Connection” window:
  • Connection Name: Provide a descriptive name for your Snowflake connection (e.g., Snowflake_Target).⁷
  • Type: Search for and select Snowflake Data Cloud.
  • Runtime Environment: Choose the Secure Agent or Hosted Agent where the connection will run.
  • Authentication: Select the authentication method:
    • Standard: Enter your Snowflake Username, Password, and Account. The Account is typically found in your Snowflake URL (e.g., if your URL is https://xyz123.snowflakecomputing.com, the account is xyz123).
    • AuthenticationCode (OAuth): Requires setting up an OAuth integration in Snowflake.
    • KeyPair: Uses a private key file for authentication.
  • Warehouse: Specify the Snowflake warehouse you want to use.
  • Database: Enter the target Snowflake database name.
  • Schema: Enter the target Snowflake schema name.
  • Role (Optional): Specify a Snowflake role to use for the connection.
  • Additional JDBC URL Parameters (Optional): You can add specific JDBC parameters if needed.
  • Click Test Connection to verify the details.
  • Click Save.

4. Create a Data Integration Mapping:

• Navigate to Data Integration.
• Click New and select Mapping.
• In the Mapping Designer:
  • Source: Drag a Source transformation onto the canvas.
    • Configure the Source to use your Salesforce Connection.
    • Select the Salesforce object you want to extract data from (e.g., Account, Contact).
    • You can use a SOQL query to filter or select specific data.⁸
  • (Optional) Transformations: Add any necessary transformations (e.g., Filter, Join, Expression) to manipulate the data.
  • Target: Drag a Target transformation onto the canvas.
    • Configure the Target to use your Snowflake Connection.
    • Select the target Snowflake table. You can choose an existing table or create a new one.
    • Define the operation (e.g., Insert, Update, Upsert).
  • Field Mapping: Connect the fields from the Source (and any transformations) to the corresponding fields in the Target.

5. Create a Mapping Task:

• Navigate to Data Integration.
• Click New and select Task > Mapping Task.
• Configure the Mapping Task:
  • Name: Provide a name for the task.
  • Mapping: Select the mapping you created in the previous step.
  • Runtime Environment: Choose the Secure Agent or Hosted Agent to run the task.
  • Configure any scheduling or advanced options as needed.

6. Run the Mapping Task:

• Select the Mapping Task and click Run.
• Monitor the task in the Monitor section of IICS to check for success or errors.

By following these steps, you can successfully connect Salesforce to Snowflake in Informatica IICS and build data pipelines to move and transform your data. Remember to consult the Informatica and Snowflake documentation for more advanced configurations and troubleshooting.