3 Install and Configure the Recipe

On your Oracle Integration instance, install the recipe to deploy and configure the integration and associated resources.

1. On the Oracle Integration Home page, in the Get started section, click Browse store.
2. Find the recipe you want to install, then click Get.

   A message confirms that the recipe was successfully installed, and the recipe card shows In use.

3. Click Configure on the recipe to configure its resources.

   The project workspace opens, displaying all the resources of the recipe. Configure the following resources before you activate and run the recipe.

Configure the Oracle Snowflake Connection

1. In the Connections section, click the connection name.
2. In the Properties section, enter the following details:

   Field	Information to Enter
   Instance URL	URL of your Snowflake account, typically provided by Snowflake when you sign up. See Configure Snowflake.
   Warehouse Name	Name of the Snowflake virtual warehouse where the data is stored and processed.
   Database Name	Name of the Snowflake database where the desired tables are located.
   Schema Name	Name of the schema within the specified database where the tables are located.

3. In the Security section, enter the following details:

   Field	Information to Enter
   Security Policy	Select Authorization Code Credentials.
   Client ID	Enter the Client Id of the account created for Oracle Integration on Snowflake. See Configure Snowflake.
   Client Secret	Enter the secret value of the account created for Oracle Integration on Snowflake.
   Scope (Optional Security)	refresh_token

4. Click Save. If prompted, click Save again.
5. 5. Click Provide Consent.
6. Once the consent is approved, click Test in the connection window to ensure that your connection is successfully configured, click Test again.

   A message confirms if your test is successful.

7. To return to the project workspace, click Go back .

Configure the Oracle GCP Storage Connection

1. In the Connections section, click the connection name.
2. In the Properties section, enter the unique identifier assigned to your GCP project in the Project Id field. This ID is used to authenticate requests and access resources within your project.
3. In the Security section, enter the following details:

   Field	Information to Enter
   Security Policy	Select Authorization Code Credentials.
   Google Client ID	Enter the Google Client Id of the account created for Oracle Integration on GCP Storage. See Configure GCP Storage.
   Google Client Secret	Enter the secret value associated with the Client ID.
   Google Authorization Scope	This refers to the specific permissions or scopes that the OAuth 2.0 credentials (Client ID and Client Secret) have been granted for accessing Google Cloud Storage (GCS). The scope determines what actions the integration can perform, such as read-only access or full access to GCS resources.

4. Click Save. If prompted, click Save again.
5. Click Provide Consent.
6. Once consent is approved, click Test on the connection window to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

   A message confirms if your test is successful.

7. To return to the project workspace, click Go back .

Configure the Oracle SFMC Connection

1. In the Connections section, click the connection name.
2. In the Properties section, enter the environment subdomain (A unique identifier) with which user needs to connect in the Subdomain field.
3. In the Security section, enter the following details:

   Field	Information to Enter
   Security Policy	Select Server-to-Server Integrations Security Policy.
   Client ID	Enter the client Id of the account created for Oracle Integration on SFMC. See Configure Salesforce Marketing Cloud.
   Client Secret	Enter the secret value of the account created for Oracle Integration on SFMC.

4. Click Save. If prompted, click Save again.
5. Click Test to ensure that your connection is successfully configured. In the resulting dialog, click Test again.

   A message confirms if your test is successful.

6. To return to the project workspace, click Go back .

Configure the Lookup Table

Edit the SNOWFLAKE_SFMC_LOOKUP lookup table and enter appropriate values.

1. In the Lookups section, click the lookup name.
2. In the Property_name column, enter the property name.
3. In the Property_value column, enter the values as shown in the below table to which the property names must be mapped.

   Property_name	Property_value
   StageName	Specify the stage name associated with the Snowflake endpoint.
   SubDirectory	Specify a sub directory within the specified stage.

4. Click Save. If prompted, click Save again.
5. To return to the project workspace, click Go back .