Before You Install the Recipe

You must perform the following configuration tasks on your Oracle ERP Cloud, Apache Kafka, and Oracle Autonomous Data Warehouse instances in order to successfully connect to these external systems using Oracle Integration and import orders.

Configure Oracle ERP Cloud

To access the Oracle ERP Cloud instance from Oracle Integration, you'll require a separate user account on Oracle ERP Cloud.

Log in to your Oracle ERP Cloud instance as an Administrator and perform the following tasks.
  1. Create a user account for Oracle Integration. Make a note of the user name and password you set for the account. You'll use the credentials of this user account to connect to Oracle ERP Cloud from Oracle Integration.
  2. Assign the following roles/privileges to the user account. See Assign Required Roles to an Integration User in Using the Oracle ERP Cloud Adapter with Oracle Integration 3.
    • Integration Specialist
    • AttachmentsUser
    • FND_MANAGE_CATALOG_SERVICE_PRIV
For more details, see Prerequisites for Creating a Connection in Using the Oracle ERP Cloud Adapter with Oracle Integration 3.

Configure Apache Kafka

Complete the following configuration tasks on your Apache Kafka instance to successfully connect to it from Oracle Integration and import orders.

  1. Get the Apache Kafka Cluster Bootstrap Server URL. See Prerequisites for Creating a Connection in Using the Apache Kafka Adapter with Oracle Integration 3.
  2. Install the connectivity agent.

    As Apache Kafka is hosted on-premise and is behind a firewall, you must install and configure the connectivity agent to allow Apache Kafka to interact with applications in the cloud.

    Before you install the connectivity agent, review the following topis in Using Integrations in Oracle Integration 3:

    To install and configure the connectivity agent:

    1. Create an agent group.
    2. Download and install the connectivity agent.
  3. Configure an Apache Kafka topic.
    1. From the command prompt execute the following command to create a topic named orders.
      kafka-topics.bat --bootstrap-server localhost:9092 --create --topic orders --partitions 2 --replication-factor 1

      You get a message that the topic is created.

    2. Create a consumer group.
      kafka-console-consumer.bat --bootstrap-server localhost:9092 --topic orders --group ordersconsumer
    3. To view the topic created.
      kafka-topics.bat --zookeeper 127.0.0.1:2181 –list
For more details, see Prerequisites for Creating a Connection in Using the Apache Kafka Adapter with Oracle Integration 3.

Configure Oracle Autonomous Data Warehouse

Complete configuration tasks in your Oracle Autonomous Data Warehouse instance to successfully connect to it using Oracle Integration and import orders.

The following steps give an overview of the tasks you need to perform to obtain information and details for configuring the Oracle Autonomous Data Warehouse connection from Oracle Integration. For more information on the steps, see Prerequisites for Creating a Connection in Using the Oracle Autonomous Data Warehouse Adapter with Oracle Integration 3.
  1. Download the client credentials wallet.
    This is a zip file containing the client security credentials. By default the file name is Wallet_<databasename>.zip. You can save this file as any file name you want.
  2. Get the ADW wallet password.
    You'll be prompted to enter a wallet password while downloading the client credentials wallet. Note the password as you'll need it while configuring the ADW connection security from Oracle Integration.
  3. Get the ADW database service name.
    Note that the service name must be same as the one in the tnsnames.ora file in the client credential wallet.
  4. Get the database service username and password to connect to the ADW database.
    The database service username is the schema username for the user to log in to the database. Note that the database service username is not the same as the database service name that you specify in the connection properties on the Connections window.
Additionally, create a database table to write the imported orders. Download the following SQL script - SQLScript.txt, and run it on your Oracle Autonomous Data Warehouse instance to create the required database table.