Install and Configure the Recipe

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

Install the recipe on your Oracle Integration instance. See Install a Recipe or Accelerator.

After you've installed the recipe, configure the following resources:

Configure the FTP Read-Write Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    FTP Server Host Address Enter the host address of your sFTP server.
    FTP Server Port Enter 22.
    SFTP Connection Select Yes from the list.
  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select FTP Server Access Policy.
    User Name Enter the user name to connect to your sFTP server.
    Password Enter the password to connect to your sFTP server.
  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 Back icon.

Configure the Oracle NetSuite Connection

  1. In the Connections section, click the connection name.
  2. In the Properties section, enter the following details:
    Field Information to Enter
    WSDL URL

    Enter the NetSuite WSDL URL; for example, https://webservices.netsuite.com/wsdl/<NetSuite_application_version>/netsuite.wsdl.

    where <NetSuite_application_version> is the version of the NetSuite application. For example, v2015_1_0. See Assemble the Oracle NetSuite WSDL URL in Using the Oracle NetSuite Adapter with Oracle Integration 3.

  3. In the Security section, enter the following details:
    Field Information to Enter
    Security Policy Select Token Based Authentication.
    Consumer Key Enter the consumer key of the integration record in Oracle NetSuite. See Create an Integration Record for Oracle Integration in Using the Oracle NetSuite Adapter with Oracle Integration 3.
    Consumer Secret Enter the consumer secret of the integration record in Oracle NetSuite.
    Token Enter the token ID provided by Oracle NetSuite. See Create an Access Token for the User Account in Using the Oracle NetSuite Adapter with Oracle Integration 3.
    Token Secret Enter the token secret provided by Oracle NetSuite.
    Account ID Enter your Oracle NetSuite account identifier. See Make a Note of the NetSuite Account ID in Using the Oracle NetSuite Adapter with Oracle Integration 3.

    Note:

    You must enter this information in capital letters.
  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 Back icon.

Configure the Integration Flow

Create a schedule for your integration to pick up files from the FTP server at a date, time, and frequency of your choosing.

  1. In the Integrations section, click Actions Actions icon on the integration flow, then select Add Schedule.
    The page for defining the execution schedule is displayed.
  2. For this example, let's create a basic schedule, so leave the Simple radio button selected under the Define recurrence section.
  3. In the Frequency field, select Hours and Minutes, and change the hours field to 6.

    You've now created a schedule that runs the integration every six hours. Similarly, you can schedule the integration to run on particular days or weeks.

  4. Additionally, you can specify the start and end dates for this schedule. In the This schedule is effective section, click the From field and select Modify start date to specify a date and time from when this schedule should run. Similarly, specify an expiry date and time in the Until field. In addition, you can also specify your preferred timezone.
  5. To return to the project workspace, click Go back Back icon.

    To create advanced schedules, see Define the Integration Schedule in Using Integrations in Oracle Integration 3.