Setting up live connectors

We need to setup up Live Connectors to access data from sources other than a database, that support API based CRUD operations.

To setup a Live Connector,

1. Login to the CloudIO platform. The CloudIO homepage is displayed.

2. In the upper right corner, in the menu bar, click .

The Navigation pane is displayed.

3. To setup a live connector, under Administration, click Live Connectors.

The Live Connectors page is displayed.

4. To setup a live connector using predefined service provider like Oracle SaaS or SFDC, open the corresponding service provider and click Add New Connection.

The Setup Connection widow is displayed. Enter the required connection details

5. To setup a generic REST service provider, open the generic REST service provider and click Add New Connection.

The Setup Connection widow is displayed. Enter the required connection details

6. To complete the configuration, update the describe API in Params JSON along with any other relevant attributes.

7. Copy and paste the following JSON excerpt in the Describe JSON.

{       
    "describe_api": "https://xxx.xx/{service_name}/describe",
    "root_node" : "fields",         
    "display_name": "label",        
    "column_name" :"name",      
    "data_type" : "type",       
     "primary_key" : "Id", 
    "data_length" : "length",                   
    "DOUBLE" : "percent,currency,double,int",       
    "VARCHAR2" : "string,picklist,phone,reference,ID,boolean,url,email,address,collection",          
    "DATE" :"dataTime,date"      
}

8. To create a connection, click Submit.