5.7 Create an Oracle Financials Cloud Connection

You can fetch real time transactional data from Oracle Financials Cloud REST endpoints, import the data entities into Data Transforms, and use them as a source in a data flow.

To create an Oracle Financials Cloud connection you need to choose a temporary schema where Data Transforms can create data entities after the reverse-engineering operation.

To define an Oracle Financials Cloud 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 Financials 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 REST Service URL textbox, enter the URL of the endpoint that services the REST resources.
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 REST endpoint.
11. In the Password text box enter the password for connecting to the REST endpoint.
12. Choose a connection from the Staging Connection drop-down list. The list displays only existing Autonomous Database connections. To use a different connection, create the connection before you reach this page.
13. After providing all the required connection details, click Create.
    The new connection is created.
14. Click Test Connection, to test the established connection.

The newly created connections are displayed in the Connections page.

Click the 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.
• 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.