# 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"
}
}
```
{% hint style="warning" %}
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**.
{% endhint %}
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](https://docs.cloudio.io/creating-datasources/working-with-datasources/managing-datasources) page.