1. Import Orders from Oracle ERP Cloud to Oracle Autonomous Data Warehouse
  2. Before You Install the Recipe

2 Before You Install the Recipe

You must perform the following configuration tasks on your Oracle ERP Cloud, Apache Kafka, and Oracle ADW 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.
    • Integration Specialist
    • AttachmentsUser
    • FND_MANAGE_CATALOG_SERVICE_PRIV
For more details, see Prerequisites for Creating a Connection.

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.
  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:

    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.

Configure Oracle ADW

Complete configuration tasks in your Oracle ADW 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 ADW connection from Oracle Integration. For more information on the steps, see Prerequisites for Creating a Connection.
  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 Oracle 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 ADW instance to create the required database table.