Generating a data source

A quick way for creating a data source is by auto-generating it from a database table or a view. Here, we don't provide the table name while generating the data source. Instead, we fetch the required data by defining pre-queries and post queries.

1. In the top right corner of the menu bar, click . The navigation pane is displayed.

2. Under the required role group, click Manage Datasources.

The Manage DataSources page with the list of datasources is displayed.

3. In the upper right corner of the Manage Datasources page, click Generate Datasource.

The Generate Datasource window is displayed.

4. In SQL Query or Table Name, enter the API name without the environment URL or paste the data in JSON format.

Sample JSON:

{
 "Employee": {
 "FirstName": "Sriaknth",
 "LastName": "A"
 }
}

Note

This field must be left blank if the data source is being generated using a database object.

Enter the value in this field only if the data source is being generated using a live connector.

5. Define the datasource details:

Datasource detail	Description
Datasource Name	A unique name for the datasource Note: The datasource name field does not accept any spaces and special characters.
Assign To Role	The role to which the datasource is to be assigned
Params	Note: Do not enter any value here.
Object Connection Code	A connection code for connecting to different schemas/databases. Note: The object connection details of these schemas/databases must be defined in the Setup page. If you are using the default application schema under the current subdomain, you must not select any Object Connection Code.
Access permission checkboxes: Insert Allowed Update Allowed Query Allowed Audit Allowed	Indicate the access privileges to the role

6. Click Generate.

The datasource is generated. You can further edit and define details from the Manage Datasources page.