Create a REST Server Connection

To create a generic REST connector, you need to provide the JDBC URL, username, and password to connect to the endpoint. You can also create and upload a config file that contains information such as the authentication methods, endpoints, and tables that you want to import data entities from.

The Application tab on the Create Connection page includes two connection options to create a generic REST connection - Generic REST and Generic REST Config. This topic has the following sections:

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.

Creating a Generic REST Connection

To create this connection you need to specify the REST service URL and choose a temporary schema where Data Transforms can create data entities after the reverse-engineering operation.

To define a REST server connection:

From the left pane of the Home page, click the Connections tab.
Connections page appears.
Click Create Connection.
Create Connection page slides in.
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.
Select Generic Rest as the connection type.
Click Next.
The Connection Name field is pre-populated with a default name. You can edit this value.
In the REST Service URL textbox, enter the URL of the endpoint that services the REST resources.
In the Proxy Host textbox, enter the host name of the proxy server to be used for the connection.
In the Proxy Port textbox, enter the port number of the proxy server.
In the User text box enter the user name for connecting to the REST endpoint.
In the Password text box enter the password for connecting to the REST endpoint.
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.
After providing all the required connection details, click Test Connection to test the connection.
Click Create.
The new connection is created.

Creating a Generic Rest Connection Using a Config File

APPLIES TO: Data Transforms that is available as a separate listing on Marketplace called Data Integrator: Web Edition.

To create a generic REST connector, you need the JDBC URL, username, password, and a config file. The config file is a model file with the file_name.rest naming convention that you need to upload when you create a REST Server connection. You need to specify the endpoints, table mappings, and the authentication methods to create the config file. You can create the config file using any text editor.

To define a REST server connection using a config file:

From the left pane of the Home page, click the Connections tab.
Connections page appears.
Click Create Connection.
Create Connection page slides in.
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.
Select Generic Rest Config as the connection type.
Click Next.
The Connection Name field is pre-populated with a default name. You can edit this value.
Use the Config File text box to upload the config file that you want to use.
In the JDBC URL textbox, enter the URL to connect to the server.
In the User and Password text boxes enter the user name and password for connecting to the REST endpoint. You may leave these fields blank if these values are not applicable or are already mentioned in the JDBC URL.
After providing all the required connection details, click Test Connection to test the connection.
Click Create.
The new connection is created.