5.7 Create an Oracle Analytics Publisher Connection

Oracle Analytics Publisher enables you to author, generate, and deliver all types of highly formatted documents and operational reports. The Data Transforms Oracle Analytics Publisher connector allows you to extract report data from an ERP Cloud server and load it into Autonomous Database.
To use an Oracle Analytics Publisher connection in Data Transforms you need the URL of the BI Publisher web service used for the Oracle Analytics Publisher instance and BI Publisher report file that is output in the Data (CSV) format.
Note the following:
  • You cannot use an Oracle Analytics Publisher connection as a target for mapping.
  • Data load is not supported for Oracle Analytics Publisher connections.
This topic has the following sections:

Creating an Oracle Analytics Publisher 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 Analytics Publisher instance.

To define an Oracle Analytics Publisher 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 Analytics Publisher 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 Analytics Publisher 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 Analytics Publisher instance.
  11. In the Password text box enter the password for connecting to the Oracle Analytics Publisher 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 Analytics Publisher Server

For Oracle Analytics Publisher 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 Analytics Publisher:
  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 Analytics Publisher connection that you created in Creating an Oracle Analytics Publisher 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