5.9 Create an Oracle Enterprise Resource Planning Cloud Connection

Oracle Enterprise Resource Planning (ERP) Cloud is a cloud based end-to-end Software as a service (SaaS) suite to manage functions such as accounting, financial management, project management, procurement, and risk management. The Data Transforms Oracle ERP Cloud connector allows you to extract report data from an ERP Cloud server and load it into Autonomous Database.
To use an Oracle ERP Cloud connection in Data Transforms you need the URL of the BI Publisher web service used for the Oracle ERP Cloud instance and BI Publisher report file that is output in the Data (CSV) format.
Note the following:
  • You cannot use an Oracle ERP Cloud connection as a target for mapping.
  • Data load is not supported for Oracle ERP Cloud connections.
This topic has the following sections:

Creating an Oracle ERP Cloud Server Connection

To create this connection, you need to specify the WSDL URL of the Report service and the username and password to connect to the ERP Cloud instance.

To define an Oracle ERP Cloud Server Connection:

  1. From the left pane of the Home page, click the Connections tab.

    Connections page appears.

  2. Click Create Connection.

    Create Connection page slides in.

  3. Do one of the following:
    • In the Select Type field, enter the name or part of the name of the connection type.
    • Select the Applications tab.
  4. Select Oracle ERP Cloud as the connection type.
  5. Click Next.
  6. The Connection Name field is pre-populated with a default name. You can edit this value.
  7. In the WSDL URL textbox, enter the URL of the BI Publisher web service used for the Oracle ERP Cloud instance. The format of the URL is BI Publisher Hostname/xmlpserver/services/PublicReportWSSService?wsdl.

    For example: https://fa-eudu-saasfademo1.ds-fa.oraclepdemos.com/xmlpserver/services/PublicReportWSSService?wsdl.

  8. In the Proxy Host textbox, enter the host name of the proxy server to be used for the connection.
  9. In the Proxy Port textbox, enter the port number of the proxy server.
  10. In the User text box enter the user name for connecting to the Oracle ERP Cloud instance.
  11. In the Password text box enter the password for connecting to the Oracle ERP Cloud instance.
  12. After providing all the required connection details, click Test Connection to test the connection.
  13. Click Create.

    The newly created connection is displayed in the Connections page.

    Click the Actions icon (Actions icon) next to the selected connection to perform the following operations:

    • Select Edit to edit the provided connection details.
    • Select Test Connection to test the created connection.
    • Click Export to export the connection. See Export Objects.
    • Select Delete Schema to delete schemas.
    • Select Delete Connection to delete the created connection.

    You can also search for the required connection to know its details based on the following filters:

    • Name of the connection.
    • Technology associated with the created connection.

Importing Data Entity Definitions from an Oracle ERP Cloud Server

For Oracle ERP Cloud connections, the Import Data Entities page requires input in key/value pairs. To import data, you need to specify the BIPReportLocation key, which refers to the location of the BI publisher report on the BI server. You can find this information on the BI server when the corresponding report is open.

To import data entities from Oracle ERP Cloud:
  1. From the left pane of the Home page, click the Data Entities tab.

    Data Entities page appears.

  2. Click Import Data Entities. The Import Data Entities page slides-in.
  3. In the Connection drop-down, select the Oracle ERP Cloud connection that you created in Creating an Oracle ERP Cloud Server Connection. The options on the page change to display only the Entity Name field.
  4. In the Entity Name field enter a name for the data entity.
  5. Enter BIPReportLocation in the Key field.
  6. Enter the location of the BI Publisher report file in the Value field corresponding to the key. Specify the path till the name of the ReportFile.xdo file.
  7. Click Start.

    A Job is created, and the corresponding Job ID is displayed for you to track the session. Click the Job ID to view the details of the job. Upon successful execution of the job, the data entity is displayed on the Data Entities page.

  8. Click the Actions icon (Actions icon) next to the selected Data Entity and select Edit.
    The Edit Data Entity page appears that displays a table with the following information:
    • Name
    • Data Type
    • Length
    • Scale
    • Not Null

    Verify the data type and length for the imported entities. Oracle Data Transforms determines the data types and length from the first record of the file, but may set default values (for example, 50 for the string field length) or incorrect data types. In case of an empty field, data type is set to String with length 50.

  9. Click Save.

Parent topic: Connections